project2
Tables (40)
event_images
- event_image_id — BIGINT
- event_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
event_likes
- user_id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
event_share_logs
- share_id — BIGINT
- user_id — BIGINT
- event_id — BIGINT — NOT NULL
- share_channel_code — VARCHAR(20) — NOT NULL
- shared_at — DATETIME — NOT NULL
event_statuses
- event_status_code — VARCHAR(20)
- event_status_name — VARCHAR(50) — NOT NULL
event_tags
- event_id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Primary key — NOT NULL
event_time_slots
- slot_id — BIGINT
- event_id — BIGINT — NOT NULL
- visit_date — DATE — NOT NULL
- start_time — TIME
- end_time — TIME
- capacity_total — INT — NOT NULL
- capacity_reserved — INT — NOT NULL
- is_open — TINYINT(1) — NOT NULL
event_types
- event_type_code — VARCHAR(20)
- event_type_name — VARCHAR(50) — NOT NULL
event_view_logs
- view_id — BIGINT
- user_id — BIGINT
- event_id — BIGINT — NOT NULL
- viewed_at — DATETIME — NOT NULL
events
- event_id — BIGINT
- event_type_code — VARCHAR(20) — NOT NULL
- event_status_code — VARCHAR(20) — NOT NULL
- reservation_mode_code — VARCHAR(20) — NOT NULL
- organizer_id — BIGINT
- venue_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- subtitle — VARCHAR(255)
- description — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- open_date — DATE
- is_free — TINYINT(1) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
inquiries
- inquiry_id — BIGINT
- user_id — BIGINT — NOT NULL
- event_id — BIGINT
- inquiry_status_code — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
inquiry_answers
- answer_id — BIGINT
- inquiry_id — BIGINT — NOT NULL
- admin_user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
inquiry_statuses
- inquiry_status_code — VARCHAR(20)
- inquiry_status_name — VARCHAR(50) — NOT NULL
order_items
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- ticket_type_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
- line_amount — INT — NOT NULL
order_slot_changes
- change_id — BIGINT
- order_id — BIGINT — NOT NULL
- prev_slot_id — BIGINT
- new_slot_id — BIGINT — NOT NULL
- changed_at — DATETIME — NOT NULL
order_statuses
- order_status_code — VARCHAR(20)
- order_status_name — VARCHAR(50) — NOT NULL
order_terms_agreements
- order_id — BIGINT — Primary key — NOT NULL
- terms_id — BIGINT — Primary key — NOT NULL
- agreed_at — DATETIME — NOT NULL
orders
- order_id — BIGINT
- order_no — VARCHAR(40) — NOT NULL
- user_id — BIGINT — NOT NULL
- event_id — BIGINT — NOT NULL
- slot_id — BIGINT
- order_status_code — VARCHAR(20) — NOT NULL
- delivery_method_code — VARCHAR(20)
- reserver_name — VARCHAR(100) — NOT NULL
- reserver_birth_date — DATE
- reserver_email — VARCHAR(255)
- reserver_phone — VARCHAR(30)
- total_amount — INT — NOT NULL
- reserved_at — DATETIME — NOT NULL
- cancelled_at — DATETIME
- cancel_reason — VARCHAR(255)
- updated_at — DATETIME — NOT NULL
organizers
- organizer_id — BIGINT
- organizer_name — VARCHAR(200) — NOT NULL
- contact_phone — VARCHAR(30)
- contact_email — VARCHAR(255)
- created_at — DATETIME — NOT NULL
payment_methods
- payment_method_code — VARCHAR(20)
- payment_method_name — VARCHAR(50) — NOT NULL
payment_statuses
- payment_status_code — VARCHAR(20)
- payment_status_name — VARCHAR(50) — NOT NULL
payments
- payment_id — BIGINT
- order_id — BIGINT — NOT NULL
- payment_method_code — VARCHAR(20) — NOT NULL
- payment_status_code — VARCHAR(20) — NOT NULL
- provider — VARCHAR(50)
- amount — INT — NOT NULL
- pg_transaction_id — VARCHAR(100)
- vbank_bank_name — VARCHAR(50)
- vbank_account_no — VARCHAR(100)
- vbank_due_at — DATETIME
- requested_at — DATETIME — NOT NULL
- paid_at — DATETIME
- cancelled_at — DATETIME
regions
- region_id — BIGINT
- parent_region_id — BIGINT
- region_name — VARCHAR(100) — NOT NULL
- sort_order — INT — NOT NULL
reservation_modes
- reservation_mode_code — VARCHAR(20)
- reservation_mode_name — VARCHAR(50) — NOT NULL
review_images
- review_image_id — BIGINT
- review_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
reviews
- review_id — BIGINT
- user_id — BIGINT — NOT NULL
- event_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
search_logs
- search_id — BIGINT
- user_id — BIGINT
- keyword — VARCHAR(255) — NOT NULL
- searched_at — DATETIME — NOT NULL
share_channels
- share_channel_code — VARCHAR(20)
- share_channel_name — VARCHAR(50) — NOT NULL
social_providers
- provider_code — VARCHAR(20)
- provider_name — VARCHAR(50) — NOT NULL
tag_types
- tag_type_code — VARCHAR(20)
- tag_type_name — VARCHAR(50) — NOT NULL
tags
- tag_id — BIGINT
- tag_type_code — VARCHAR(20) — NOT NULL
- tag_name — VARCHAR(100) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
terms
- terms_id — BIGINT
- terms_code — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- version — VARCHAR(30) — NOT NULL
- is_required — TINYINT(1) — NOT NULL
- effective_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
ticket_delivery_methods
- delivery_method_code — VARCHAR(20)
- delivery_method_name — VARCHAR(50) — NOT NULL
ticket_statuses
- ticket_status_code — VARCHAR(20)
- ticket_status_name — VARCHAR(50) — NOT NULL
ticket_types
- ticket_type_id — BIGINT
- event_id — BIGINT — NOT NULL
- ticket_name — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- max_qty_per_order — INT — NOT NULL
- stock_total — INT — NOT NULL
- stock_sold — INT — NOT NULL
- sale_start_at — DATETIME
- sale_end_at — DATETIME
- is_active — TINYINT(1) — NOT NULL
tickets
- ticket_id — BIGINT
- order_item_id — BIGINT — NOT NULL
- ticket_no — VARCHAR(50) — NOT NULL
- qr_token — VARCHAR(255) — NOT NULL
- qr_generated_at — DATETIME — NOT NULL
- ticket_status_code — VARCHAR(20) — NOT NULL
- used_at — DATETIME
user_interest_tags
- user_id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
user_social_accounts
- social_account_id — BIGINT
- user_id — BIGINT — NOT NULL
- provider_code — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- connected_at — DATETIME — NOT NULL
user_terms_agreements
- user_id — BIGINT — Primary key — NOT NULL
- terms_id — BIGINT — Primary key — NOT NULL
- agreed_at — DATETIME — NOT NULL
users
- user_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE
- phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- role_code — VARCHAR(20) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_login_at — DATETIME
venues
- venue_id — BIGINT
- venue_name — VARCHAR(200) — NOT NULL
- region_id — BIGINT
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)