jsp_project4

Tables (3)

board (Untitled2)

  • bno (Key) — int — Primary key — NOT NULL — auto_increment
  • title (Field) — varchar(100)
  • writer (Field2) — varchar(100)
  • content (Field3) — text
  • reg_date (Field4) — datetime
  • read_count (Field5) — int
  • image_file (Field6)

comment (Untitled3)

  • cno (Key) — int — Primary key — NOT NULL
  • bno (Key2) — int — Foreign key → board.bno — NOT NULL — auto_increment
  • writer (Field2) — varchar(100)
  • content (Field3) — varchar(1000) — NOT NULL
  • reg_date (Field4)

member (Untitled)

  • mno (Key) — int — Primary key — NOT NULL — auto_increment
  • id (Field) — varchar(100) — NOT NULL
  • password (Field2) — varchar(100) — NOT NULL
  • email (Field3) — varchar(100) — NOT NULL
  • age (Field4) — int
  • reg_date (Field5) — datetime
  • last_login (Field6) — datetime