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

Print this