Term Project

Tables (4)

Board (Untitled)

  • b_num (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • w_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL
  • c_num (Key3) — NOT NULL — Foreign key → Category.c_num — NOT NULL
  • title (Field) — NOT NULL
  • b_content (Field2) — NOT NULL
  • b_date (Field3) — NOT NULL
  • hit (Field4) — NOT NULL
  • like (Field5) — NOT NULL

Category (Untitled2)

  • c_num (Key) — NOT NULL — Primary key — NOT NULL
  • c_name (Field) — NOT NULL

Reply (Untitled3)

  • Key — AUTO_INCREMENT — Primary key — NOT NULL
  • b_num (Key2) — NOT NULL — Foreign key → Board.b_num — NOT NULL
  • name (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • r_date (Field3) — NOT NULL

User

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • password (Field4) — NOT NULL
  • E-mail (Field2) — NULL
  • name (Field3) — NOT NULL
  • phone (Field5) — NULL