trello2
Tables (10)
attachment
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- origin_file_name — varchar(255)
- path — varchar(255)
- card_id — bigint
- user_id — bigint
board
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- background_color — varchar(7) — NOT NULL
- title — varchar(100) — NOT NULL
- workspace_id — bigint — NOT NULL
board_list
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- order_num — int
- title — varchar(255) — NOT NULL
- board_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
card
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- content — varchar(255)
- title — varchar(255)
- board_list_id — bigint
- user_id — bigint
card_log
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- member_email — varchar(255)
- status — enum — NOT NULL
- card_id — bigint
- user_id — bigint
card_member
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- card_id — bigint
- user_id — bigint
comment
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- comment — varchar(255) — archar(255) nul
- card_id — bigint
- user_id — bigint
member
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- member_role — enum — NOT NULL
- user_id — bigint — NOT NULL
- workspace_id — bigint — NOT NULL
users
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted — bit
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum — NOT NULL
workspace
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- description — varchar(300) — NOT NULL
- title — varchar(100) — NOT NULL