Spring Level3
Tables (6)
Board (board)
- Board_Id (board_id) — bigint — Primary key
- Board_Name (board_name) — varchar(255)
- Board_Color (board_color) — varchar(255)
- Board_Info (board_info) — varchar(255)
- Init_User_Id (init_user_id) — bigint
Card (card)
- Card_Id (card_id) — bigint — Primary key
- Column_Id (column_id) — bigint — Foreign key → Column.Column_Id
- Board_Id (board_id) — bigint — Foreign key → Column.Board_Id
- Card_Name (card_name) — varchar(255)
- Card_Info (card_info) — varchar(255)
- Card_Color (card_color) — varchar(255)
- Nick_Name (nick_name) — varchar(255)
- Dead_line (dead_line) — datetime(6)
Column (column)
- Column_Id (column_id) — bigint — Primary key
- Board_Id (board_id) — bigint — Foreign key → Board.Board_Id
- Column_Name (column_name) — varchar(255)
Comment (comment)
- Comment_Id (comment_id) — bigint — Primary key
- Card_Id (card_id) — bigint — Foreign key → Card.Card_Id
- Column_Id (column_id) — bigint — Foreign key → Card.Column_Id
- Board_Id (board_id) — bigint — Foreign key → Card.Board_Id
- User_Id (user_id) — bigint
- Comment_Info (comment_info) — varchar(255)
- Nick_Name (nick_name) — varchar(255)
UserBoard (userboard)
- User_Board_Id (user_board_id) — bigint — Primary key
- User_Id (user_id) — bigint
- Board_Id (board_id) — bigint
UserInfo (userinfo)
- User_Id (user_id) — bigint — Primary key
- Password (password) — varchar(255)
- NickName (nickname) — varchar(255)
- Role (role) — enum('ADMIN', 'USER')