99
Tables (6)
concert
- id (Key) — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- name — VARCHAR(200) — NOT NULL
- seat_count — INT — NOT NULL
- ticket_price — DECIMAL(15,2) — NOT NULL
concert_schedule
- id (Key) — BIGINT — Primary key — NOT NULL
- concert_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- reservation_start — DATETIME — NOT NULL
- reservation_end — DATETIME — NOT NULL
- concert_id (Key2) — BIGINT — Foreign key → concert.id — NOT NULL
payment
- id (Key) — BIGINT — Primary key — NOT NULL
- payment_no — CHAR(36) — NOT NULL
- uuid — CHAR(36) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed_at — DATETIME
- requested_at — DATETIME — NOT NULL
- reservation_id (Key2) — BIGINT — Foreign key → reservation.id — NOT NULL
reservation
- id (Key) — BIGINT — Primary key — NOT NULL
- uuid — CHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- completed_at — DATETIME
- concert_schedule_id (Key2) — BIGINT — Foreign key → concert_schedule.id — NOT NULL
- seat_id (Key3) — BIGINT — Foreign key → seat.id — NOT NULL
seat
- id (Key) — BIGINT — Primary key — NOT NULL
- seat_no — INT — NOT NULL
- price — DECIMAL(15,2) — NOT NULL
- concert_schedule_id (Key2) — BIGINT — Foreign key → concert_schedule.id — NOT NULL
users
- id (Key) — BIGINT — Primary key — NOT NULL
- uuid — CHAR(36) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- balance — DECIMAL(15,2)