concert_1
Tables (8)
concert
- concert_id — UUID
- title — VARCHAR(200) — NOT NULL
- date — VARCHAR(50) — NOT NULL
- location — VARCHAR(200)
- duration — VARCHAR(100)
- seat_type — VARCHAR(100)
- rating — VARCHAR(50)
- detail_url — VARCHAR(300)
- ticket_start_time — TIMESTAMP
- ticket_end_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
concert_image
- image_id — UUID
- concert_id — UUID — Foreign key → concert.concert_id
- image_url — VARCHAR(300) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
concert_price
- price_id — UUID
- concert_id — UUID — Foreign key → concert.concert_id
- price — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payment
- payment_id — UUID
- reservation_id — UUID — Foreign key → reservation.reservation_id
- user_id — UUID — Foreign key → user.user_id
- amount — DECIMAL(15,2)
- payment_status — VARCHAR(50)
- payment_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
queue
- queue_id — UUID
- user_id — UUID — Foreign key → user.user_id
- concert_id — UUID — Foreign key → concert.concert_id
- queue_position — INT
- queue_token — VARCHAR(100)
- issued_time — TIMESTAMP
- status — VARCHAR(50)
- is_active — BOOLEAN
- activation_time — TIMESTAMP
- expiration_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
reservation
- reservation_id — UUID
- user_id — UUID — Foreign key → user.user_id
- concert_id — UUID — Foreign key → concert.concert_id
- seat_id — UUID — Foreign key → seat.seat_id
- reservation_status — VARCHAR(50)
- reservation_type — VARCHAR(50)
- reservation_time — TIMESTAMP
- expiry_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
seat
- seat_id — UUID
- concert_id — UUID — Foreign key → concert.concert_id
- seat_number — INT
- is_reserved — BOOLEAN
- reserved_by — UUID — Foreign key → user.user_id
- reserved_at — TIMESTAMP
- temp_reserved_by — UUID — Foreign key → user.user_id
- temp_reserved_until — TIMESTAMP
- lock_expiration — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user
- user_id — UUID
- username — VARCHAR(100)
- balance — DECIMAL(15,2) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP