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)