Zip-da-project-property final-version

Tables (29)

apartment_complex

  • apartment_complex_id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → region.region_id — NOT NULL
  • complex_name — VARCHAR(200) — NOT NULL
  • road_address — VARCHAR(300)
  • jibun_address — VARCHAR(300)
  • center_location — POINT — NOT NULL
  • total_buildings — INT
  • total_households — INT
  • total_parking_spaces — INT
  • approval_date — DATE
  • is_active — BOOLEAN — NOT NULL
  • source_name — VARCHAR(100) — NOT NULL
  • source_updated_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

apartment_complex_external_ref

  • complex_external_ref_id — BIGINT — Primary key — NOT NULL
  • apartment_complex_id — BIGINT — Foreign key → apartment_complex.apartment_complex_id — NOT NULL
  • provider_code — VARCHAR(50) — NOT NULL
  • external_complex_id — VARCHAR(100) — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • source_payload_hash — CHAR(64)
  • source_updated_at — DATETIME(6)
  • last_seen_at — DATETIME(6) — NOT NULL
  • active_provider_external_key — VARCHAR(200)
  • active_complex_provider_key — VARCHAR(150)
  • active_primary_key — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

apartment_complex_facility

  • complex_facility_id — BIGINT — Primary key — NOT NULL
  • apartment_complex_id — BIGINT — Foreign key → apartment_complex.apartment_complex_id — NOT NULL
  • facility_code — VARCHAR(50) — NOT NULL
  • facility_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000)
  • is_verified — BOOLEAN — NOT NULL
  • source_name — VARCHAR(100)
  • source_updated_at — DATETIME(6)
  • active_complex_facility_key — VARCHAR(150)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property

  • property_id — BIGINT — Primary key — NOT NULL
  • version — BIGINT — NOT NULL
  • region_id — BIGINT — Foreign key → region.region_id — NOT NULL
  • apartment_complex_id — BIGINT — Foreign key → apartment_complex.apartment_complex_id
  • author_member_id — BIGINT — NOT NULL
  • publisher_type — VARCHAR(30) — NOT NULL
  • property_type — VARCHAR(30) — NOT NULL
  • transaction_type — VARCHAR(30) — NOT NULL
  • sale_price — BIGINT
  • deposit — BIGINT
  • monthly_rent — BIGINT
  • maintenance_fee — BIGINT
  • supply_area — DECIMAL(10, 2)
  • exclusive_area — DECIMAL(10, 2) — NOT NULL
  • room_count — INT
  • bathroom_count — INT
  • floor — INT
  • total_floor — INT
  • floor_condition — VARCHAR(30)
  • direction — VARCHAR(20)
  • approval_date — DATE
  • building_use — VARCHAR(100)
  • is_parking_available — BOOLEAN
  • has_elevator — BOOLEAN
  • is_pet_allowed — BOOLEAN
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • publication_status — VARCHAR(30) — NOT NULL
  • transaction_status — VARCHAR(30) — NOT NULL
  • verification_status — VARCHAR(30) — NOT NULL
  • risk_score — DECIMAL(5, 2)
  • published_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_address

  • property_address_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • legal_dong_code — CHAR(10) — NOT NULL
  • exact_road_address — VARCHAR(300)
  • exact_jibun_address — VARCHAR(300)
  • detail_address_encrypted — VARBINARY(1000)
  • detail_address_key_version — VARCHAR(50)
  • exact_location — POINT — NOT NULL
  • public_address — VARCHAR(300) — NOT NULL
  • public_location — POINT — NOT NULL
  • disclosure_level — VARCHAR(30) — NOT NULL
  • location_verified_at — DATETIME(6) — NOT NULL
  • location_source — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_audit_event

  • audit_event_id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — VARCHAR(100) — NOT NULL
  • action_code — VARCHAR(100) — NOT NULL
  • actor_member_id — BIGINT
  • actor_role — VARCHAR(30)
  • action_source — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(1000)
  • trace_id — VARCHAR(100) — NOT NULL
  • client_ip_hash — CHAR(64)
  • occurred_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)

