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)