test1

Tables (5)

board

  • board_id — uuid
  • owner_user_id — uuid — Foreign key → profile.user_id — NOT NULL
  • board_name — text — NOT NULL
  • description — text
  • board_type — text — NOT NULL
  • color — text
  • is_archived — boolean — NOT NULL
  • note — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

issue

  • issue_id — uuid
  • milestone_id — uuid — Foreign key → milestone.milestone_id — NOT NULL
  • board_id — uuid — Foreign key → board.board_id — NOT NULL
  • owner_user_id — uuid — Foreign key → profile.user_id — NOT NULL
  • assignee_user_id — uuid — Foreign key → profile.user_id
  • title — text — NOT NULL
  • description — text
  • status — text — NOT NULL
  • priority — text — NOT NULL
  • start_date — date
  • due_date — date
  • sort_order — integer — NOT NULL
  • estimate_points — numeric(6,2)
  • note — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

milestone

  • milestone_id — uuid
  • board_id — uuid — Foreign key → board.board_id — NOT NULL
  • owner_user_id — uuid — Foreign key → profile.user_id — NOT NULL
  • title — text — NOT NULL
  • description — text
  • status — text — NOT NULL
  • start_date — date
  • due_date — date
  • sort_order — integer — NOT NULL
  • note — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

profile

  • user_id — uuid
  • display_name — text — NOT NULL
  • avatar_url — text
  • timezone — text — NOT NULL
  • note — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

sub_issue

  • sub_issue_id — uuid
  • issue_id — uuid — Foreign key → issue.issue_id — NOT NULL
  • owner_user_id — uuid — Foreign key → profile.user_id — NOT NULL
  • title — text — NOT NULL
  • description — text
  • status — text — NOT NULL
  • priority — text — NOT NULL
  • due_date — date
  • sort_order — integer — NOT NULL
  • note — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL