AssetManagement

Tables (7)

account (accounts)

  • account_number — NOTNULL — Primary key — NOT NULL
  • user_id — NOTNULL — Foreign key → app_user.user_id — NOT NULL
  • account_pw — NOTNULL
  • Field (current_balance) — NOTNULL
  • Field (created_at) — NOTNULL

app_user (user)

  • user_id — NOTNULL — Primary key — NOT NULL
  • user_pw — NOTNULL
  • sex — NOTNUL
  • age — NOTNULL
  • email — NOTNULL
  • phone — NOTNULL
  • home_address — NOTNULL
  • pfinancial_asset
  • pestate_investment

expert

  • expert_id — NOTNULL — Primary key — NOT NULL
  • name — NOTNULL
  • match_maximum — NOTNULL
  • p_count — NOTNULL
  • specialty — NOTNULL
  • risk_profile (rist_profile) — NOTNULL
  • experience_years — NOTNULL
  • averageRscore — NOTNULL

investment_goal

  • goal_id — NOTNULL — Primary key — NOT NULL
  • user_id — NOTNULL — Foreign key → app_user.user_id — NOT NULL
  • goal_type — NOTNULL
  • target_amount — NOTNULL
  • target_date — NOTNULL
  • create_at (created_goal) — NOTNULL

matching (Untitled)

  • matching_id — NOTNULL — Primary key — NOT NULL
  • user_id — NOTNULL — Foreign key → app_user.user_id — NOT NULL
  • expert_id — NOTNULL — Foreign key → expert.expert_id — NOT NULL
  • goal_type — NOTNULL
  • matched_at — NOTNULL

matchingRequest

  • mRequest_id — NOTNULL — Primary key — NOT NULL
  • user_id — NOTNULL — Foreign key → app_user.user_id — NOT NULL
  • goal_type — NOTNULL
  • request_at — NOTNULL

user_investmentProfile

  • profile_id — NOTNULL — Primary key — NOT NULL
  • user_id — NOTNULL — Foreign key → app_user.user_id — NOT NULL
  • investment_experience — NOTNULL
  • risk_tolerance — NOTNULL
  • risk_profile — NOTNULL
  • created_at (created_pro) — NOTNULL