simple board

Tables (3)

Board (게시판)

  • id (게시판 번호) — int — Primary key — NOT NULL
  • name (게시판 이름) — char
  • description (게시판 설명) — char

User (계정)

  • id (Key) — int — Primary key — NOT NULL
  • username (유저명) — char
  • email (이메일) — char
  • password (비밀번호) — char

posts (게시글)

  • id (pk) — int — Primary key — NOT NULL
  • author_id (유저명) — char — Foreign key → User.id — NOT NULL
  • board_id (게시판번호) — int — Foreign key → Board.id — NOT NULL
  • title (제목) — char
  • body (내용) — char
  • Field