Reference
The canonical data model. Tables are color-coded by category: regulated tables carry provenance and require a Part 11 signature to promote staging → live. Click any table in the diagram to jump to its details card below, or open `/schema?table=study` to deep link.
Tables
15
Columns
174
Foreign keys
20
Regulated tables
9
Carries created_at / updated_at / created_by / provenance_id. Promotion requires a Part 11 signature.
Where agents land their writes. State machine: proposed → reviewing → signed → promoted.
Append-only provenance and ops logs. Not part of the regulated write path.
External or read-only data we index but do not own.
2 of 15 tables shown (Reference only)
cro
pgvector-backed semantic index for the knowledge-RAG agent. Embeddings live alongside source text and citation metadata.
| Column | Type | Key | References | Notes |
|---|---|---|---|---|
id | uuid | PK | — | |
source_kind | text | required | — | |
source_uri | text | required | — | |
chunk_index | integer | required | — | |
content | text | required | — | |
embedding | jsonb | required | — | vector(1536) |
metadata | jsonb | required | — | |
created_at | timestamptz | required | — | |
updated_at | timestamptz | required | — |
auth
Supabase Auth user table. Referenced by created_by / created_by_user_id on every regulated row. Owned by Supabase Auth; we read but do not write.
| Column | Type | Key | References | Notes |
|---|---|---|---|---|
id | uuid | PK | — | |
email | text | nullable | — | |
encrypted_password | text | nullable | — | |
email_confirmed_at | timestamptz | nullable | — | |
raw_app_meta_data | jsonb | nullable | — | |
raw_user_meta_data | jsonb | nullable | — | |
last_sign_in_at | timestamptz | nullable | — | |
created_at | timestamptz | required | — | |
updated_at | timestamptz | required | — |