SOL_STORY_20240817

Tables (9)

Users (users)

  • user_no — NUMBER(10) — NOT NULL
  • user_id — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(64) — NOT NULL
  • user_name — VARCHAR2(100) — NOT NULL
  • email — VARCHAR2(254) — NOT NULL
  • phone_number — VARCHAR2(20) — NOT NULL
  • join_date — DATE — NOT NULL

challenges

  • challenge_no — NUMBER(10) — NOT NULL
  • challenge_name — VARCHAR2(255) — NOT NULL
  • challenge_description — VARCHAR2(255) — NOT NULL
  • reward_points — NUMBER — NOT NULL
  • challenge_type — NUMBER — NOT NULL

keys

  • user_no — NUMBER(10) — NOT NULL
  • total_keys — NUMBER — NOT NULL
  • remaining_points — NUMBER — NOT NULL

savings_accounts

  • account_serial_no — NUMBER(10) — NOT NULL
  • user_no — NUMBER(10) — NOT NULL
  • account_no — VARCHAR2(34) — NOT NULL
  • account_name — VARCHAR2(100) — NOT NULL
  • balance — NUMBER(15) — NOT NULL
  • created_at — DATE — NOT NULL
  • last_deposit_date — DATE — NOT NULL
  • status — NUMBER(5) — NOT NULL

savings_goals

  • goal_no — NUMBER(10) — NOT NULL
  • account_serial_no — NUMBER(10) — NOT NULL
  • custom_goal — VARCHAR2(100)
  • target_amount — NUMBER(15) — NOT NULL
  • current_amount — NUMBER(15) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

story_categories

  • category_no — NUMBER(10) — NOT NULL
  • category_name — VARCHAR2(50) — NOT NULL
  • keys_required — NUMBER — NOT NULL

story_keywords

  • keyword_no — NUMBER(10) — NOT NULL
  • category_no — NUMBER(10) — NOT NULL
  • keyword — VARCHAR2(100) — NOT NULL

transactions

  • transaction_no — NUMBER(10) — NOT NULL
  • account_serial_no — NUMBER(10) — NOT NULL
  • transaction_date — DATE — NOT NULL
  • amount — NUMBER(15, 2) — NOT NULL
  • category_no — NUMBER(10) — NOT NULL
  • description — VARCHAR2(255)

user_stories

  • user_story_no — NUMBER(10) — NOT NULL
  • user_no — NUMBER(10) — NOT NULL
  • keyword_no — NUMBER(10) — NOT NULL
  • unlock_date — DATE — NOT NULL