jamrello
Tables (7)
board
- id — Long — Primary key — NOT NULL
- title — varchar — NOT NULL
- background_color — varchar — NOT NULL
- status — boolean — NOT NULL
- created_at — LocalDateTime — NOT NULL
- modified_at — LocalDateTime — NOT NULL
- image_url — varchar
card_collaborator
- id — Long — Primary key — NOT NULL
- card_id — Long — Foreign key → cards.id — NOT NULL
- user_id — Long — Foreign key → member.id — NOT NULL
cards
- id — Long — Primary key — NOT NULL
- column_id — Long — Foreign key → catalog.id — NOT NULL
- tilte — varchar — NOT NULL
- description — varchar
- background_color — varchar — NOT NULL
- status — boolean — NOT NULL
- start_day — Timestamp
- due_day — Timestamp
- image_url — varchar
- position — Long — NOT NULL
- created_at — Timestamp — NOT NULL
- modified_at — Timestamp — NOT NULL
catalog
- id — Long — Primary key — NOT NULL
- board_id — Long — Foreign key → board.id — NOT NULL
- title — varchar — NOT NULL
- status — boolean — NOT NULL
- position — Long — NOT NULL
- created_at — Timestamp — NOT NULL
- modified_at — Timestamp — NOT NULL
comment
- id — Long — Primary key — NOT NULL
- card_id — Long — Foreign key → cards.id — NOT NULL
- user_id — Long — Foreign key → member.id — NOT NULL
- content — varchar — NOT NULL
- created_at — Timestamp — NOT NULL
- modified_at — Timestamp — NOT NULL
member
- id — Long — Primary key — NOT NULL
- username — varchar — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar — NOT NULL
- email — varchar — NOT NULL
- created_at — LocalDateTime — NOT NULL
- modified_at — Timestamp — NOT NULL
user_board
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → member.id — NOT NULL
- board_id — Long — Foreign key → board.id — NOT NULL
- role — varchar — NOT NULL