Requirement Statement
Tables (7)
Untitled (users)
- Key (id) — uuid — Primary key — NOT NULL
- Field (name) — text
- Field (email) — text
- Field (role) — text
- Field (auth_type) — text
- Field (salt) — text
- Field (created_at) — date
- Field (updated_at) — date
Untitled (projects)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (name) — text
- Field (client_name) — text
- Field (status) — text
- Field (created_at) — date
- Field (updated_at) — date\
Untitled (requirments)
- Key (id) — uuid — Primary key — NOT NULL
- Key (project_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (title) — text
- Field (status) — text
- Field (created_at) — date
- Field (updated_at) — date
Untitled (requirment_versions)
- Key (id) — uuid — Primary key — NOT NULL
- Key (requirement_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (spec) — jsonb
- Field (ai_summary) — text
- Field (created_at) — date
- Field (updated_at) — date
Untitled (docs)
- Key (id) — uuid — Primary key — NOT NULL
- Key (project_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (path) — text
- Field (kind) — text
- Field (ai_flags) — jsonb
- Field (created_at) — date
- Field (updated_at) — date
Untitled (approvals)
- Key (id) — uuid — Primary key — NOT NULL
- Key (project_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Key (approver_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (step) — text
- Field (status) — text
- Field (created_at) — date
- Field (updated_at) — date
Untitled (user_auths)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — uuid — Foreign key → Untitled.Key — NOT NULL
- Field (hashed_token) — text
- Field (created_at) — date
- Field (updated_at) — date