kiwi-ticketing

테이블 (7)

Untitled (seat_details)

  • Key (seat_detail_id) — bigint — 기본 키 — NOT NULL
  • Field (tier) — varchar(255)
  • Field2 (max_puchase) — int
  • Field3 (price) — int

공연 일정 (event_schedules)

  • Key (event_schedule_id) — bigint — 기본 키 — NOT NULL
  • Field (event_time) — timestamp — NOT NULL
  • Field (unlock_at) — timestamp — NOT NULL
  • Key (show_id) — bigint — 외래 키 → 공연 정보.Key — NOT NULL
  • Key (event_spaces_id) — bigint — 외래 키 → 공연 장소.Key — NOT NULL

공연 장소 (event_spaces)

  • Key (event_space_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (capacity) — int
  • Field3 (address) — varchar(255) — NOT NULL
  • Field4 (latitude) — decimal(10, 8)
  • Field5 (longitude) — decimal(11, 8)
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp — NOT NULL

공연 정보 (shows)

  • Key (show_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (description) — text — NOT NULL
  • Field3 (category) — varchar(255) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp — NOT NULL

좌석 정보 (seats)

  • Key (seat_id) — bigint — 기본 키 — NOT NULL
  • Field (floor_num) — varchar(255) — NOT NULL
  • Field2 (sector) — varchar(255) — NOT NULL
  • Field3 (row_num) — varchar(255) — NOT NULL
  • Field4 (col_num) — varchar(255) — NOT NULL
  • Field3 (is_selected) — tinyint(1) — NOT NULL
  • Field4 (is_paid) — tinyint(1) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp — NOT NULL
  • Key (order_id) — bigint — 외래 키 → 주문 정보.Key — NOT NULL
  • Key (event_schedule_id) — bigint — 외래 키 → 공연 일정.Key — NOT NULL
  • Key (seat_detail_id) — bigint — 외래 키 → Untitled.Key — NOT NULL

주문 정보 (orders)

  • Key (order_id) — bigint — 기본 키 — NOT NULL
  • Field3 (status) — varchar(255) — NOT NULL
  • Field2 (created_at) — timestamp — NOT NULL
  • Field4 (updated_at) — timestamp — NOT NULL
  • Key (user_id) — bigint — 외래 키 → 회원.Key — NOT NULL
  • Key (event_schedule_id) — bigint — 외래 키 → 공연 일정.Key — NOT NULL

회원 (users)

  • Key (user_id) — bigint — 기본 키 — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field2 (password) — varchar(255) — NOT NULL
  • Field3 (phone_number) — varchar(255) — NOT NULL
  • Field4 (created_at) — timestamp — NOT NULL
  • Field5 (updated_at) — timestamp — NOT NULL