programmers-first-project
Tables (4)
order (Untitled3)
- id (Key) — INT UNSIGNED — Primary key — NOT NULL
- user_id (Key2) — INT UNSIGNED — Foreign key → user.id — NOT NULL
- show_id (Key3) — INT UNSIGNED — Foreign key → show.id — NOT NULL
- date (Field2) — DATETIME — NOT NULL
- quantity (Field) — TINYINT UNSIGNED — NOT NULL
show (공연)
- id (Key) — INT UNSIGNED — Primary key — NOT NULL
- title (Field) — VARCHAR(1000) — NOT NULL
- date (Field2) — DATETIME — NOT NULL
- price (Field3) — INT UNSIGNED — NOT NULL
- description (Field4) — VARCHAR(10000)
show_image (Untitled)
- id (Key2) — INT UNSIGNED — Primary key — NOT NULL
- show_id (Key) — INT UNSIGNED — Foreign key → show.id — NOT NULL
- url (Field) — VARCHAR(1000) — NOT NULL
user (Untitled2)
- id (Key) — INT UNSIGNED — Primary key — NOT NULL
- name (Field) — VARCHAR(1000) — NOT NULL
- email (Field2) — VARCHAR(1000) — NOT NULL
- password (Field3) — VARCHAR(1000) — NOT NULL
- phone_number (Field4) — VARCHAR(1000) — NOT NULL