Zip-da-project-property
Tables (31)
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
- source_name — VARCHAR(100)
- 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_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(500)
- is_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
- property_id — BIGINT — Primary key — 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 — TINYINT
- bathroom_count — TINYINT
- floor — SMALLINT
- total_floor — SMALLINT
- floor_condition — VARCHAR(30)
- direction — VARCHAR(20)
- approval_date — DATE
- building_use — VARCHAR(100)
- parking_status — VARCHAR(30) — NOT NULL
- elevator_status — VARCHAR(30) — NOT NULL
- pet_policy — VARCHAR(30) — NOT NULL
- move_in_status — VARCHAR(30) — NOT NULL
- available_move_in_date — DATE
- jeonse_loan_available — VARCHAR(30) — NOT NULL
- title — VARCHAR(200)
- 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)
- 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_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)
- 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(100) — NOT NULL
- owner_member_id — BIGINT — NOT NULL
- object_key — VARCHAR(500) — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- checksum_sha256 — CHAR(64) — NOT NULL
- file_purpose — VARCHAR(30) — NOT NULL
- upload_status — VARCHAR(30) — NOT NULL
- expires_at — DATETIME(6)
- 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
- 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
- updated_at — DATETIME(6) — NOT NULL
- created_by_member_id — BIGINT
- created_by_role — VARCHAR(30)
- 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)
- 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
- 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
- boolean_value — BOOLEAN
- number_value — DECIMAL(12,2)
- text_value — VARCHAR(300)
- 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
- value_type — VARCHAR(20) — NOT NULL
- unit — VARCHAR(20)
- allowed_values_json — JSON
- 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_outbox
- event_id — VARCHAR(100) — Primary key — NOT NULL
- aggregate_type — VARCHAR(50) — NOT NULL
- aggregate_id — BIGINT — NOT NULL
- event_type — VARCHAR(100) — NOT NULL
- payload_json — JSON — NOT NULL
- schema_version — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- retry_count — INT — NOT NULL
- next_retry_at — DATETIME(6)
- published_at — DATETIME(6)
- last_error_code — VARCHAR(100)
- trace_id — VARCHAR(100) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- archived_at — DATETIME(6)
- 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
- 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
- detail — TEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- risk_score — DECIMAL(5,2)
- assigned_admin_id — BIGINT
- triaged_at — DATETIME(6)
- closed_at — DATETIME(6)
- version — BIGINT — NOT NULL
- active_report_key — VARCHAR(250)
- 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
- report_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
- before_publication_status — VARCHAR(30)
- after_publication_status — VARCHAR(30)
- actor_member_id — BIGINT — NOT NULL
- actor_role — VARCHAR(30) — NOT NULL
- reason — VARCHAR(1000) — NOT NULL
- member_sanction_request_id — VARCHAR(100)
- trace_id — VARCHAR(100) — NOT NULL
- acted_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 — TEXT — 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(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
property_saved_search
- saved_search_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- normalized_condition_json — JSON — NOT NULL
- condition_hash — CHAR(64) — NOT NULL
- schema_version — INT — NOT NULL
- sort_condition — VARCHAR(30)
- view_mode — VARCHAR(20)
- is_default — BOOLEAN — NOT NULL
- version — BIGINT — NOT NULL
- active_name_key — VARCHAR(200)
- active_default_key — VARCHAR(100)
- 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_search_history
- search_history_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- keyword_summary — VARCHAR(200)
- region_id — BIGINT — Foreign key → region.region_id
- normalized_condition_json — JSON — NOT NULL
- condition_hash — CHAR(64) — NOT NULL
- sort_condition — VARCHAR(30)
- center_location — POINT
- min_lat — DECIMAL(10,7)
- max_lat — DECIMAL(10,7)
- min_lng — DECIMAL(10,7)
- max_lng — DECIMAL(10,7)
- zoom_level — TINYINT
- result_count — INT
- searched_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_search_preference
- preference_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- last_region_id — BIGINT — Foreign key → region.region_id — NOT NULL
- normalized_filter_state_json — JSON — NOT NULL
- sort_condition — VARCHAR(30)
- view_mode — VARCHAR(20)
- center_location — POINT
- min_lat — DECIMAL(10,7)
- max_lat — DECIMAL(10,7)
- min_lng — DECIMAL(10,7)
- max_lng — DECIMAL(10,7)
- zoom_level — TINYINT
- last_searched_at — DATETIME(6)
- schema_version — INT — NOT NULL
- version — BIGINT — NOT NULL
- active_member_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_status_history
- property_status_history_id — BIGINT — Primary key — NOT NULL
- property_id — BIGINT — Foreign key → property.property_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)
- action_source — VARCHAR(20) — NOT NULL
- 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)
property_subway_access
- property_subway_access_id — BIGINT — Primary key — NOT NULL
- property_id — BIGINT — Foreign key → property.property_id — NOT NULL
- subway_station_id — BIGINT — Foreign key → subway_station.subway_station_id — NOT NULL
- distance_meters — INT — NOT NULL
- estimated_walking_minutes — SMALLINT — NOT NULL
- calculation_location_type — VARCHAR(30) — NOT NULL
- calculated_at — DATETIME(6) — NOT NULL
- source_date — DATE — 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_boolean_value — BOOLEAN
- 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
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
- retention_until — DATETIME(6)
- destroyed_at — DATETIME(6)
- 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 — BOOLEAN — NOT NULL
- is_active — BOOLEAN — 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)
- 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
subway_line
- subway_line_id — BIGINT — Primary key — NOT NULL
- line_code — VARCHAR(50) — NOT NULL
- line_name — VARCHAR(100) — NOT NULL
- display_color — CHAR(7)
- 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
subway_station
- subway_station_id — BIGINT — Primary key — NOT NULL
- station_code — VARCHAR(50) — NOT NULL
- station_name — VARCHAR(100) — NOT NULL
- location — POINT — NOT NULL
- region_id — BIGINT — Foreign key → region.region_id
- is_active — BOOLEAN — NOT NULL
- source_date — DATE — 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
subway_station_line
- subway_station_line_id — BIGINT — Primary key — NOT NULL
- subway_station_id — BIGINT — Foreign key → subway_station.subway_station_id — NOT NULL
- subway_line_id — BIGINT — Foreign key → subway_line.subway_line_id — NOT NULL
- display_order — INT
- 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