CERA
Module Data_Access and others
Modules DATA_ACCESS and others
Meaning, type, and size of CERA Core 2.5 and CERA Modules' table attributes
Required attributes are marked with an asterisk; no NULL values should occur in any CERA field (neutral items are in the selection lists or are defaulted, in case meanigful input can not be given, e.g., "n/a" for not available or not applicable information).
Tables are divided into the CERA Core blocks and the CERA Modules, marked as "entities E" (except LOVs), "lists of values L" (LOVs), and "relations R". For the LOVs the default values "not filled" and "n/a" are not displayed. The basic sets of values are to be understood as suggestion.
Attributes Definition for CERA Modules DATA_ACCESS, MODEL_INPUT and METADATA_STANDARD
Module DATA_ACCESS (4 TABLES)
| additionally into PARAMETER | TYPE*SIZE | EXPLANATION / COMMENT |
|---|---|---|
| data_access_id | integer | Foreign key to DATA_ACCESS. |
| Table DATA_ACCESS E |
TYPE*SIZE | EXPLANATION / COMMENT |
| data_access_id | integer | Primary key. |
| access_structure_id | integer | Foreign key to ACCESS_STRUCTURE. |
| storage1_id | integer | Foreign key to STORAGE1. |
| storage2_id | integer | Foreign key to STORAGE2. |
| storage3_id | integer | Foreign key to STORAGE3. |
| storage4_id | integer | Foreign key to STORAGE4. |
| rec_structure_id | integer | Foreign key to REC_STRUCTURE. |
| modification_date | date | Date when the data access has changed last time = when the information of this table was valid. |
| Table REC_STRUCTURE E |
TYPE*SIZE | EXPLANATION / COMMENT |
| rec_structure_id | integer | Primary key. |
| structure_name | char*250 | Name, describing the structure given for the five dimensions in this record. |
| dim1_type | char*10 | Type of the fastest varying dimension in storage (= name of the table discribing this dimension). |
| dim1_id | integer | Foreign key to POINT_SET, SCALE, TIME, or PARA_ORDER according to the description in dim1_type. PARA_ORDER can be a local table to specify the storage sequence of a number of different topics. |
| dim2_type | char*10 | Type of the second fastest varying dimension in storage (= name of the table discribing this dimension). |
| dim2_id | integer | Foreign key to POINT_SET, SCALE, TIME, or PARA_ORDER according to the description in dim2_type. |
| dim3_type | char*10 | Type of the third fastest varying dimension in storage (= name of the table discribing this dimension). |
| dim3_id | integer | Foreign key to POINT_SET, SCALE, TIME, or PARA_ORDER according to the description in dim3_type. |
| dim4_type | char*10 | Type of the fourth fastest varying dimension in storage (= name of the table discribing this dimension). |
| dim4_id | integer | Foreign key to POINT_SET, SCALE, TIME, or PARA_ORDER according to the description in dim4_type. |
| dim5_type | char*10 | Type of the fifth fastest varying dimension in storage (= name of the table discribing this dimension). |
| dim5_id | integer | Foreign key to POINT_SET, SCALE, TIME, or PARA_ORDER according to the description in dim5_type. PARA_ORDER can be a local table to specify the storage sequence of a number of different topics. |
| Table STORAGE E |
TYPE*SIZE | aliased as STORAGE1, STORAGE2, STORAGE3, STORAGE4 |
| storage_id | integer | Primary key. |
| storage_name | char*250 | The storage information assigned to this field according the description in table ACCESS_STRUCTURE. |
| Table ACCESS_STRUCTURE L |
TYPE*SIZE | EXPLANATION / COMMENT |
| access_structure_id | integer | Primary key. |
| access_structure_name | char*80 | Name of the access structure described in access_structure_descr. |
| access_structure_descr | char*2000 | Description of the form by which the data access information is stored in STORAGE1 to STORAGE4. |
| basic set of values : | descr | Any description how the data are arranged in the storage. |
Module MODEL_INPUT (3 TABLES)
| Table MODEL E |
TYPE*SIZE | EXPLANATION / COMMENT |
|---|---|---|
| model_id | integer | Primary key. |
| model_type_id | integer | Foreign key to MODEL_TYPE. |
| model_acronym | char*31 | Acronym for the model. |
| model_name | char*250 | Name of the model. |
| model_descr | char*2000 | Description of the model. |
| Table MODEL_TYPE L |
TYPE*SIZE | EXPLANATION / COMMENT |
| model_type_id | integer | Primary key. |
| model_type_acronym | char*31 | Acronym for the type of the model. |
| model_type_name | char*250 | Name of the type of the model. |
| model_type_descr | char*2000 | Description of the type of the model. |
| Table MODEL_INPUT R |
TYPE*SIZE | EXPLANATION / COMMENT |
| entry_id | integer | Foreign key to ENTRY. |
| model_id | integer | Foreign key to MODEL. |
| topic_id | integer | Foreign key to TOPIC. |
| value_number | float*4 | Numerical value of the parameter. |
| unit_id | integer | Foreign key to UNIT. |
| value_string | char*2000 | String value of the parameter or comment. |
| calculation_start | date | (Start) date of the model calculation. |
Module METADATA_STANDARD -draft- (1 TABLE)
| Table DIF_ENTRY E |
TYPE*SIZE | EXPLANATION / COMMENT |
|---|---|---|
| entry_id | integer | Foreign key to ENTRY. |
| dif_title | char*160 | Title of the DIF should convey DIF content i.e. instrument, investigator, mission, parameters measured. |
| dif_name | char*31 | Unique identifier of the DIF for the Dataset, a collection of Datasets or part of a Dataset. |
