EbrainStudy
Tables (3)
Board (board)
- Board Id (board_id) — INT(11) — Primary key — NOT NULL
- Category (category) — VARCHAR(20)
- Writer (writer) — VARCHAR(20)
- Pw (pw) — VARCHAR(30)
- Title (title) — VARCHAR(50)
- Content (content) — VARCHAR(500)
- File1 (file1) — VARCHAR(50)
- File2 (file2) — VARCHAR(50)
- File3 (file3) — VARCHAR(50)
- View Cnt (view_cnt) — INT(11)
- Del Yn (del_yn) — TINY INT
- Del Dt (del_dt) — DATETIME
- Mod Dt (mod_dt) — DATETIME
- Reg Dt (reg_dt) — DATETIME
- Category Id (category_id) — TINYINT(4) — Foreign key → Category.Category Id — NOT NULL
Category (category)
- Category Id (category_id) — TINYINT(4) — Primary key — NOT NULL
- Category Name (category_nm) — VARCHAR(20)
- Reg Dt (reg_dt) — DATETIME
Comment (comment)
- Comment Id (comment_id) — INT(11) — Primary key — NOT NULL
- Content (content) — VARCHAR(300)
- Reg Dt (reg_dt) — DATETIME
- Board Id (board_id) — INT(11) — Foreign key → Board.Board Id — NOT NULL