마리오
테이블 (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