project1

Tables (5)

board (Untitled2)

  • num (Key) — int — Primary key — NOT NULL
  • id (key) — varchar(10) — Foreign key → member.id — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — varchar(10000)
  • readcount (Field3) — int
  • reg (Field4) — date

eq_reservation (Untitled4)

  • num (Key) — int — Primary key — NOT NULL
  • id (key) — varchar(10) — Foreign key → member.id — NOT NULL
  • eq1 (Field) — varchar(10)
  • eq2 (Field2) — varchar(10)
  • title (Field3) — varchar(100)
  • res_date (Field4) — varchar(30)
  • start_time (Field5) — varchar(20)
  • end_time (Field6) — varchar(20)
  • color (Field7) — varchar(50)

member (Untitled)

  • id (key) — varchar(10) — Primary key — NOT NULL
  • pw (Field2) — varchar(20)
  • name (Field) — varchar(20)

photo (Untitled5)

  • num (Key) — int — Primary key — NOT NULL
  • photo_name (Field) — varchar(20)
  • url (Field2) — varchar(50)
  • place (Field3) — varchar(100)

reservation (Untitled3)

  • num (Key) — int — Primary key — NOT NULL
  • id (key) — varchar(10) — Foreign key → member.id — NOT NULL
  • r1 (Field) — varchar(10)
  • r2 (Field2) — varchar(10)
  • title (Field3) — varchar(100)
  • res_date (Field4) — varchar(30)
  • start_time (Field5) — varchar(20)
  • end_time (Field6) — varchar(20)
  • color (Field7) — varchar(50)