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