CMDB Relational Database Schema (ER Diagram)
Click a table to highlight FK relationships — Locations → Servers → Applications
Schema Reference
Locations
PK
location_id
INTEGER
data_center
VARCHAR(100)
city
VARCHAR(100)
region
VARCHAR(50)
Servers
PK
server_id
INTEGER
hostname
VARCHAR(255)
ip_address
VARCHAR(15)
FK
location_id
INTEGER
purchase_date
DATE
status
VARCHAR(20)
Applications
PK
app_id
INTEGER
app_name
VARCHAR(255)
version
VARCHAR(50)
FK
server_id
INTEGER
owner_team
VARCHAR(100)
Click a table to explore
Click any table node to highlight its foreign key relationships and see cardinality details.
Click nodes to highlight.
Scroll to zoom, drag to pan.