| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('edp_core_tdta_object_id_seq'::regclass) |
|
|
unique identifier of object |
|||||||||||||||||||
| name | varchar | 255 | null |
|
|
Object title |
||||||||||||||||||||
| abstract | text | 2147483647 | √ | null |
|
|
Summary describing the object - mandatory, p.1.3.1.3 of the Specification |
|||||||||||||||||||
| project_id | int4 | 10 | √ | null |
|
|
Relation to the project - Mandatory, p.1.3.1.2 of the Specification |
|||||||||||||||||||
| created | timestamptz | 35,6 | null |
|
|
Automatical creation date of the object (Date of metadata creation (YYYY-MM-DD) - Mandatory, p.1.3.1.9 of the Specification |
||||||||||||||||||||
| updated | timestamptz | 35,6 | null |
|
|
Automatical update date of the object (YYYY-MM-DD) |
||||||||||||||||||||
| period_from | date | 13 | √ | null |
|
|
temporal cover of the object (begining) |
|||||||||||||||||||
| period_to | date | 13 | √ | null |
|
|
temporal cover of the object (end) |
|||||||||||||||||||
| status_id | int4 | 10 | √ | null |
|
|
Status of the object (published, unpublished, archived, deleted) related to tkey_status value list |
|||||||||||||||||||
| constraint_access | varchar | 255 | √ | null |
|
|
Access constraint |
|||||||||||||||||||
| constraint_other | varchar | 255 | √ | null |
|
|
Other constraint |
|||||||||||||||||||
| constraint_class_id | int4 | 10 | √ | null |
|
|
classification constraint - Most common value, p.1.3.1.15.4 of the Specification |
|||||||||||||||||||
| constraint_use_id | int4 | 10 | √ | null |
|
|
use contraint (copyright) - Mandatory, p.1.3.1.15 of the Specification |
|||||||||||||||||||
| spatial_ext_id | int4 | 10 | √ | null |
|
|
Relation to spatial extent (EU28, EU28+4) - |
|||||||||||||||||||
| resource_uuid | varchar | 255 | √ | null |
|
|
Unique resource identifier - Mandatory, p.1.3.1.6 of the Specification |
|||||||||||||||||||
| spatial_resolution | varchar | 255 | √ | null |
|
|
Free text to describe spatial resolution of the object |
|||||||||||||||||||
| sequence | int4 | 10 | null |
|
|
|||||||||||||||||||||
| status_comment | text | 2147483647 | √ | null |
|
|
||||||||||||||||||||
| publication_date | timestamptz | 35,6 | √ | null |
|
|
Table contained 977 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edp_core_tdta_object_pkey | Primary key | Asc | id |
| edp_core_tdta_object_constraint_class_id_95ffa7ad | Performance | Asc | constraint_class_id |
| edp_core_tdta_object_constraint_use_id_751826cc | Performance | Asc | constraint_use_id |
| edp_core_tdta_object_projects_id_c18331e9 | Performance | Asc | project_id |
| edp_core_tdta_object_spatial_ext_id_d51280b4 | Performance | Asc | spatial_ext_id |
| edp_core_tdta_object_status_id_eb58ec86 | Performance | Asc | status_id |
