Board

Tables (3)

board_data (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → user.id — NOT NULL
  • username (Field) — varchar(100)
  • title (Field2) — varchar(100)
  • content (Field3) — longtext
  • img_url (Field4) — varchar(255)
  • yyyymmdd (Field5) — date

comment (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • board_id (Key2) — int — Foreign key → board_data.id — NOT NULL
  • username (Field) — varchar(100)
  • content (Field2) — longtext
  • yyyymmdd (Field3) — date

user (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • firstname (Field6) — varchar(100)
  • lastname (Field7) — varchar(100)
  • username (Field) — varchar(100)
  • password (Field3) — varchar(100)
  • email (Field4) — varchar(100)
  • birthday (Field2) — date
  • sex (Field5) — varchar(10)
  • phoneNumber (Field8) — varchar(30)