Real_Estate
Tables (30)
BUILDING_LEDGER
- ledger_id — NUMBER(18) — Primary key — NOT NULL
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- ledger_address — VARCHAR2(200)
- owner_name — VARCHAR2(50)
- building_purpose — VARCHAR2(50)
- building_structure — VARCHAR2(50)
- building_area — NUMBER(7,2)
- violation_yn — CHAR(1)
- updated_at — TIMESTAMP
BUILDING_REGISTRY
- registry_id — NUMBER(18) — Primary key — NOT NULL
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- building_purpose — VARCHAR2(50)
- building_structure — VARCHAR2(50)
- updated_at — TIMESTAMP
CONSULTATION
- consult_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- plan_id — NUMBER(18) — Foreign key → LOAN_PLAN.plan_id
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- consult_type — VARCHAR2(10)
- consultant_name — VARCHAR2(50)
- consult_status — VARCHAR2(10)
- summary — CLOB
- scheduled_at — TIMESTAMP
- created_at — TIMESTAMP
CONSULT_MESSAGE
- message_id — NUMBER(18) — Primary key — NOT NULL
- consult_id — NUMBER(18) — Foreign key → CONSULTATION.consult_id
- sender — VARCHAR2(10)
- message — CLOB
- sent_at — TIMESTAMP
CONSULT_NOTIFICATION
- consult_notif_id — NUMBER(18) — Primary key — NOT NULL
- notif_id — NUMBER(18) — Foreign key → NOTIFICATION.notif_id
- consult_id — NUMBER(18) — Foreign key → CONSULTATION.consult_id
- scheduled_at — TIMESTAMP
- remind_time — TIMESTAMP
GUARANTEE_CRITERIA
- guarantee_id — NUMBER(18) — Primary key — NOT NULL
- provider — VARCHAR2(10)
- max_deposit — NUMBER(18)
- collateral_ratio — NUMBER(5,2)
- guarantee_ratio — NUMBER(5,2)
- lease_ratio_limit — NUMBER(5,2)
- strict_singlehouse_yn — CHAR(1)
- require_confirmed_date_yn — CHAR(1)
- violation_disqualify_yn — CHAR(1)
- right_violation_disqualify_yn — CHAR(1)
- updated_at — TIMESTAMP
GUARANTEE_PREMIUM_RATE
- premium_rate_id — NUMBER(18) — Primary key — NOT NULL
- guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- house_type — VARCHAR2(20)
- debt_ratio_min — NUMBER(5,2)
- debt_ratio_max — NUMBER(5,2)
- premium_rate — NUMBER(5,3)
- updated_at — TIMESTAMP
HF_CRITERIA
- hf_criteria_id — NUMBER(18) — Primary key — NOT NULL
- guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- loan_linked_required_yn — CHAR(1)
- lowest_premium_yn — CHAR(1)
- youth_discount_yn — CHAR(1)
- newlywed_discount_yn — CHAR(1)
- updated_at — TIMESTAMP
HUG_CRITERIA
- hug_criteria_id — NUMBER(18) — Primary key — NOT NULL
- guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- metro_deposit_limit — NUMBER(18)
- ltv_premium_tiered_yn — CHAR(1)
- newlywed_discount_yn — CHAR(1)
- multichild_discount_yn — CHAR(1)
- social_discount_yn — CHAR(1)
- updated_at — TIMESTAMP
INSURANCE_PRODUCT
- insurance_id — NUMBER(18) — Primary key — NOT NULL
- guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- product_name — VARCHAR2(100)
- updated_at — TIMESTAMP
INTEREST_RATE_HISTORY
- rate_id — NUMBER(18) — Primary key — NOT NULL
- rate_type — VARCHAR2(20)
- rate_value — NUMBER(5,3)
- change_date — DATE
- source — VARCHAR2(50)
LOAN_PLAN
- plan_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- risk_id — NUMBER(18) — Foreign key → RISK_ANALYSIS.risk_id
- loan_id — NUMBER(18) — Foreign key → LOAN_PRODUCT.loan_id
- regulation_id — NUMBER(18) — Foreign key → LOAN_REGULATION.regulation_id
- recommended_amount — NUMBER(18)
- monthly_payment — NUMBER(18)
- ltv_result — NUMBER(5,2)
- dsr_result — NUMBER(5,2)
- stress_dsr_result — NUMBER(5,2)
- created_at — TIMESTAMP
LOAN_PRODUCT
- loan_id — NUMBER(18) — Primary key — NOT NULL
- bank_name — VARCHAR2(50)
- product_name — VARCHAR2(100)
- loan_type — VARCHAR2(30)
- interest_rate — NUMBER(5,3)
- rate_type — VARCHAR2(10)
- max_limit — NUMBER(18)
- loan_term — NUMBER(10)
- repayment_type — VARCHAR2(20)
- income_condition — NUMBER(18)
- house_ownership_condition — CHAR(1)
- updated_at — TIMESTAMP
LOAN_REGULATION
- regulation_id — NUMBER(18) — Primary key — NOT NULL
- house_type — VARCHAR2(30)
- region_type — VARCHAR2(30)
- ltv_limit — NUMBER(5,2)
- dsr_limit — NUMBER(5,2)
- stress_dsr_rate — NUMBER(5,2)
- stress_dsr_limit — NUMBER(5,2)
- dti_limit — NUMBER(5,2)
- effective_date — DATE
MORTGAGE_HISTORY
- mortgage_id — NUMBER(18) — Primary key — NOT NULL
- registry_id — NUMBER(18) — Foreign key → BUILDING_REGISTRY.registry_id
- priority_no — NUMBER(10)
- right_type — VARCHAR2(20)
- receipt_date — DATE
- registration_cause — VARCHAR2(50)
- mortgage_amount — NUMBER(18)
- mortgage_creditor — VARCHAR2(100)
- debtor_name — VARCHAR2(50)
- max_bond_amount — NUMBER(18)
- prior_tenant_deposit — NUMBER(18)
- lease_right_yn — CHAR(1)
- tenancy_right_yn — CHAR(1)
- senior_debt_yn — CHAR(1)
- is_active — CHAR(1)
- recorded_at — TIMESTAMP
NOTIFICATION
- notif_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- notif_type — VARCHAR2(20)
- is_read — CHAR(1)
- created_at — TIMESTAMP
NOTIFICATION_SUBSCRIPTION
- subscription_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- subscription_type — VARCHAR2(20)
- target_district — VARCHAR2(30)
- contract_type — VARCHAR2(10)
- deposit_min — NUMBER(18)
- deposit_max — NUMBER(18)
- is_active — CHAR(1)
- created_at — TIMESTAMP
OWNERSHIP_HISTORY
- ownership_id — NUMBER(18) — Primary key — NOT NULL
- registry_id — NUMBER(18) — Foreign key → BUILDING_REGISTRY.registry_id
- owner_name — VARCHAR2(50)
- ownership_date — DATE
- provisional_seizure_yn — CHAR(1)
- seizure_yn — CHAR(1)
- auction_yn — CHAR(1)
- provisional_registration_yn — CHAR(1)
- trust_registration_yn — CHAR(1)
- lease_registration_yn — CHAR(1)
- is_current — CHAR(1)
- recorded_at — TIMESTAMP
PROPERTY
- property_id — NUMBER(18) — Primary key — NOT NULL
- address — VARCHAR2(200)
- district — VARCHAR2(30)
- landlord_name — VARCHAR2(50)
- contract_type_code_id — NUMBER(18) — Foreign key → PROPERTY_CODE.code_id
- property_type_code_id — NUMBER(18) — Foreign key → PROPERTY_CODE.code_id
- status_code_id — NUMBER(18) — Foreign key → PROPERTY_CODE.code_id
- deposit — NUMBER(18)
- monthly_rent — NUMBER(18)
- market_price — NUMBER(18)
- price_type — VARCHAR2(20)
- price_date — DATE
- area_sqm — NUMBER(7,2)
- floor — NUMBER(10)
- built_year — NUMBER(10)
- latitude — NUMBER(10,7)
- longitude — NUMBER(10,7)
- registered_at — TIMESTAMP
PROPERTY_CODE
- code_id — NUMBER(18) — Primary key — NOT NULL
- code_group — VARCHAR2(30)
- code_value — VARCHAR2(30)
- code_name — VARCHAR2(50)
- code_description — VARCHAR2(200)
- sort_order — NUMBER(10)
- is_active — CHAR(1)
PROPERTY_NOTIFICATION
- prop_notif_id — NUMBER(18) — Primary key — NOT NULL
- notif_id — NUMBER(18) — Foreign key → NOTIFICATION.notif_id
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- subscription_id — NUMBER(18) — Foreign key → NOTIFICATION_SUBSCRIPTION.subscription_id
RATE_NOTIFICATION
- rate_notif_id — NUMBER(18) — Primary key — NOT NULL
- notif_id — NUMBER(18) — Foreign key → NOTIFICATION.notif_id
- rate_id — NUMBER(18) — Foreign key → INTEREST_RATE_HISTORY.rate_id
- subscription_id — NUMBER(18) — Foreign key → NOTIFICATION_SUBSCRIPTION.subscription_id
- previous_rate — NUMBER(5,3)
- current_rate — NUMBER(5,3)
REGION_STATS
- stat_id — NUMBER(18) — Primary key — NOT NULL
- district — VARCHAR2(30)
- contract_type — VARCHAR2(10)
- avg_deposit — NUMBER(18)
- avg_monthly_rent — NUMBER(18)
- avg_lease_ratio — NUMBER(5,2)
- transaction_count — NUMBER(10)
- price_change_rate — NUMBER(6,2)
- risk_index — NUMBER(5,2)
- stat_date — DATE
RISK_ANALYSIS
- risk_id — NUMBER(18) — Primary key — NOT NULL
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- registry_id — NUMBER(18) — Foreign key → BUILDING_REGISTRY.registry_id
- ledger_id — NUMBER(18) — Foreign key → BUILDING_LEDGER.ledger_id
- eligible_guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- lease_ratio — NUMBER(5,2)
- hug_eligible_yn — CHAR(1)
- hf_eligible_yn — CHAR(1)
- sgi_eligible_yn — CHAR(1)
- insurance_eligible_yn — CHAR(1)
- risk_grade — VARCHAR2(10)
- previous_grade — VARCHAR2(10)
- risk_reason — CLOB
- is_latest — CHAR(1)
- analyzed_at — TIMESTAMP
SEARCH_HISTORY
- search_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- search_keyword — VARCHAR2(100)
- search_district — VARCHAR2(30)
- contract_type — VARCHAR2(10)
- searched_at — TIMESTAMP
SGI_CRITERIA
- sgi_criteria_id — NUMBER(18) — Primary key — NOT NULL
- guarantee_id — NUMBER(18) — Foreign key → GUARANTEE_CRITERIA.guarantee_id
- apartment_unlimited_yn — CHAR(1)
- other_house_limit — NUMBER(18)
- private_insurer_yn — CHAR(1)
- high_value_available_yn — CHAR(1)
- broker_contract_required_yn — CHAR(1)
- updated_at — TIMESTAMP
USERS
- user_id — NUMBER(18) — Primary key — NOT NULL
- name — VARCHAR2(50)
- email — VARCHAR2(100)
- phone — VARCHAR2(20)
- annual_income — NUMBER(18)
- credit_score — NUMBER(10)
- existing_loan — NUMBER(18)
- existing_loan_annual_payment — NUMBER(18)
- has_house — CHAR(1)
- created_at — TIMESTAMP
USER_AUTH
- auth_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- auth_type — VARCHAR2(10)
- provider_id — VARCHAR2(100)
- password_hash — VARCHAR2(255)
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP
WISHLIST
- wish_id — NUMBER(18) — Primary key — NOT NULL
- user_id — NUMBER(18) — Foreign key → USERS.user_id
- property_id — NUMBER(18) — Foreign key → PROPERTY.property_id
- monitoring_yn — CHAR(1)
- alert_condition — VARCHAR2(50)
- created_at — TIMESTAMP
WISHLIST_NOTIFICATION
- wish_notif_id — NUMBER(18) — Primary key — NOT NULL
- notif_id — NUMBER(18) — Foreign key → NOTIFICATION.notif_id
- wish_id — NUMBER(18) — Foreign key → WISHLIST.wish_id
- change_type — VARCHAR2(20)
- before_value — VARCHAR2(100)
- after_value — VARCHAR2(100)
- detected_at — TIMESTAMP