notice board
Tables (5)
board
- bo_num — int auto_increment — Primary key — NOT NULL
- bo_title — varchar(30) — NOT NULL
- bo_ca_title — varchar(30) — Foreign key → category.ca_title — NOT NULL
category
- ca_title — varchar(30) — Primary key — NOT NULL
comment
- co_num — int auto_increment — Primary key — NOT NULL
- co_content — varchar(100) — NOT NULL
- co_po_num — int — Foreign key → post.po_num — NOT NULL
- co_me_id — varchar(20) — Foreign key → member.me_id — NOT NULL
member
- me_id — varchar(20) — Primary key — NOT NULL
- me_pw — varchar(20) — NOT NULL
- me_name — varchar(20) — NOT NULL
- me_email — varchar(50) — NOT NULL
- me_admin — varchar(5) — NOT NULL
post
- po_num — int auto_increment — Primary key — NOT NULL
- po_content — varchar(200) — NOT NULL
- po_title — varchar(30) — NOT NULL
- po_view — int — NOT NULL
- po_me_id — varchar(20) — Foreign key → member.me_id — NOT NULL
- po_bo_num — int — Foreign key → board.bo_num — NOT NULL
- po_me_name — varchar(20) — NOT NULL