You are here: Home / Systems / CERA / Data Model / Tables & Attributes / Module Data_Access and others

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.

Document Actions