test
Tables (3)
CONCERT
- concert_id — VARCHAR(36) — Primary key — NOT NULL
- title — VARCHAR(255)
- date — DATETIME
- location — VARCHAR(255)
TICKET
- ticket_id — VARCHAR(36) — Primary key — NOT NULL
- seat_number — VARCHAR(20)
- price — DECIMAL(10,2)
- purchase_date — DATETIME
- user_id (user_id2) — VARCHAR(36) — Foreign key → USER.user_id — NOT NULL
- concert_id (concert_id2) — VARCHAR(36) — Foreign key → CONCERT.concert_id — NOT NULL
USER
- user_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(20)