예매
테이블 (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)