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)