zipt_db

Tables (9)

analysis_results

  • id — INT — Primary key — NOT NULL
  • building_year — INT
  • hug_debt_ratio — INT
  • insurance_eligible — INT
  • is_rental_business — INT
  • ltv_ratio — INT
  • priority_ratio — INT
  • risk_score — INT
  • total_ltv — INT
  • created_at — DATETIME
  • deposit — INT
  • market_price — INT
  • member_id — INT — Foreign key → member.id
  • official_price — INT
  • total_priority_amount — INT
  • property_type — VARCHAR(50)
  • risk_level — VARCHAR(50)
  • score_grade — VARCHAR(50)
  • owner_name — VARCHAR(100)
  • rental_type — VARCHAR(50)
  • address — VARCHAR(255)
  • pdf_url — VARCHAR(500)
  • registry_image_url — VARCHAR(500)
  • priority_bonds — JSON
  • processing_status — VARCHAR(50)
  • registry_file_name — VARCHAR(255)

auth

  • id — INT — Primary key — NOT NULL
  • created_at — DATETIME
  • expired_at — DATETIME
  • member_id — INT — Foreign key → member.id
  • updated_at — DATETIME
  • refresh_token — VARCHAR(500)

contract_checklist_items

  • id — INT — Primary key — NOT NULL
  • checked — INT
  • display_order — INT
  • required — INT
  • contract_id — INT — Foreign key → contracts.id
  • category — VARCHAR(100)
  • action_required — VARCHAR(255)
  • description — VARCHAR(500)
  • reason — VARCHAR(500)
  • reference_text — TEXT
  • title — VARCHAR(255)
  • risk_level — VARCHAR(50)

contract_documents

  • id — INT — Primary key — NOT NULL
  • contract_id — INT — Foreign key → contracts.id
  • extracted_text — TEXT
  • file_url — VARCHAR(500)
  • original_file_name — VARCHAR(255)

contract_special_terms

  • id — INT — Primary key — NOT NULL
  • display_order — INT
  • needs_review — INT
  • tenant_protective — INT
  • contract_id — INT — Foreign key → contracts.id
  • content — TEXT
  • term_type — VARCHAR(50)

contracts

  • id — INT — Primary key — NOT NULL
  • balance_payment_date — DATETIME
  • delivery_date — DATETIME
  • end_date — DATETIME
  • extraction_confidence — INT
  • intermediate_payment_date — DATETIME
  • monthly_rent_payment_day — INT
  • repair_completion_date — DATETIME
  • balance_amount — INT
  • contract_amount — INT
  • created_at — DATETIME
  • deposit_amount — INT
  • intermediate_amount — INT
  • maintenance_fee_amount — INT
  • member_id — INT — Foreign key → member.id
  • monthly_rent — INT
  • updated_at — DATETIME
  • building_purpose — VARCHAR(255)
  • building_structure — VARCHAR(255)
  • extraction_warnings — VARCHAR(255)
  • leased_part — VARCHAR(255)
  • maintenance_fee_calculation_method — VARCHAR(255)
  • missing_fields — VARCHAR(255)
  • priority_fixed_date_description — VARCHAR(255)
  • property_address — VARCHAR(255)
  • repair_content — VARCHAR(255)
  • repair_default_handling — VARCHAR(255)
  • unpaid_tax_description — VARCHAR(255)
  • contract_kind — VARCHAR(50)
  • contract_type — VARCHAR(50)
  • maintenance_fee_type — VARCHAR(50)
  • priority_fixed_date_status — VARCHAR(50)
  • repair_needed_status — VARCHAR(50)
  • unpaid_tax_status — VARCHAR(50)
  • processing_error_message — VARCHAR(500)
  • processing_status — VARCHAR(50)

member

  • id — INT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • email — VARCHAR(255)
  • is_deleted — VARCHAR(10)
  • name — VARCHAR(100)
  • password — VARCHAR(255)
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(100)
  • role — VARCHAR(50)

real_estate_terms

  • id — INT — Primary key — NOT NULL
  • action_tip — VARCHAR(500)
  • category — VARCHAR(100)
  • is_core — INT
  • created_at — DATETIME
  • easy_definition — VARCHAR(500)
  • fetched_at — DATETIME
  • license — VARCHAR(255)
  • name — VARCHAR(255)
  • official_definition — TEXT
  • risk_level — VARCHAR(50)
  • source_name — VARCHAR(255)
  • source_url — VARCHAR(500)
  • term_id — VARCHAR(100)
  • updated_at — DATETIME

term_aliases

  • real_estate_term_id — INT — Foreign key → real_estate_terms.id — NOT NULL
  • alias — VARCHAR(255)