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