sw

Tables (4)

boards (board)

  • board id (id) — int — Primary key — NOT NULL
  • title — varchar(225)
  • contents — longtext
  • date (created_date) — datetime
  • user ID (user_id) — int — Foreign key → users.user ID — NOT NULL

comments

  • comment id (id) — int — Primary key — NOT NULL
  • contents — longtext
  • date (created_date) — datetime
  • username (name) — varchar(225)
  • board id (board_id) — int — Foreign key → boards.board id — NOT NULL
  • user ID (user_id) — int — Foreign key → users.user ID — NOT NULL

likes

  • id — int — Primary key — NOT NULL
  • user ID (user_id) — int — Foreign key → users.user ID — NOT NULL
  • board id (board_id) — int — Foreign key → boards.board id — NOT NULL

users

  • user ID (id) — int — Primary key — NOT NULL
  • user pw (password) — varchar(225)
  • user name (username) — varchar(225)
  • user email (email) — varchar(225)