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