toyBoard

Tables (8)

User (us_user)

  • us_id — varchar(15) primary key — Primary key — NOT NULL
  • us_pw — varchar(15) — NOT NULL
  • us_nickname — varchar(10) — NOT NULL
  • us_auth — int

bo_category (ct_category)

  • bc_num (ct_num) — int primary key auto_increment — Primary key — NOT NULL
  • bc_name (ct_name) — varchar(8) — NOT NULL

board (bo_board)

  • bo_num — int primary key auto_increment — Primary key — NOT NULL
  • bo_title — varchar(20) — NOT NULL
  • bo_content — longtext — NOT NULL
  • bo_date — datetime — NOT NULL
  • bo_us_id — varchar(15) — Foreign key → User.us_id — NOT NULL
  • bo_ct_num — int — Foreign key → bo_category.bc_num — NOT NULL
  • bo_state — int

boardvote (bv_boardvote)

  • bv_num — int primary key auto_increment — Primary key — NOT NULL
  • bv_state — boolean — NOT NULL
  • bv_bo_num — int — Foreign key → board.bo_num — NOT NULL
  • bv_us_id — varchar(15) — Foreign key → User.us_id — NOT NULL

bt_boardtags

  • bt_num — int primary key auto_increment — Primary key — NOT NULL
  • bt_bo_num — int — Foreign key → board.bo_num — NOT NULL
  • bt_bl_tagnum (bt_tg_tagnum) — varchar(10) — Foreign key → tg_tag.bl_tagnum — NOT NULL

comment (bc_boardcomment)

  • bc_num (cm_num) — int primary key auto_increment — Primary key — NOT NULL
  • bc_date — datetime — NOT NULL
  • bc_content (cm_content) — varchar(300) — NOT NULL
  • bc_bo_num (cm_bo_num) — int — Foreign key → board.bo_num — NOT NULL
  • bc_us_id (cm_us_id) — varchar(15) — Foreign key → User.us_id — NOT NULL
  • bc_state (cm_state) — int — NOT NULL

files (bf_boardfiles)

  • Key (bf_num) — int primary key auto_increment — Primary key — NOT NULL
  • Field (bf_fileurl) — varchar(255) — NOT NULL
  • bo_num (bf_bo_num) — int — Foreign key → board.bo_num — NOT NULL

tg_tag

  • bl_tagnum (tg_tagnum) — int primary key auto_increment — Primary key — NOT NULL
  • bl_tagname (tg_tagname) — varchar(10) — NOT NULL