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)