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