Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
survey_index_id | serial | 10 | √ | nextval('examples.survey_index_survey_index_id_seq'::regclass) |
|
|
||||
data_source_id | int4 | 10 | √ | null |
|
|
||||
index_type_id | int4 | 10 | √ | null |
|
|
||||
areacell_id | int4 | 10 | √ | null |
|
|
Areacell data relates to |
|||
year | int4 | 10 | null |
|
|
Year sample was taken |
||||
month | int4 | 10 | null |
|
|
Month sample was taken |
||||
value | float4 | 8,8 | null |
|
|
Value at this point in time |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
survey_index_pkey | Primary key | Asc | survey_index_id |