Private project 1
Tables (3)
board (Untitled2)
- board_id (primay key) — int — Primary key — NOT NULL — auto_imcrement
- member_id (foreign key) — int — Foreign key → member.member_id — NOT NULL
- board_title (Field) — varchar(200) — NOT NULL
- board_content (Field2) — text — NOT NULL
- board_hit (Field3) — int — NOT NULL
- board_date (Field4) — datetime — NOT NULL
comment (Untitled3)
- comment_id (primary key) — int — Primary key — NOT NULL — auto_increment
- board_id (primay key) — int — Foreign key → board.board_id — NOT NULL — auto_imcrement
- member_id (foreign key2) — int — Foreign key → board.member_id — NOT NULL
- comment_content (Field) — varchar(500) — NOT NULL
- comment_date (Field2) — datetime — NOT NULL
member (Untitled)
- member_id (primary key) — int — Primary key — NOT NULL — auto_increment
- member_loginid (unique) — varchar(50) — NOT NULL
- member_name (Field3) — varchar(100) — NOT NULL
- member_email (Field4) — varchar(200) — NOT NULL
- member_pwd (Field5) — varchar(300) — NOT NULL
- member_phone (Field6) — varchar(20)