tickeSync

Tables (5)

performances (공연)

  • id — Long — Primary key — NOT NULL
  • title — String
  • venue — String
  • performance_start_data (performance_start_date) — TIMESTAMP
  • performance_end_data — TIMESTAMP
  • performance_time — TIMESTAMP
  • created_at — TIMESTAMP

reservation_seats (Untitled)

  • reservation_id — LONG — Foreign key → reservations.id — NOT NULL
  • seat_id — LONG — Foreign key → seats.id — NOT NULL
  • status — enum
  • reservation_date — TIMESTAMP

reservations (예약)

  • id — Long — Primary key — NOT NULL
  • id (user_id) — LONG — Foreign key → users.id — NOT NULL
  • id (performance_id) — LONG — Foreign key → performances.id — NOT NULL
  • status — enum
  • total_amount — int
  • created_at — TIMESTAMP

seats (좌석)

  • id — Long — Primary key — NOT NULL
  • id (performance_id) — LONG — Foreign key → performances.id — NOT NULL
  • section — enum
  • row_no — int
  • seat_no — int
  • price — int
  • created_at — TIMESTAMP

users (사용자)

  • id — Long — Primary key — NOT NULL
  • email — String
  • password — String
  • name — String
  • created_at — TIMESTAMP