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