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')