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