ㅊㄱㄷ

Tables (6)

concerts

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • running_time — INT — NOT NULL
  • price — INT — NOT NULL
  • limit_age — INT — NOT NULL
  • performance_date — DATETIME — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

payments

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • total_amount — INT — NOT NULL
  • method — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

reservations

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • concert_id — BIGINT — NOT NULL
  • status — VARCHAR(20)
  • amount — INT — NOT NULL
  • reserved_at — DATETIME
  • cancelled_at — DATETIME
  • id (id2) — BIGINT — Foreign key → concerts.id — NOT NULL

reservations_seats

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • seat_id — BIGINT — NOT NULL
  • reservation_number — VARCHAR(50) — NOT NULL

seats

  • id — BIGINT
  • seat_number — INT — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • birth — DATE — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • balance — BIGINT — NOT NULL
  • user_role — VARCHAR(20) — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME