Data model

"CIO_TOPIC_MAPPING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "cio_topic_id": VARCHAR 
  "deleted_at": DATETIME 
  "topic_identifier": VARCHAR(255) 
}
"MESSAGE_CATALOG_ENTRY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "_metadata": JSONB 
  "app_name": VARCHAR(255) 
  "area_name": VARCHAR 
  "crew_id": UUID 
  "crew_name": VARCHAR 
  "deleted_at": DATETIME 
  "discovery_type": VARCHAR(255) 
  "is_active": BOOLEAN 
  "key": VARCHAR 
  "last_seen_at": DATETIME 
  "llm_description": TEXT 
  "llm_eval_score": INTEGER 
  "llm_name": TEXT 
  "name": VARCHAR 
  "ownership_confirmed": BOOLEAN 
  "sending_pattern": VARCHAR(255) 
  "source": VARCHAR(255) 
  "topic_assignment_confirmed": BOOLEAN 
  "topic_identifier": VARCHAR(255) 
}
"MESSAGE_BLUEPRINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "_metadata": JSONB 
  "channel": VARCHAR(255) 
  "deleted_at": DATETIME 
  "is_active": BOOLEAN 
  "key": VARCHAR 
  "llm_description": TEXT 
  "llm_eval_score": INTEGER 
  "llm_name": TEXT 
  "message_catalog_entry_id": UUID 
  "name": VARCHAR 
  "sending_pattern": VARCHAR(255) 
  "source": VARCHAR(255) 
  "subject": TEXT 
  "template_content": TEXT 
  "template_variables": ARRAY 
}
"MESSAGE_CATALOG_CREW_ASSIGNMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "actor_email": VARCHAR 
  "area_name": VARCHAR 
  "crew_id": UUID 
  "crew_name": VARCHAR 
  "message_catalog_entry_id": UUID 
}
"USER_TOPIC_SUBSCRIPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "global_user_id": VARCHAR 
  "subscribed": BOOLEAN 
  "topic_identifier": VARCHAR(255) 
}
"MESSAGE_CATALOG_ENTRY"."id" -> "MESSAGE_BLUEPRINT"."message_catalog_entry_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"MESSAGE_CATALOG_ENTRY"."id" -> "MESSAGE_CATALOG_CREW_ASSIGNMENT"."message_catalog_entry_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom