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