KB mini
Tables (12)
BADGE
- badge_id — INT
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- image_url — VARCHAR(255)
CHARACTER
- character_id — INT
- user_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- level — INT
- exp_points — INT
- created_at — TIMESTAMP
MISSION
- mission_id — INT
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- reward_points — INT — NOT NULL
- start_date — TIMESTAMP — NOT NULL
- end_date — TIMESTAMP — NOT NULL
NEWS_SUMMARY
- summary_id — INT
- original_news — TEXT — NOT NULL
- kid_friendly_summary — TEXT — NOT NULL
- created_at — TIMESTAMP
- category — VARCHAR(50)
QUIZ
- quiz_id — INT
- question — TEXT — NOT NULL
- correct_answer — TEXT — NOT NULL
- difficulty_level — INT — NOT NULL
- category — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
QUIZ_ATTEMPT
- attempt_id — INT
- user_id — INT — NOT NULL
- quiz_id — INT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- attempt_date — TIMESTAMP
- points_earned — INT
STOCK_TRANSACTION
- transaction_id — INT
- account_id — INT — NOT NULL
- stock_code — VARCHAR(20) — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(15,2) — NOT NULL
- transaction_date — TIMESTAMP
- transaction_type — ENUM('BUY', 'SELL') — NOT NULL
USER
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- birth_date — DATE — NOT NULL
- is_senior — BOOLEAN
- biometric_data — TEXT
- large_text_mode — BOOLEAN
- created_at — TIMESTAMP
USER_BADGE
- user_badge_id — INT
- user_id — INT — NOT NULL
- badge_id — INT — NOT NULL
- earned_date — TIMESTAMP
USER_MISSION
- user_mission_id — INT
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- is_completed — BOOLEAN
- completion_date — TIMESTAMP
VIRTUAL_ACCOUNT
- account_id — INT
- user_id — INT — NOT NULL
- account_number — VARCHAR(20) — NOT NULL
- balance — DECIMAL(15,2)
- created_at — TIMESTAMP
VOICE_COMMAND
- command_id — INT
- user_id — INT — NOT NULL
- command_text — TEXT — NOT NULL
- recorded_at — TIMESTAMP
- status — VARCHAR(20)