Board Example

Tables (3)

board info (board)

  • number (boardnum) — integer — Primary key — NOT NULL
  • user id (id) — varchar(30) — Foreign key → member info.user id — NOT NULL
  • title — varchar(1000) — NOT NULL
  • contents — mediumtext — NOT NULL
  • viewcount — integer — NOT NULL
  • inputdate — timestamp — NOT NULL

member info (member)

  • user id (id) — varchar(30) — Primary key — NOT NULL
  • user password (password) — varchar(100) — NOT NULL
  • user name (name) — varchar(30) — NOT NULL
  • user email address (email) — varchar(50)
  • type of each user (usertype) — varchar(10) — NOT NULL
  • state of user (isactive) — tinyint — NOT NULL — 1 : active 0: inactive

reply info (reply)

  • number (replynum) — integer — Primary key — NOT NULL
  • number (boardnum) — integer — Foreign key → board info.number — NOT NULL — auto_increment
  • user id (id) — varchar(30) — Foreign key → member info.user id — NOT NULL
  • contents (replytext) — varchar(2000) — NOT NULL
  • inputdate — timestamp — NOT NULL