property_favorite

  • favorite_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • active_favorite_key — VARCHAR(150)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_file

  • property_file_id — BIGINT — Primary key — NOT NULL
  • upload_session_id — VARCHAR(36) — NOT NULL
  • owner_member_id — BIGINT — NOT NULL
  • file_purpose — VARCHAR(30) — NOT NULL
  • upload_status — VARCHAR(30) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • mime_type — VARCHAR(100)
  • object_key — VARCHAR(500) — NOT NULL
  • checksum — VARCHAR(64)
  • expires_at — DATETIME(6) — NOT NULL
  • linked_at — DATETIME(6)
  • object_deleted_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_idempotency

  • idempotency_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • endpoint_key — VARCHAR(200) — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • active_idempotency_key — VARCHAR(100)
  • request_hash — CHAR(64) — NOT NULL
  • processing_status — VARCHAR(20) — NOT NULL
  • resource_type — VARCHAR(50)
  • resource_id — BIGINT
  • response_status — SMALLINT
  • response_body_json — JSON
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_image

  • property_image_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • property_file_id — BIGINT — Foreign key → property_file.property_file_id — NOT NULL
  • sort_order — INT — NOT NULL
  • is_representative — BOOLEAN — NOT NULL
  • alt_text — VARCHAR(300)
  • active_representative_key — BIGINT
  • active_property_file_key — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_member_event_consumption

  • event_id — VARCHAR(100) — Primary key — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • processed_at — DATETIME(6) — NOT NULL

property_member_state

  • member_id — BIGINT — Primary key — NOT NULL
  • withdrawn_at — DATETIME(6)
  • sanction_scope — VARCHAR(100)
  • sanctioned_at — DATETIME(6)
  • agent_id — BIGINT
  • agency_id — BIGINT
  • agent_active — BOOLEAN — NOT NULL
  • last_event_id — VARCHAR(100) — NOT NULL
  • last_event_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

