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