JSP_pjt

Tables (9)

CONCERT (Untitled5)

  • ID (Key) — Primary key — NOT NULL

DINER (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • Field2
  • Field3

GYM (CopyOfUntitled4)

  • ID (Key) — Primary key — NOT NULL

HALL (Untitled4)

  • ID (Key) — Primary key — NOT NULL

REVIEW (CONCERT) (CopyOfUntitled22)

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • CONCERT_ID (Key3) — Foreign key → CONCERT.ID — NOT NULL
  • TEXT (Field)

REVIEW (DINER) (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • DINER_ID (Key3) — Foreign key → DINER.ID — NOT NULL
  • TEXT (Field)

REVIEW (GYM) (CopyOfUntitled23)

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • GYM_ID (Key3) — Foreign key → GYM.ID — NOT NULL
  • TEXT (Field)

REVIEW (HALL) (CopyOfUntitled2)

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • HALL_ID (Key3) — Foreign key → HALL.ID — NOT NULL
  • TEXT (Field)

USER (Untitled)

  • ID (Key) — INT — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR
  • PASSWORD (Field2)
  • NICKNAME (Field3)