property_option

  • property_option_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • option_code_id — BIGINT — Foreign key → property_option_code.option_code_id — NOT NULL
  • option_value — VARCHAR(5) — NOT NULL
  • display_order — INT — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_option_code

  • option_code_id — BIGINT — Primary key — NOT NULL
  • option_code — VARCHAR(50) — NOT NULL
  • option_name — VARCHAR(100) — NOT NULL
  • option_category — VARCHAR(30) — NOT NULL
  • description — VARCHAR(500)
  • is_filterable — BOOLEAN — NOT NULL
  • is_detail_visible — BOOLEAN — NOT NULL
  • is_registration_enabled — BOOLEAN — NOT NULL
  • display_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_option_history

  • property_option_history_id — BIGINT — Primary key — NOT NULL
  • property_revision_id — BIGINT — Foreign key → property_revision.property_revision_id — NOT NULL
  • property_option_id — BIGINT — Foreign key → property_option.property_option_id — NOT NULL
  • option_code_id — BIGINT — Foreign key → property_option_code.option_code_id — NOT NULL
  • change_type — VARCHAR(30) — NOT NULL
  • changed_fields — VARCHAR(500) — NOT NULL
  • before_value — VARCHAR(5)
  • after_value — VARCHAR(5)
  • before_display_order — INT
  • after_display_order — INT
  • before_verified — BOOLEAN
  • after_verified — BOOLEAN
  • before_deleted_at — DATETIME(6)
  • after_deleted_at — DATETIME(6)
  • occurred_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_publisher_snapshot

  • publisher_snapshot_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • property_revision_id — BIGINT — Foreign key → property_revision.property_revision_id — NOT NULL
  • publisher_type — VARCHAR(30) — NOT NULL
  • publisher_member_id — BIGINT — NOT NULL
  • agent_id — BIGINT
  • agency_id — BIGINT
  • office_name — VARCHAR(200)
  • office_address — VARCHAR(300)
  • office_contact — VARCHAR(50)
  • registration_number — VARCHAR(100)
  • broker_name — VARCHAR(100)
  • snapshot_json — JSON
  • captured_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_report

  • report_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • reporter_member_id — BIGINT — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • detail — VARCHAR(1000) — NOT NULL
  • risk_score — DECIMAL(5, 2)
  • assigned_admin_id — BIGINT
  • version — BIGINT — NOT NULL
  • active_report_key — VARCHAR(150)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_report_action

  • action_id — BIGINT — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → property_report.report_id — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • action_code — VARCHAR(50) — NOT NULL
  • reason — VARCHAR(1000) — NOT NULL
  • actor_member_id — BIGINT — NOT NULL
  • actor_role — VARCHAR(30) — NOT NULL
  • trace_id — VARCHAR(100) — NOT NULL
  • executed_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_report_appeal

  • appeal_id — BIGINT — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → property_report.report_id — NOT NULL
  • appellant_member_id — BIGINT — NOT NULL
  • detail — VARCHAR(2000) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • reviewer_member_id — BIGINT
  • review_reason — VARCHAR(1000)
  • reviewed_at — DATETIME(6)
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_report_evidence

  • report_evidence_id — BIGINT — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → property_report.report_id — NOT NULL
  • property_file_id — BIGINT — Foreign key → property_file.property_file_id — NOT NULL
  • evidence_type — VARCHAR(30) — NOT NULL
  • sort_order — INT — NOT NULL
  • active_report_file_key — VARCHAR(50)
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_revision

  • property_revision_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • property_version — BIGINT — NOT NULL
  • change_type — VARCHAR(30) — NOT NULL
  • change_scope — VARCHAR(30) — NOT NULL
  • changed_fields_json — JSON — NOT NULL
  • before_snapshot_json — JSON
  • after_snapshot_json — JSON — NOT NULL
  • snapshot_schema_version — INT — NOT NULL
  • actor_member_id — BIGINT
  • actor_role — VARCHAR(30)
  • change_reason — VARCHAR(1000)
  • trace_id — VARCHAR(100) — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_risk_assessment

  • risk_assessment_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • publisher_member_id — BIGINT — NOT NULL
  • normalized_address_hash — CHAR(64) — NOT NULL
  • matched_rule_codes_json — JSON — NOT NULL
  • risk_score — DECIMAL(5, 2) — NOT NULL
  • decision — VARCHAR(30) — NOT NULL
  • duplicate_property_id — BIGINT — Foreign key → property.property_id
  • evaluated_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_status_history

  • property_status_history_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • property_revision_id — BIGINT — Foreign key → property_revision.property_revision_id — NOT NULL
  • status_type — VARCHAR(30) — NOT NULL
  • before_status — VARCHAR(30)
  • after_status — VARCHAR(30) — NOT NULL
  • actor_member_id — BIGINT
  • actor_role — VARCHAR(30)
  • reason_code — VARCHAR(50)
  • reason — VARCHAR(1000)
  • property_version — BIGINT — NOT NULL
  • trace_id — VARCHAR(100) — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_type_option

  • property_type_option_id — BIGINT — Primary key — NOT NULL
  • property_type — VARCHAR(30) — NOT NULL
  • option_code_id — BIGINT — Foreign key → property_option_code.option_code_id — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • default_value — VARCHAR(5)
  • display_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

property_verification

  • property_verification_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — NOT NULL
  • verification_type — VARCHAR(30) — NOT NULL
  • applicant_member_id — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • submitted_at — DATETIME(6) — NOT NULL
  • reviewer_member_id — BIGINT
  • reviewer_role — VARCHAR(30)
  • reviewed_at — DATETIME(6)
  • verified_at — DATETIME(6)
  • expires_at — DATETIME(6)
  • result_code — VARCHAR(50)
  • result_reason — VARCHAR(1000)
  • verification_version — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL
  • active_verification_key — VARCHAR(100)
  • renewal_notified_at — DATETIME(6)

