Configurations Schema

Configurations manages configuration items and relationships between them.

Tables

configuration_items

Tenant-scoped configuration item object.

• Primary key: id
• Required fields: tenant_id, name
• Optional fields: ci_type, description, archived_at
• Foreign key: tenant_id -> tenants.id
• Unique key: (tenant_id, name)

configuration_item_relationships

Directed relationship between two configuration items in the same tenant.

• Primary key: id
• Required fields: tenant_id, source_ci_id, target_ci_id, relationship_type
• Foreign keys:
  • tenant_id -> tenants.id
  • source_ci_id -> configuration_items.id
  • target_ci_id -> configuration_items.id
• Unique key: (tenant_id, source_ci_id, target_ci_id, relationship_type)

Relationship Notes

• Configuration items can be archived and restored without losing relationships.
• Relationships are tenant-scoped and cannot connect a configuration item to itself.