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)