Your content here
A market geography cannot be defined only as free text such as “Hampton Roads” or “Northern Virginia.” It must resolve to Census-compatible geographic identifiers.
create table analytics.market_geography_scope (
market_definition_version_id uuid not null
references analytics.market_definition_version,
geoid text not null,
geography_type text not null,
geography_vintage text not null,
inclusion_type text not null check (
inclusion_type in ('include', 'exclude')
),
role text not null check (
role in (
'customer_market',
'service_area',
'supplier_market',
'labor_market',
'comparison_market'
)
),
allocation_weight numeric(12,8),
rationale text not null,
primary key (
market_definition_version_id,
geoid,
geography_type,
geography_vintage,
role,
inclusion_type
)
);
A market can use different geographies for different purposes.
Customer market:
Where eligible buyers live.
Service area:
Where the business can realistically deliver or serve.
Supplier market:
Where competitors and providers operate.
Labor market:
Where staff can be recruited.
Comparison market:
A benchmark geography used for normalization.
These must remain separate unless explicitly merged.