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