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