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