realticket

Tables (7)

Event

  • id (아이디) — BIGINT — Primary key
  • running_date (상영시간) — TIMESTAMP
  • reservation_open_date (예매 오픈 시간) — TIMESTAMP
  • reservation_close_date (예매 마감 시간) — TIMESTAMP
  • program_id (프로그램 id) — BIGINT — Foreign key → Program.id
  • place_id (장소 id) — BIGINT — Foreign key → Place.id

Place

  • id — BIGINT — Primary key
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • overview_svg (오버뷰 SVG url) — VARCHAR(255)
  • overview_height (오버뷰 높이) — INT
  • overview_width (오버뷰 너비) — INT
  • sections (섹션 id 리스트) — JSON
  • overview_points (오버뷰 포인트들) — TEXT

Program

  • id — BIGINT — Primary key
  • name (이름) — VARCHAR(255)
  • profile_url (프로필사진URL) — VARCHAR(255)
  • running_time (관람시간) — INT
  • genre (장르) — VARCHAR(255)
  • actors (출연진) — VARCHAR(255)
  • price (가격) — INT
  • place_id (장소 id) — BIGINT — Foreign key → Place.id

Reservation

  • id — BIGINT — Primary key
  • created_at (예약 시간) — TIMESTAMP
  • deleted_at (예약 취소 시간) — TIMESTAMP
  • amount (티켓 매수) — INT
  • program_id (프로그램 id) — BIGINT — Foreign key → Program.id
  • event_id (이벤트 id) — BIGINT — Foreign key → Event.id
  • user_id (유저 id) — BIGINT — Foreign key → User.id

Reservation_seat (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • section (구역) — VARCHAR(255)
  • row (행 번호) — INT
  • col (열 번호) — INT
  • reservation_id (예약 id) — BIGINT — Foreign key → Reservation.id

Section (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • name (구역 이름) — VARCHAR(255)
  • col-len (열 길이) — INT
  • seats (좌석들) — JSON
  • place_id (장소 id) — BIGINT — Foreign key → Place.id

User

  • id — BIGINT — Primary key
  • login_id — VARCHAR(255)
  • login_password — VARCHAR(255)