DataModeling

Tables (3)

board

  • idx (IDX) — AUTO_INCREMENT — Primary key — NOT NULL
  • id (userID) — NOT NULL — Foreign key → user.id — NOT NULL
  • title (TITLE) — NOT NULL
  • content (CONTENT) — NOT NULL
  • time (TIME) — NOT NULL
  • sawCount (SAWCOUNT) — NOT NULL
  • Field

comment

  • idx (IDX) — AUTO_INCREMENT — Primary key — NOT NULL
  • id (boardID) — NOT NULL — Foreign key → board.idx — NOT NULL
  • id (userID) — NOT NULL — Foreign key → board.id — NOT NULL
  • content (CONTENT) — NOT NULL
  • time (TIME) — NOT NULL

user

  • id (ID) — NOT NULL — Primary key — NOT NULL
  • name (NAME) — NOT NULL