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)