Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('gobs.dimension_id_seq'::regclass) |
|
|
||||
| fk_id_indicator | int4 | 10 | √ | null |
|
|
Id of the corresponding indicator. |
|||
| di_code | text | 2147483647 | null |
|
|
Code of the vector dimension. Ex: ‘pop_h’ or ‘pop_f’ |
||||
| di_label | text | 2147483647 | null |
|
|
Label of the vector dimensions. Ex: ‘population homme’ or ‘population femme’ |
||||
| di_type | text | 2147483647 | null |
|
|
Type of the stored values. Ex: ‘integer’ or ‘real’ |
||||
| di_unit | text | 2147483647 | √ | null |
|
|
Unit ot the store values. Ex: ‘inhabitants’ or ‘°C’ |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dimension_pkey | Primary key | Asc | id |
| dimension_fk_id_indicator_di_code_key | Must be unique | Asc/Asc | fk_id_indicator + di_code |
Relationships
Close relationships within degrees of separation
