concert
Tables (3)
CONCERT
- concert_id — INT — Primary key
- title — VARCHAR(255) — NOT NULL
- date — VARCHAR(225) — NOT NULL
- location — VARCHAR(255) — NOT NULL
TICKET
- ticket_id — INT — Primary key
- seat_number — VARCHAR(50) — NOT NULL
- price — FLOAT — NOT NULL
- purchase_date — VARCHAR(225) — NOT NULL
- user_id — INT — Foreign key → USER.user_id
- concert_id — INT — Foreign key → CONCERT.concert_id
USER
- user_id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL