Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| address_code | varchar | 11 | null |
|
|
住所コード |
|||||
| address_level | int2 | 5 | √ | null |
|
|
住所レベル (1: 都道府県, 2: 市区町村, 3: 大字・町名, 4: 字・丁目) |
||||
| date | date | 13 | null |
|
|
日付 |
|||||
| scope | varchar | 10 | null |
|
|
範囲 (national: 全国, prefecture: 都道府県内, city: 市区町村内, town: 大字・町名内) |
|||||
| metric | varchar | 20 | null |
|
|
指標 (population: 人口, household: 世帯, area: 面積, population_density: 人口密度) |
|||||
| rank | int4 | 10 | null |
|
|
順位 |
|||||
| value | numeric | 0 | null |
|
|
順位の算出に使用した値 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_address_ranks_address_code_address_level_date_scope_metric | Must be unique | Asc/Asc/Asc/Asc/Asc | address_code + address_level + date + scope + metric |
| idx_address_ranks_scope_metric_date_rank | Performance | Asc/Asc/Asc/Asc | scope + metric + date + rank |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| address_ranks_metric_check | (((metric)::text = ANY ((ARRAY['population'::character varying, 'household'::character varying, 'area'::character varying, 'population_density'::character varying])::text[]))) |
| address_ranks_scope_check | (((scope)::text = ANY ((ARRAY['national'::character varying, 'prefecture'::character varying, 'city'::character varying, 'town'::character varying])::text[]))) |