quickticket
테이블 (14)
감상평 (REVIEW)
- Primary Key (review_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Forign Key (event_id) — INT UNSIGNED — 외래 키 → 콘서트.Primary Key — NOT NULL
- Forign Key (user_id) — INT UNSIGNED — 외래 키 → 회원.Primary Key — NOT NULL
- Field (user_rating) — TINYINT UNSIGNED
- Field (created_at) — TIMESTAMP
- Field (content) — TEXT
결제 수단 (PAYMENT_METHOD)
- Primary Key (payment_method_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Forign Key (user_id) — INT UNSIGNED — 외래 키 → 회원.Primary Key — NOT NULL
- Field (type) — ENUM
- Field (card_number) — VARCHAR(20)
- Field (cvs) — INT UNSIGNED
- Field (expiration_period) — DATE
- Field (is_active) — BOOLEAN
- Field (bank) — VARCHAR(10)
- Field (account_number) — VARCHAR(20)
예매 원하는 좌석 (WANT_SEAT)
- Key (ticket_issue_id) — 외래 키 → 예매 정보.Key — NOT NULL
- Key (seat_id) — 외래 키 → 좌석.Key — NOT NULL
- Primary Key (performance_id) — INT UNSIGNED — 외래 키 → 좌석.Primary Key — NOT NULL
예매 정보 (TICKET_ISSUE)
- Key (id) — 기본 키 — NOT NULL
- Primary Key (user_id) — INT UNSIGNED — 외래 키 → 회원.Primary Key — NOT NULL
- Primary Key (performance_id) — INT UNSIGNED — 외래 키 → 콘서트 회차.Primary Key — NOT NULL
- Forign Key (payment_method_id) — INT UNSIGNED — 외래 키 → 결제 수단.Primary Key — NOT NULL
- Field (waiting_number) — INT UNSIGNED
- Field (person_number) — INT UNSIGNED
장소 (LOCATION)
- Primary Key (location_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Field (zip_number) — VARCHAR(5)
- Field (sido) — VARCHAR(20)
- Field (sigungu) — VARCHAR(20)
- Field (eupmyun) — VARCHAR(20)
- Field (doro_code) — VARCHAR(12)
- Field (doro) — VARCHAR(80)
- Field (iocation_name) — VARCHAR(50)
- Field (phone) — VARCHAR(20)
좌석 (SEAT)
- Key (id) — 기본 키 — NOT NULL
- Primary Key (performance_id) — INT UNSIGNED — 외래 키 → 콘서트 회차.Primary Key — NOT NULL
- Primary Key (event_id) — INT UNSIGNED — 외래 키 → 좌석 등급.Primary Key — NOT NULL
- Primary Key (event_id2) — INT UNSIGNED — 외래 키 → 좌석 구역.Primary Key — NOT NULL
- Forign Key (class_id) — 외래 키 → 좌석 등급.Key — NOT NULL
- Forign Key (area_id) — 외래 키 → 좌석 구역.Key — NOT NULL
- Field (current_waiting_number)
좌석 구역 (SEAT_AREA)
- Key (id) — 기본 키 — NOT NULL
- Primary Key (event_id) — INT UNSIGNED — 외래 키 → 콘서트.Primary Key — NOT NULL
- Field (name)
좌석 등급 (SEAT_CLASS)
- Key (id) — 기본 키 — NOT NULL
- Primary Key (event_id) — INT UNSIGNED — 외래 키 → 콘서트.Primary Key — NOT NULL
- Field (name)
- Field (price)
좌석 하나 결제 정보 (SEAT_PAYMENT_ISSUE)
- Key2 (payment_id) — 기본 키 — NOT NULL
- Forign Key (ticket_issue_id) — 외래 키 → 예매 정보.Key — NOT NULL
- Primary Key (user_id) — INT UNSIGNED — 외래 키 → 회원.Primary Key — NOT NULL
- Forign Key (seat_id) — 외래 키 → 좌석.Key — NOT NULL
- Primary Key (performance_id) — INT UNSIGNED — 외래 키 → 좌석.Primary Key — NOT NULL
- Field (state) — ENUM
카테고리 (CATEGORY)
- Primary Key (category_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Field (name) — VARCHAR(20)
콘서트 (EVENT)
- Primary Key (event_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Forign Key (location_id) — INT UNSIGNED — 외래 키 → 장소.Primary Key — NOT NULL
- Forign Key (category1_id) — INT UNSIGNED — 외래 키 → 카테고리.Primary Key — NOT NULL
- Forign Key (category2_id) — INT UNSIGNED — 외래 키 → 카테고리.Primary Key
- Field (name) — VARCHAR(100)
- Field (description) — TEXT
- Field (age_rating) — ENUM
- Field (user_rating_sum) — LONG UNSIGNED
- Field (thumbnail_image) — BLOB
- Field (agent_name) — VARCHAR(30)
- Field (host_name) — VARCHAR(30)
- Field (contact_data) — VARCHAR(30)
콘서트 회차 (PERFORMANCE)
- Primary Key (performance_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Forign Key (event_id) — INT UNSIGNED — 외래 키 → 콘서트.Primary Key — NOT NULL
- Field (performance_nth) — TINYINT UNSIGNED
- Field (target_seat_number) — INT UNSIGNED
- Field (performers_name) — JSON
- Field (tlcketing_starts_at) — TIMESTAMP
- Field (ticketing_ends_at) — TIMESTAMP
- Field (performance_starts_at) — TIMESTAMP
- Field (running_time_minute) — INT UNSIGNED
- Field (ticket_waiting_length)
크레딧 원장 (credit_transaction)
- Primary Key (credit_transaction_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Primary Key (user_id) — INT UNSIGNED — 외래 키 → 회원.Primary Key — NOT NULL
- Key2 (payment_id) — 외래 키 → 좌석 하나 결제 정보.Key2 — NOT NULL
- Field (transaction_type) — ENUM
- Field (change_amount) — INT
- Field (balance_after) — INT UNSIGNED
- Field (changed_at) — TIMESTAMP
회원 (USER)
- Primary Key (user_id) — INT UNSIGNED — 기본 키 — NOT NULL
- Field (username) — VARCHAR(50)
- Field (password) — VARCHAR(50)
- Field (name) — VARCHAR(50)
- Field (birthday) — DATE
- Field (email) — VARCHAR(50)
- Field (phone) — VARCHAR(20)
- Field (credit) — INT UNSIGNED
- Field (role) — ENUM
- Field (created_at) — TIMESTAMP