마리오

테이블 (21)

analysis_report

  • report_id — INT
  • report_name — VARCHAR(100) — NOT NULL
  • report_type — ENUM('DAILY', 'WEEKLY', 'MONTHLY', 'ADHOC') — NOT NULL
  • generation_date — DATETIME
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • created_by — VARCHAR(20) — NOT NULL
  • report_format — ENUM('PDF', 'EXCEL', 'HTML')
  • storage_path — VARCHAR(255) — NOT NULL
  • parameters — JSON
  • INDEX — idx_report_period
  • INDEX — idx_report_type

content

  • content_id — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category_id — INT — NOT NULL
  • copyright_info — TEXT
  • rating — VARCHAR(10)
  • file_path — VARCHAR(255)
  • thumbnail_path — VARCHAR(255)
  • uploader_id — VARCHAR(20) — NOT NULL
  • upload_date — DATETIME
  • approval_status — ENUM('PENDING', 'APPROVED', 'REJECTED')
  • view_count — INT
  • FULLTEXT — INDEX

content_category

  • category_id — INT
  • category_name — VARCHAR(50) — NOT NULL
  • parent_id — INT
  • depth — TINYINT — NOT NULL
  • display_order — INT — NOT NULL
  • INDEX — idx_category_hierarchy

content_metadata

  • metadata_id — INT
  • content_id — INT — NOT NULL
  • meta_key — VARCHAR(50) — NOT NULL
  • meta_value — TEXT
  • INDEX — idx_content_meta

entry_log

  • log_id — BIGINT
  • ticket_id — VARCHAR(20) — NOT NULL
  • entry_time — DATETIME — NOT NULL
  • exit_time — DATETIME
  • gate_id — VARCHAR(10) — NOT NULL
  • device_id — VARCHAR(20)
  • INDEX — idx_entry_time
  • INDEX — idx_exit_time

event

  • event_id — INT
  • event_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • event_type — ENUM('PROMOTION', 'SEASONAL', 'SPECIAL') — NOT NULL
  • participation_condition — TEXT
  • reward_details — TEXT
  • status — ENUM('UPCOMING', 'ONGOING', 'ENDED')
  • INDEX — idx_event_dates
  • INDEX — idx_event_status

game_money

  • transaction_id — BIGINT
  • user_id — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(12,2) — NOT NULL
  • transaction_type — ENUM('PURCHASE', 'USE', 'REFUND', 'BONUS') — NOT NULL
  • transaction_date — DATETIME
  • balance_after — DECIMAL(12,2) — NOT NULL
  • reference_id — VARCHAR(50)
  • INDEX — idx_game_money_user
  • INDEX — idx_game_money_date

inventory_transaction

  • transaction_id — BIGINT
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • transaction_type — ENUM('PURCHASE', 'SALE', 'ADJUSTMENT', 'RETURN') — NOT NULL
  • reference_id — VARCHAR(50)
  • transaction_date — DATETIME
  • notes — TEXT
  • INDEX — idx_inventory_product
  • INDEX — idx_inventory_date

membership

  • membership_id — INT
  • user_id — VARCHAR(20) — NOT NULL
  • tier — ENUM('BASIC', 'SILVER', 'GOLD', 'PLATINUM')
  • join_date — DATE — NOT NULL
  • expiry_date — DATE
  • point_balance — INT
  • total_spent — DECIMAL(12,2)
  • INDEX — idx_membership_tier

order_detail

  • order_id — VARCHAR(20)
  • payment_id — VARCHAR(20) — NOT NULL
  • total_amount — DECIMAL(12,2) — NOT NULL
  • order_date — DATETIME
  • order_status — ENUM('PENDING', 'COMPLETED', 'CANCELLED')

order_item

  • item_id — BIGINT
  • order_id — VARCHAR(20) — NOT NULL
  • product_type — ENUM('TICKET', 'MERCHANDISE', 'GAME_MONEY') — NOT NULL
  • product_id — VARCHAR(20) — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — DECIMAL(10,2) — NOT NULL
  • INDEX — idx_order_product

payment

  • payment_id — VARCHAR(20)
  • user_id — VARCHAR(20)
  • amount — DECIMAL(12,2) — NOT NULL
  • payment_method — ENUM('CARD', 'CASH', 'MOBILE', 'BANK_TRANSFER') — NOT NULL
  • payment_date — DATETIME
  • status — ENUM('COMPLETED', 'FAILED', 'REFUNDED') — NOT NULL
  • transaction_id — VARCHAR(50)
  • card_info_encrypted — VARCHAR(255)
  • INDEX — idx_payment_date
  • INDEX — idx_payment_user

permission

  • permission_id — INT
  • resource_name — VARCHAR(50) — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • description — VARCHAR(200)

product

  • product_id — INT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — ENUM('FOOD', 'BEVERAGE', 'MERCHANDISE', 'GAME_ITEM') — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • cost — DECIMAL(10,2)
  • stock_quantity — INT — NOT NULL
  • reorder_level — INT
  • supplier_id — INT
  • is_active — TINYINT(1)
  • INDEX — idx_product_category
  • INDEX — idx_product_active

role_permission

  • role_id — INT — 기본 키 — NOT NULL
  • permission_id — INT — 기본 키 — NOT NULL

ticket

  • ticket_id — VARCHAR(20)
  • type_id — INT — NOT NULL
  • owner_id — VARCHAR(20)
  • issue_date — DATETIME
  • expiry_date — DATETIME — NOT NULL
  • status — ENUM('VALID', 'USED', 'EXPIRED')
  • payment_id — VARCHAR(20)
  • INDEX — idx_ticket_status
  • INDEX — idx_ticket_expiry

ticket_type

  • type_id — INT
  • type_name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)
  • price — DECIMAL(10,2) — NOT NULL
  • validity_days — INT — NOT NULL
  • is_group — TINYINT(1)
  • max_usage — INT
  • discount_policy — TEXT

user_account

  • user_id — VARCHAR(20)
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • user_type — ENUM('VISITOR', 'STAFF', 'ADMIN') — NOT NULL
  • created_at — DATETIME
  • last_login — DATETIME
  • status — TINYINT
  • INDEX — idx_user_type
  • INDEX — idx_email

user_profile

  • user_id — VARCHAR(20)
  • birth_date — DATE
  • gender — CHAR(1)
  • address — VARCHAR(200)
  • preferred_language — VARCHAR(10)

user_role

  • user_id — VARCHAR(20) — 기본 키 — NOT NULL
  • role_id — INT — 기본 키 — NOT NULL
  • assigned_at — DATETIME
  • assigned_by — VARCHAR(20)

visit_history

  • visit_id — BIGINT
  • user_id — VARCHAR(20) — NOT NULL
  • visit_date — DATE — NOT NULL
  • entry_time — DATETIME
  • exit_time — DATETIME
  • duration_minutes — INT
  • satisfaction_score — TINYINT
  • devices_used — TEXT
  • INDEX — idx_visit_date
  • INDEX — idx_user_visits