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)