Schema¶

Generated by stratum on 2026-10-15T10:46:29Z from testdata/migrations.

Tables¶

audit_log
orgs
users

ERD¶

erDiagram
    audit_log {
        bigserial id PK
        int legacy_id FK
        text note
    }
    orgs {
        serial id PK
        varchar_255 name "unique"
        varchar_64 slug "unique"
    }
    users {
        serial id PK
        varchar_255 email "unique"
        int org_id FK
        boolean is_active
        timestamptz created_at
        text display_name
        int manager_id FK
    }
    audit_log }o--o| legacy_events : "legacy_id"
    users }o--o| users : "manager_id"
    users }o--|| orgs : "org_id"

audit_log¶

Columns¶

Name	Type	Nullable	Constraints
id	`bigserial`	no	PK
legacy_id	`int`	yes	FK
note	`text`	yes

Foreign Keys¶

Name	Columns	References
—	legacy_id	legacy_events (id)

orgs¶

Columns¶

Name	Type	Nullable	Constraints
id	`serial`	no	PK
name	`varchar(255)`	no	unique
slug	`varchar(64)`	yes	unique

Indexes¶

Name	Columns	Unique
—	slug	yes
uq_orgs_name	name	yes

users¶

Columns¶

Name	Type	Nullable	Default	Constraints
id	`serial`	no		PK
email	`varchar(255)`	no		unique
org_id	`int`	no		FK
is_active	`boolean`	no	`true`
created_at	`timestamptz`	yes	`now()`
display_name	`text`	yes
manager_id	`int`	yes		FK

Indexes¶

Name	Columns	Unique
—	email	yes
idx_users_org_id	org_id	no
uq_users_email	email	yes

Foreign Keys¶

Name	Columns	References
—	org_id	orgs (id)
fk_users_manager	manager_id	users (id)

Checks¶

email <> ''