property_verification_evidence

  • verification_evidence_id — BIGINT — Primary key — NOT NULL
  • property_verification_id — BIGINT — Foreign key → property_verification.property_verification_id — NOT NULL
  • property_file_id — BIGINT — Foreign key → property_file.property_file_id — NOT NULL
  • evidence_type — VARCHAR(50) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by_member_id — BIGINT
  • created_by_role — VARCHAR(30)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by_member_id — BIGINT
  • updated_by_role — VARCHAR(30)
  • deleted_at — DATETIME(6)
  • deleted_by_member_id — BIGINT
  • deleted_by_role — VARCHAR(30)
  • delete_reason — VARCHAR(500)
  • action_source — VARCHAR(20) — NOT NULL

region

  • region_id — bigint — Primary key — NOT NULL
  • parent_region_id — bigint — Foreign key → region.region_id
  • region_code — char(10) — NOT NULL
  • region_name — varchar(100) — NOT NULL
  • full_region_name — varchar(300) — NOT NULL
  • region_level — tinyint — NOT NULL
  • region_type — varchar(30) — NOT NULL
  • center_location — point
  • has_children — tinyint(1) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • effective_from — date
  • effective_to — date
  • replacement_region_id — bigint — Foreign key → region.region_id
  • created_at — datetime(6) — NOT NULL
  • created_by_member_id — bigint
  • created_by_role — varchar(30)
  • updated_at — datetime(6) — NOT NULL
  • updated_by_member_id — bigint
  • updated_by_role — varchar(30)
  • deleted_at — datetime(6)
  • deleted_by_member_id — bigint
  • deleted_by_role — varchar(30)
  • delete_reason — varchar(500)
  • action_source — varchar(20) — NOT NULL

region_boundary

  • region_boundary_id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.region_id — NOT NULL
  • geometry_type — varchar(20) — NOT NULL
  • boundary_geometry — multipolygon — NOT NULL
  • south_west_latitude — decimal(10,7) — NOT NULL
  • south_west_longitude — decimal(10,7) — NOT NULL
  • north_east_latitude — decimal(10,7) — NOT NULL
  • north_east_longitude — decimal(10,7) — NOT NULL
  • source_name — varchar(100) — NOT NULL
  • source_version — varchar(50) — NOT NULL
  • checksum — char(64) — NOT NULL
  • simplification_level — tinyint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • created_by_member_id — bigint
  • created_by_role — varchar(30)
  • updated_at — datetime(6) — NOT NULL
  • updated_by_member_id — bigint
  • updated_by_role — varchar(30)
  • deleted_at — datetime(6)
  • active_region_boundary_key — bigint
  • deleted_by_member_id — bigint
  • deleted_by_role — varchar(30)
  • delete_reason — varchar(500)
  • action_source — varchar(20) — NOT NULL

region_import_batch

  • region_import_batch_id — bigint — Primary key — NOT NULL
  • batch_version — varchar(100) — NOT NULL
  • source_name — varchar(100) — NOT NULL
  • source_date — date — NOT NULL
  • source_checksum — char(64) — NOT NULL
  • import_status — varchar(30) — NOT NULL
  • archive_status — varchar(30) — NOT NULL
  • total_count — int — NOT NULL
  • valid_count — int — NOT NULL
  • invalid_count — int — NOT NULL
  • error_summary_json — json
  • started_at — datetime(6)
  • completed_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • created_by_member_id — bigint
  • created_by_role — varchar(30)
  • updated_at — datetime(6) — NOT NULL
  • updated_by_member_id — bigint
  • updated_by_role — varchar(30)
  • deleted_at — datetime(6)
  • deleted_by_member_id — bigint
  • deleted_by_role — varchar(30)
  • delete_reason — varchar(500)
  • action_source — varchar(20) — NOT NULL