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