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