| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tdta_object_ptr_id | int4 | 10 | null |
|
|
Relation to the common object table |
||||||||||
| code |
varchar | 100 | √ | null |
|
|
Indicator code - Mandatory, p.1.5.1-3 of the Specification |
|||||||||
| dataitem_type_id | int4 | 10 | √ | null |
|
|
Relation to data item type (type identifier) - See p.3.4.3 of the specification! |
|||||||||
| nattype_id | int4 | 10 | √ | null |
|
|
Relation to NAT type - Mandatory, one of NAT type identifiers: CF, CS, IR, IC, IA, TG, TP, TS |
|||||||||
| core_type_id | int4 | 10 | √ | null |
|
|
relation to core indicator type defined in M4D - Mandatory, p.TODO of the Specification |
|||||||||
| type_id | int4 | 10 | null |
|
|
Indicator type id linked to the value list indicator type (single, multi, dimension, class) |
||||||||||
| is_standard_data | bool | 1 | null |
|
|
Identification flag true = standard data related to an internal nomenclature, false = non standard data |
||||||||||
| method_description | text | 2147483647 | √ | null |
|
|
Description of the calculation method used |
|||||||||
| measure_nd_name | varchar | 255 | √ | null |
|
|
Numerator / Denominator Name - Mandatory (for numeric data, otherwise inexistent, p.1.5.4.1-2 of the Specification) |
|||||||||
| measure_nd_scale | varchar | 255 | √ | null |
|
|
Numerator / Denominator Scale - Mandatory (for numeric data, otherwise inexistent, p.1.5.4.3-4 of the Specification) |
|||||||||
| measure_ranking | bool | 1 | null |
|
|
Ranking - Mandatory (for numeric as well as enumerated data) |
||||||||||
| calculation_date | date | 13 | √ | null |
|
|
Date of the indicator calculation |
|||||||||
| insertion_date | date | 13 | √ | null |
|
|
Date of the data insertion |
|||||||||
| update_date | date | 13 | √ | null |
|
|
Date of the last indicator update |
|||||||||
| years | varchar | 255 | √ | null |
|
|
List of years covered by the indicator |
Table contained 838 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edp_core_tdta_indicator_pkey | Primary key | Asc | tdta_object_ptr_id |
| edp_core_tdta_indicator_core_type_id_57caeca9 | Performance | Asc | core_type_id |
| edp_core_tdta_indicator_dataitem_type_id_fa72a4d3 | Performance | Asc | dataitem_type_id |
| edp_core_tdta_indicator_nattype_id_76936bd9 | Performance | Asc | nattype_id |
| edp_core_tdta_indicator_type_id_69da88e5 | Performance | Asc | type_id |
