222

Tables (8)

admin_users

  • admin_id — NUMBER
  • username — VARCHAR2(50)
  • password — VARCHAR2(100)
  • role — VARCHAR2(30)

asset_logs

  • log_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • category — VARCHAR2(30)
  • amount — NUMBER — NOT NULL
  • description — VARCHAR2(200)
  • log_date — DATE

fintech_company

  • company_id — NUMBER
  • name — VARCHAR2(100) — NOT NULL
  • field — VARCHAR2(50)
  • description — VARCHAR2(500)
  • founded_date — DATE
  • homepage — VARCHAR2(200)

loan_product

  • loan_id — NUMBER
  • bank_name — VARCHAR2(100)
  • product_name — VARCHAR2(100)
  • interest_rate — NUMBER(5,2)
  • max_amount — NUMBER
  • term_months — NUMBER
  • condition_desc — VARCHAR2(300)

real_estate

  • estate_id — NUMBER
  • location — VARCHAR2(100)
  • type — VARCHAR2(30)
  • price — NUMBER
  • area_m2 — NUMBER
  • deal_date — DATE

user_interest

  • interest_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • company_id — NUMBER — NOT NULL
  • added_at — DATE

user_loan_search

  • search_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • desired_amount — NUMBER
  • desired_term — NUMBER
  • search_date — DATE

users

  • user_id — NUMBER
  • username — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(100) — NOT NULL
  • email — VARCHAR2(100)
  • created_at — DATE