Kumoss core-db Schema

Kumoss core-db Schema An architecture diagram generated by Archify. users · issuer + subject, roles · Architecture component users issuer + subject, roles sessions · uuid, operation, locks · Deleted with the session sessions uuid, operation, locks workspaces · uri, branch, root_path · Deleted with the session workspaces uri, branch, root_path terraform_providers · provider, scope_id · Deleted with the session terraform_providers provider, scope_id rounds · number, query · Deleted with the session rounds number, query statuses · status, message · Deleted with the session statuses status, message histories · first_query, payload · Deleted with the session histories first_query, payload pull_requests · provider, number, url · Deleted with the session pull_requests provider, number, url terraform_plans · targets (text[]) · Deleted with the session terraform_plans targets (text[]) reports · type · Deleted with the session reports type code_changes · file_name · Deleted with the session code_changes file_name artifacts · uri, content_type, size · Architecture component artifacts uri, content_type, size Deleted with the session Legend Table Identity and roles

Keys

  • • Every table: id, created_at, updated_at
  • • A child's foreign key is <parent>_id, indexed
  • • users unique on (issuer, subject)
  • • rounds unique on (session_id, number)

Ownership

  • • One chain: users to sessions to rounds
  • • statuses hang off both a session and a round
  • • artifacts are shared, never session-scoped

Lifecycle

  • • Cascades live in the ORM, not in the DDL
  • • Dashed: the one link that does not cascade
  • • No migrations; the schema comes from create_all