Board_API

Tables (3)

USER (users)

  • (user_id) — NOT NULL — Primary key — NOT NULL
  • username — NOT NULL — NOT NULL
  • password — NOT NULL
  • role — NOT NULL — NOT NULL

board

  • board_id — NOT NULL — Primary key — NOT NULL
  • (user_id) — NOT NULL — Foreign key → USER.user_id — NOT NULL
  • title — NOT NULL — NOT NULL
  • contents — NOT NULL — NOT NULL
  • create_date — NOT NULL — NOT NULL

comment

  • comment_id — NOT NULL — Primary key — NOT NULL
  • (user_id) — NOT NULL — Foreign key → USER.user_id — NOT NULL
  • board_id — NOT NULL — Foreign key → board.board_id — NOT NULL
  • comments — NOT NULL — NOT NULL
  • create_date — NOT NULL — NOT NULL