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