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