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