katalyst-db
Tables (14)
comments
- id — bigserial
- content — text — NOT NULL
- issue_id — bigint — Foreign key → issues.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
issue_activities
- id — bigserial
- issue_id — bigint — Foreign key → issues.id — NOT NULL
- actor_id — bigint — Foreign key → users.id
- verb — varchar(255) — NOT NULL
- field_changed — varchar(100)
- old_value — text
- new_value — text
- comment_id — bigint — Foreign key → comments.id
- created_at — timestamptz — NOT NULL
issue_labels
- id — bigserial
- issue_id — bigint — Foreign key → issues.id — NOT NULL
- label_id — bigint — Foreign key → labels.id — NOT NULL
issue_subscribers
- id — bigserial
- issue_id — bigint — Foreign key → issues.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
issues
- id — bigserial
- title — varchar(255) — NOT NULL
- description — text
- project_id — bigint — Foreign key → projects.id — NOT NULL
- state_id — bigint — Foreign key → states.id — NOT NULL
- parent_id — bigint — Foreign key → issues.id
- creator_id — bigint — Foreign key → users.id — NOT NULL
- assignee_id — bigint — Foreign key → users.id
- priority — varchar(50) — NOT NULL
- type — varchar(50) — NOT NULL
- start_date — date
- due_date — date
- comment_count — int — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
labels
- id — bigserial
- name — varchar(255) — NOT NULL
- project_id — bigint — Foreign key → projects.id — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
notifications
- id — bigserial
- recipient_id — bigint — Foreign key → users.id — NOT NULL
- actor_id — bigint — Foreign key → users.id
- verb — varchar(255) — NOT NULL
- target_type — varchar(50)
- target_id — bigint
- is_read — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
project_members
- id — bigserial
- project_id — bigint — Foreign key → projects.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- role_id — bigint — Foreign key → roles.id — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
projects
- id — bigserial
- name — varchar(255) — NOT NULL
- project_key — varchar(10) — NOT NULL
- workspace_id — bigint — Foreign key → workspaces.id — NOT NULL
- default_assignee_id — bigint — Foreign key → users.id
- project_lead_id — bigint — Foreign key → users.id
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
roles
- id — bigserial
- name — varchar(100) — NOT NULL
- project_id — bigint — Foreign key → projects.id
- permissions — jsonb
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
states
- id — bigserial
- name — varchar(255) — NOT NULL
- color — varchar(7) — NOT NULL
- project_id — bigint — Foreign key → projects.id — NOT NULL
- sequence — float8 — NOT NULL
- group — varchar(50) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
users
- id — bigserial
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- full_name — varchar(255)
- avatar_url — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
workspace_members
- id — bigserial
- workspace_id — bigint — Foreign key → workspaces.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- role_id — bigint — Foreign key → roles.id — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
workspaces
- id — bigserial
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- owner_id — bigint — Foreign key → users.id — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL