You are here: Home / Systems / CERA / Data Model / Tables & Attributes / Block METADATA_ENTRY and others

Block METADATA_ENTRY and others

Blocks METADATA_ENTRY, ENTRY_CONNECT, CAMPAIGN and CONTACT.

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 Blocks METADATA_ENTRY, CAMPAIGN, ENTRY_CONNECT, CONTACT

Block METADATA ENTRY (8 TABLES)


Table
ENTRY E
TYPE*SIZE aliased as ENTRY1
entry_id integer Primary key.
entry_name char*160 * Entry name uniquely identifying this metadata record.
entry_acronym char*31 Acronym of the entry_name, uniquely identifying the entry.
entry_type_id integer Foreign key to ENTRY_TYPE.
summary_id integer Foreign key to SUMMARY.
quality_id integer Foreign key to QUALITY.
progress_id integer Foreign key to PROGRESS.
creation_date date Creation date of metadata (i.e. of this record).
review_date date Date of last review of the metadata.
future_review_date date Future time at which the metadata should be reviewed for accuracy of scientific or technical content.

Table
SUMMARY E
TYPE*SIZE EXPLANATION / COMMENT
summary_id integer Primary key.
summary char*2000 Contains an abstract and additional information not contained in other fields.

Table
ENTRY_TYPE L
TYPE*SIZE EXPLANATION / COMMENT
entry_type_id integer Primary key.
entry_type char*31 If entry records have different types: Type of entry.
entry_type_descr char*2000 If entry records have different types: description of type of entry.
basic set of values : type/descr measurements / measured data; model data / data are model output

Table
PROGRESS L
TYPE*SIZE EXPLANATION / COMMENT
progress_id integer Primary key.
progress_descr char*2000 The state of the data set in the institute (e.g. complete, in work, planned).
basic set of values : descr complete; in work; planned; complete, original; complete, processed.

Table
QUALITY E
TYPE*SIZE EXPLANATION / COMMENT
quality_id integer Primary key.
accuracy_report char*2000 Quantitative accuracy of the attributes described by the data (e.g. information on error bars).
consistency_report char*2000 An explanation of the fidelity of the relationships in the data set and the tests used for their proof.
completeness_report char*2000 Information about omissions, selection criteria, generalization, definitions used, and other rules to derive the data set.
horizontal_acc_report char*2000 Quantitative horizontal position accuracy.
vertical_acc_report char*2000 Quantitative vertical position accuracy.

Block CAMPAIGN (2 TABLES)


Table
PROJECT L
TYPE*SIZE EXPLANATION / COMMENT
project_id integer Primary key.
project_acronym char*31 Abbreviated version of project_name.
project_descr char*2000 Description of the Project.
project_name char*250 Scientific endeavour encompassing data from a number of data sources or inhouse project, to which the data belongs.
basic set of values : - The projects, run in the specific institute can serve as a basic set of values.

Table
CAMPAIGN R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
project_id integer Foreign key to PROJECT.

Block ENTRY_CONNECT (2 TABLES)


Table
ENTRY_CONNECT R
TYPE*SIZE EXPLANATION / COMMENT
gen_entry_id integer Foreign key to ENTRY.
spec_entry_id integer Foreign key to ENTRY.
connect_type_id integer Foreign key to CONNECT_TYPE.

Table
CONNECT_TYPE L
TYPE*SIZE EXPLANATION / COMMENT
connect_type_id integer Primary key.
connect_type char*31 Type of the connect between two entries (e.g. hierarchical).
connect_type_descr char*2000 Description of the connect_type.
basic set of values : type/descr hierarchical / the two records are bound hierarchically.

Block CONTACT (4 TABLES)


Table INSTITUTE E TYPE*SIZE aliased as INSTITUTE1
institute_id integer Primary key.
institute_name char*80 Name of the institute. Use the original name given by the institute to itself (if translation is necessary, translate to english).
institute_acronym char*31 Abbreviated version of the institute name.
department_name char*160 Name of the department or institute sub-division. Use multiple records for different departments.
department_acronym char*31 Abbreviated version of the department name.
country char*80 Full name of the country (address).
state_or_province char*80 Name of the state or province (address).
place char*80 Name of the place/city (address).
street char*80 Name of the street (address).
street_postal_code char*10 Postal code of the street address.
pobox char*80 Pobox (address).
pobox_postal_code char*10 Postal code of the Post box address (if different from street_postal_code).
url char*80 Universal Resource Locator of the institute's homepage.
additional_info char*250 Additional address information, or other information about the institute.
Table PERSON E TYPE*SIZE EXPLANATION / COMMENT
person_id integer Primary key.
first_name char*80 First name.
second_name char*80 Second name.
last_name char*80 Last name. Instead of a person's name a position or office may be given (e.g. secretary, central office).
title char*31 Title of the person.
institute_id integer Foreign key to INSTITUTE.
telephone char*80 Phone.
fax char*80 FAX.
url char*80 Universal Resource Locator of the person's home page.
email char*80 Email address.

Table CONTACT_TYPE L
TYPE*SIZE EXPLANATION / COMMENT
contact_type_id integer Primary key.
contact_type char*80 Type of the contact (investigator, technical info, copyright etc.).
basic set of values : type investigator; originator; distributor; technical; metadata; copyright; owner; inhouse.

Table CONTACT R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
instiute_id integer Foreign key to INSTITUTE.
person_id integer Foreign key to PERSON.
contact_type_id integer Foreign key to CONTACT_TYPE.

Document Actions