16 lines
789 B
PL/PgSQL
16 lines
789 B
PL/PgSQL
-- 041_house_sources_noop.sql
|
|
-- Purpose: Document that house_sources already exists (028 + 029) and satisfies
|
|
-- Cross_Source_Matching_Strategy sec 2.1. Column-name aliases noted in COMMENTs.
|
|
-- Dependencies: 028_matching_tables.sql, 029_extend_matching_valuation_dynamics.sql
|
|
-- No DDL changes — idempotent COMMENT-only file.
|
|
|
|
BEGIN;
|
|
|
|
COMMENT ON COLUMN house_sources.ext_source IS
|
|
'Source identifier (alias of "source" in Master Plan sec 2.1). Values: avito/cian/yandex/n1.';
|
|
COMMENT ON COLUMN house_sources.ext_id IS
|
|
'External house id from source (alias of "ext_house_id" in Master Plan).';
|
|
COMMENT ON COLUMN house_sources.matched_method IS
|
|
'Match method (alias of "match_method" in Master Plan). Values: cadastr_exact/address_geo_year/geo_only/new/manual.';
|
|
|
|
COMMIT;
|