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