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