예매

테이블 (24)

BOOKING

  • booking_id — INT
  • user_id — INT — NOT NULL
  • event_id — INT — NOT NULL
  • booking_time — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • discounted_price — DECIMAL(10, 2)

CHAT

  • chat_id — INT
  • product_id — INT — NOT NULL
  • sender_id — INT — NOT NULL
  • receiver_id — INT — NOT NULL
  • message — TEXT — NOT NULL
  • sent_at — DATETIME
  • is_read — BOOLEAN

Copy Of PAYMENT_METHOD (CopyOfPAYMENT_METHOD)

  • payment_method_id — INT
  • method_name — VARCHAR(50) — NOT NULL
  • method_type — VARCHAR(20) — NOT NULL

Coupon

  • coupon_id — INT
  • user_id — INT
  • code — VARCHAR(50) — NOT NULL
  • discount — DECIMAL(5, 2)
  • expiration_date — DATE
  • status — VARCHAR(20)

EVENT

  • event_id — INT
  • event_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • event_type — VARCHAR(50)
  • venue_id — INT — NOT NULL

LOCATION

  • location_id — INT
  • city — VARCHAR(50) — NOT NULL
  • district — VARCHAR(50) — NOT NULL
  • neighborhood — VARCHAR(50) — NOT NULL

Movie

  • movie_id — INT
  • title — VARCHAR(255) — NOT NULL
  • genre — VARCHAR(100)
  • release_date — DATE
  • duration — INT

PAYMENT

  • payment_id — INT
  • booking_id — INT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • payment_time — DATETIME
  • payment_method_id — INT — NOT NULL

PAYMENT_METHOD

  • payment_method_id — INT
  • method_name — VARCHAR(50) — NOT NULL
  • method_type — VARCHAR(20) — NOT NULL

PERFORMANCE

  • performance_id — INT
  • event_id — INT — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • available_seats — INT — NOT NULL

PRODUCT

  • product_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • location_id — INT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

PRODUCT_CATEGORY

  • category_id — INT
  • product_id — INT — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

PRODUCT_IMAGE

  • image_id — INT
  • product_id — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

Payment

  • payment_id — INT
  • ticket_id — INT
  • payment_method — VARCHAR(50)
  • payment_time — DATETIME
  • status — VARCHAR(50)

REVIEW

  • review_id — INT
  • transaction_id — INT — NOT NULL
  • reviewer_id — INT — NOT NULL
  • reviewee_id — INT — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — EX
  • created_at — DATETIME

SEAT

  • seat_id — INT
  • venue_id — INT — NOT NULL
  • seat_number — VARCHAR(10) — NOT NULL
  • section — VARCHAR(50)
  • seat_type — VARCHAR(20)

Screening

  • screening_id — INT
  • movie_id — INT
  • theater_id — INT
  • start_time — DATETIME
  • end_time — DATETIME
  • available_seats — INT

TICKET

  • ticket_id — INT
  • booking_id — INT — NOT NULL
  • performance_id — INT — NOT NULL
  • seat_id — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • ticket_type — VARCHAR(20)
  • status — VARCHAR(20)

TRANSACTION

  • transaction_id — INT
  • product_id — INT — NOT NULL
  • seller_id — INT — NOT NULL
  • buyer_id — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME
  • completed_at — DATETIME

Theater

  • theater_id — INT
  • name — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255) — NOT NULL

Ticket

  • ticket_id — INT
  • user_id — INT
  • screening_id — INT
  • seat_number — VARCHAR(10)
  • booking_time — DATETIME
  • price — DECIMAL(10, 2)

USER

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

User

  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50) — NOT NULL

VENUE

  • venue_id — INT
  • venue_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • capacity — INT — NOT NULL
  • venue_type — VARCHAR(50)