Hertz
Tables (9)
concert
- concert_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
concert_payment
- concert_payment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- concert_seat_reservation_id — BIGINT — Foreign key → concert_seat_reservation.concert_seat_reservation_id — NOT NULL
- amount — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
concert_schedule
- concert_schedule_id — BIGINT — Primary key — NOT NULL
- concert_id — BIGINT — Foreign key → concert.concert_id — NOT NULL
- date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
concert_seat
- concert_seat_id — BIGINT — Primary key — NOT NULL
- concert_schedule_id — BIGINT — Foreign key → concert_schedule.concert_schedule_id — NOT NULL
- seat_name — VARCHAR(10) — NOT NULL
- price — INT — NOT NULL
- status — VARCHAR(10) — NOT NULL — AVAILABLE, RESERVED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
concert_seat_reservation
- concert_seat_reservation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- concert_seat_id — BIGINT — Foreign key → concert_seat.concert_seat_id — NOT NULL
- status — VARCHAR(10) — NOT NULL — PENDING, CONFIRMED, CANCELLED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_point_history
- user_point_history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- amount — INT — NOT NULL
- transaction_type — VARCHAR(10) — NOT NULL — CHARGE, USE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_point_payment_history
- user_point_payment_history_id — BIGINT — Primary key — NOT NULL
- user_point_history_id — BIGINT — Foreign key → user_point_history.user_point_history_id — NOT NULL
- payment_method — VARCHAR(255) — NOT NULL
- payment_status — VARCHAR(10) — NOT NULL — PENDING, COMPLETED, CANCELLED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- point — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
waiting_queue
- waiting_number — BIGINT — Primary key — NOT NULL
- status — VARCHAR(10) — NOT NULL — WAITING, WORKING, DONE
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL