JAMMIN
Tables (7)
boards (board)
- Key (id) — Long — Primary key — NOT NULL
- Field1 (title) — varchar — NOT NULL
- Field2 (username) — varchar — NOT NULL
- Field7 (background_color) — varchar
- Field3 (status) — boolean — NOT NULL
- 생성날짜 (created_at) — LocalDateTime — NOT NULL
- 수정날짜 (modified_at) — LocalDateTime — NOT NULL
card_collaborators (CardCollaborators)
- Key (Key2) — Long — Foreign key → cards.Key — NOT NULL
- Key — Long — Foreign key → member.Key — NOT NULL
cards (card)
- Key (id) — Long — Primary key — NOT NULL
- Key (column_id) — Long — Foreign key → catalogs.Key — NOT NULL
- Field1 (tilte) — varchar — NOT NULL
- Field2 (username) — varchar — NOT NULL
- Field3 (description) — varchar
- Field10 (background_color) — varchar
- Field9 (status) — boolean
- Field8 (start_day) — Timestamp
- Field7 (due_day) — Timestamp — NOT NULL
- Field (position) — Long — NOT NULL
- 생성날짜 (created_at) — Timestamp — NOT NULL
- 수정날짜 (modified_at) — Timestamp — NOT NULL
- Field (image_url) — varchar
catalogs (column)
- Key (id) — Long — Primary key — NOT NULL
- Key (board_id) — Long — Foreign key → boards.Key — NOT NULL
- Field1 (title) — varchar — NOT NULL
- Field2 (status) — boolean — NOT NULL
- 생성날짜 (created_at) — Timestamp — NOT NULL
- 수정날짜 (modified_at) — Timestamp — NOT NULL
- Field (position) — Long — NOT NULL
comments (comment)
- Key (id) — Long — Primary key — NOT NULL
- Key (card_id) — Long — Foreign key → cards.Key — NOT NULL
- Key (user_id) — Long — Foreign key → member.Key — NOT NULL
- Field2 (content) — varchar — NOT NULL
- 생성날짜 (created_at) — Timestamp — NOT NULL
- 수정날짜 (modified_at) — Timestamp — NOT NULL
member (user)
- Key (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 (UserBoard)
- Key (id) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → member.Key — NOT NULL
- Key (board_id) — Long — Foreign key → boards.Key — NOT NULL
- Field (role) — varchar — NOT NULL