board

Tables (3)

Board

  • Board ID (board_id) — INTEGER — Primary key — NOT NULL
  • Board Name (name) — VARCHAR(30)
  • Post List (posts) — LIST

Post

  • Post ID (post_id) — INTEGER — Primary key — NOT NULL
  • Board ID (board_id) — INTEGER — Foreign key → Board.Board ID — NOT NULL
  • User ID (user_id) — VARCHAR(10) — Foreign key → User.User ID — NOT NULL
  • Title (title) — VARCHAR(30)
  • Content (content) — VARCHAR(255)
  • Post Date (date) — Date
  • Like (like) — INTEGER
  • Not Like (n_like) — INTEGER
  • Views (views) — INTEGER

User

  • User ID (user_id) — VARCHAR(10) — Primary key — NOT NULL
  • User Password (user_pw) — VARCHAR(15)
  • Post List (posts) — LIST