HOME UP bottom of document

Attribute Descriptions of CERA Core, Version 2.5 and various CERA Modules

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.
Block METADATA ENTRY	5 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 KEY_CONNECT	2 TABLES	-
Table GENERAL_KEY L	TYPE*SIZE	EXPLANATION / COMMENT
general_key_id	integer	Primary key.
general_key	char*250	* Keyword list: any words or phrases used to further describe the entry.
Table KEY_CONNECT R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
general_key_id	integer	Foreign key to GENERQAL_KEY.
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 LANGUAGES	2 TABLES	-
Table LANGUAGES	TYPE*SIZE	EXPLANATION / COMMENT
language_id	integer	Primary key.
language_name	char*250	The language of the data document.
Table LANGUAGES R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
language_id	integer	Foreign key to LANGUAGE.
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 REFERENCE	5 TABLES	-
Table CITATION E	TYPE*SIZE	EXPLANATION / COMMENT
citation_id	integer	Primary key.
title	char*2000	Title of a publication related to the entry.
authors	char*2000	List of the authors as given in the citation.
publication	char*80	Name of the publication (e.g. of the journal, entology, editorial).
publisher	char*80	Name of the publisher.
editor	char*80	Name of the editor(s).
publication_date	date	Date of the publication. If day and/or month unknown set to 1.
country	char*80	Name of the country (address).
state	char*80	Name of the state (address).
place	char*80	Name of the place (address).
edition	char*80	Name of the edition.
access_spec	char*160	Specification (number) of the citation_type (the URL, the ISBN, etc.).
additional_info	char*250	Comment.
presentation_id	integer	Foreign key to PRESENTATION.
citation_type_id	integer	Foreign key CITATION_TYPE.
Table CITATION_TYPE L	TYPE*SIZE	EXPLANATION / COMMENT
citation_type_id	integer	Primary key.
citation_type	char*80	Type of the citation (e.g. book, journal, web publication etc.).
citation_type_descr	char*2000	Description of citation_type.
basic set of values :	type	other; www publication; other internet access; CD publication; book; journal; unreviewed publication.
Table PRESENTATION L	TYPE*SIZE	EXPLANATION / COMMENT
presentation_id	integer	Primary key.
presentation_descr	char*2000	Type of the data presentation, e.g. graph, picture, table...
basic set of values :	descr	atlas; diagram; globe; image: remote sensing; image: view/aerial photograph; map: political; map: thematic; map; numerical data; profile; section.
Table REF_TYPE L	TYPE*SIZE	EXPLANATION / COMMENT
ref_type_id	integer	Primary key.
ref_type_descr	char*2000	Description of the relation, the publication has to the entry.
basic set of values :	descr	publication provides data; publication uses data.
Table REFERENCE R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
citation_id	integer	Foreign key to CITATION.
ref_type_id	integer	Foreign key to REF_TYPE.
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.
Block PARAMETER	5 TABLES	-
Table AGGREGATION L	TYPE*SIZE	EXPLANATION / COMMENT
aggregation_id	integer	Primary key.
aggregation_descr	char*80	Description of the aggregation of the meeasured TOPIC, e.g. monthly mean, daily maximum.
basic set of values :	descr	none; any combination of: annual, biannual, bimonthly, daily, hourly, monthly, quarterly, weekly ---- interval, max., mean, min., scatter, std.dev., sum.
Table SPATIAL_DATA_ORG L	TYPE*SIZE	EXPLANATION / COMMENT
spatial_dat_org_id	integer	Primary key.
reference_method	char*80	Form by that the data references the space (e.g. point, vector, raster, spectral...).
basic set of values :	method	indirect spatial reference (e.g. by names of types of geographic features); point(s), non gridded; vector; points: gridded; LON:spectral/LAT:gridded.
Table TOPIC L	TYPE*SIZE	aliased as TOPIC1, TOPIC2, TOPIC3
topic_id	integer	Primary key.
topic_name	char*80	Kinds of measurements/physical quantities represented by the data. A keyword list exists (e.g. sea level).
topic_acronym	char*31	Abbreviated version of topic_name.
topic_descr	char*2000	Description of the topic.
topic_pointer	integer	topic_id of the preceeding topic in the hierarchical structure of the table TOPIC.
topic_level	integer*2	Level of topic in the hierachical structure of this table.
basic set of values :	-	see Table TOPIC.
Table UNIT L	TYPE*SIZE	aliased as UNIT1, UNIT2
unit_id	integer	Primary key.
unit_name	char*80	Unit of the physical quantity found in table TOPIC.
unit_acronym	char*31	Abbreviated version of unit_name.
unit_descr	char*2000	Definition of units in measured physical quantities.
basic set of values :	-	Any unit necessary for the data the institute deals with.
Table PARAMETER R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
topic_id	integer	Foreign key to TOPIC.
unit_id	integer	Foreign key to UNIT.
aggregation_id	integer	Foreign key to AGGREGATION.
spatial_data_org_id	integer	Foreign key to SPATIAL_DATA_ORG.
optional: data_access_id	integer	Foreign key to Module DATA_ACCESS
optional: data_org_id	integer	Foreign key to Module DATA_ORGANIZATION
optional: data_org_seq	integer	Sequence of topics, if ordered
Block SPATIAL REFERENCE	3 TABLES	-
Table HOR_COORD_SYS L	TYPE*SIZE	EXPLANATION / COMMENT
hor_coord_sys_id	integer	Primary key.
sys_descr	char*2000	Description of the horizontal coordinate system(s).
basic set of values :	descr	LON and LAT: geographic; LON and LAT: planar; local; LON: geographic, LAT: spectral.
Table VER_COORD_SYS L	TYPE*SIZE	EXPLANATION / COMMENT
ver_coord_sys_id	integer	Primary key.
sys_descr	char*2000	Description of the vertical coordinate system(s).
basic set of values :	descr	no vertical extension; altitude: length; altitude: pressure; altitude and depth: length; altitude: pressure, depth: length; depth: length.
Table SPATIAL_REFERENCE R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
hor_coord_sys_id	integer	Foreign key to HOR_COORD_SYS.
ver_coord_sys_id	integer	Foreign key to VER_COORD_SYS.
Block DISTRIBUTION	6 TABLES	-
Table ACCESS_CONSTRAINT L	TYPE*SIZE	EXPLANATION / COMMENT
access_constraint_id	integer	Primary key.
constraint_descr	char*2000	Description of the permits of the data: Permit to see the data, permit to copy for own purpose.
basic set of values :	descr	unrestricted; institute only; work group only; owner only (supply owner in CONTACT in this case); inhouse unrestricted, externally only in collaborations.
Table ACCESS_TYPE L	TYPE*SIZE	Dependent on the value of PROGRESS.progress_descr the access type may refer to the inhouse storage medium or to the form of distribution (in case of remote data).
access_type_id	integer	Primary key.
access_acronym	char*31	Short version of access_descr.
access_descr	char*2000	Description of physical access to the data.
basic set of values :	acronym	remote; 3 1/2" diskette; 5 1/4" diskette; audiocassette; cartridge tape; CD-ROM; chart; computer programme; disc: DB Table; disc: DB blob pointer; disc: normal file; disc: other; electronic bulletin board; electronic mail system; filmstrip; magnetic tape; microfiche; microfilm; online: other; offline: other; paper; physical model; stable-base material; transparency; videocassette; videodisc; videotape.
Table FEES L	TYPE*SIZE	EXPLANATION / COMMENT
fees_id	integer	Primary key.
fees_acronym	char*31	Short version of fees_descr.
fees_descr	char*2000	Description of the fees charged for the data.
basic set of values :	acronym	none; UIG GebVO; like UIG GebVO; low price (<100 Eu); medium price (100-500 Eu); high price (>500 Eu).
Table FORMAT L	TYPE*SIZE	EXPLANATION / COMMENT
format_id	integer	Primary key.
format_acronym	char*31	Entry format, e.g. GIF, GRIB.
format_descr	char*2000	Explanation of the format_acronym.
basic set of values :	-	see Table FORMAT.
Table USE_CONSTRAINT L	TYPE*SIZE	EXPLANATION / COMMENT
use_constraint_id	integer	Primary key.
constraint_descr	char*2000	Description of the permits of the data: Permit to use and publish the data.
basic set of values :	descr	unrestricted; institute only; work group only; owner only (supply owner in CONTACT in this case); inhouse unrestricted, externally only in collaborations.
Table DISTRIBUTION R	TYPE*SIZE	aliased as DISTRIBUTION1
entry_id	integer	Foreign key to ENTRY.
access_type_id	integer	Foreign key to ACCESS_TYPE.
data_size	float*8	Size of data set in Bytes. The data_size should be a whole number. However, it is not defined as integer to enable input in scientific format (e.g. 2E+9).
format_id	integer	Foreign key to FORMAT.
fees_id	integer	Foreign key to FEES.
access_constraint_id	integer	Foreign key to ACCESS_CONSTRAINT.
use_constraint_id	integer	Foreign key to USE_CONSTRAINT.
Block COVERAGE	4 TABLES	-
Table SPATIAL_COVERAGE E	TYPE*SIZE	EXPLANATION / COMMENT
spatial_coverage_id	integer	Primary key.
min_lat	float*4	* Southernmost latitude of the area covered by the data (south of Equator negative).
max_lat	float*4	* Northernmost latitude of the area covered by the data (south of Equator negative).
min_lon	float*4	* Westernmost longitude of the area covered by the data (west of Greenwich negative).
max_lon	float*4	* Easternmost longitude of the area covered by the data (west of Greenwich negative).
min_altitude	float*4	Lowest depth/altitude of the vertical coverage of the data.
min_alt_unit_id	integer	Foreign key to UNIT.
max_altitude	float*4	Highest depth/altitude of the vertical coverage of the data.
max_alt_unit_id	integer	Foreign key to UNIT.
Table TEMPORAL_COVERAGE E	TYPE*SIZE	EXPLANATION / COMMENT
temporal_coverage_id	integer	Primary key.
start_year	integer*8	* Start year of the time covered by the data (YYYYYY...).
start_month	integer*1	Start month (MM), 0 (zero) if unknown or undefined.
start_day	integer*1	Start day (DD), 0 (zero) if unknown or undefined.
stop_year	integer*8	* End year of the time covered by the data (YYYYYY...). stop_year=999999 stands for continously supplemented data (an appropriate item in CURRENTNESS_REF should be selected).
stop_month	integer*1	End month (MM), 0 (zero) if unknown or undefined.
stop_day	integer*1	End day (DD), 0 (zero) if unknown or undefined.
currentness_ref_id	integer	Foreign key to CURRENTNESS_REF.
Table CURRENTNESS_REF L	TYPE*SIZE	EXPLANATION / COMMENT
currentness_ref_id	integer	Primary key.
currentness_ref_descr	char*2000	Basis, for determining the time period of content information (metadata: temporal coverage).
basic set of values :	descr	present ground condition; calendrical publication date; arbitrary numbered years; calendrical time coverage of data; calendrical time coverage of data (continued); climate model time; unchecked data; time before present (1950=0).
Table COVERAGE R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
temporal_coverage_id	integer	Foreign key to TEMPORAL_COVERAGE.
spatial_coverage_id	integer	Foreign key to SPATIAL_COVERAGE.
Block LOCATION_CONNECT	2 TABLES	-
Table LOCATION_CONNECT R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
location_id	integer	Foreign key to LOCATION.
Table LOCATION L	TYPE*SIZE	aliased as LOCATION1, LOCATION2, LOCATION3
location_id	integer	Primary key.
location_name	char*80	Names of place/region.
location_descr	char*2000	Description of place/region.
location_pointer	integer	location_id of the preceeding location in the hierarchical structure of the table LOCATION.
location_level	integer*2	Level of location_id in the hierachical structure of this table.
ref_date	char*15	A date or year, when the information of this record was valid.
min_lat	float*4	Southernmost geogr. latitude of the location area (south of Equator negative), in degrees.
max_lat	float*4	Northernmost geogr. latitude of the location area (south of Equator negative), in degrees.
min_lon	float*4	Westernmost geogr. longitude of the location area (west of Greenwich negative), in degrees.
max_lon	float*4	Easternmost geogr. longitude of the location area (west of Greenwich negative), in degrees.
basic set of values :	ASCII table	see Table LOCATION.
Module PROCESS_STEP, Version 1.0	1 TABLE	-
Table PROCESS_STEP R	TYPE*SIZE	EXPLANATION / COMMENT
entry_id	integer	Foreign key to ENTRY.
process_descr	char*2000	If data has been processed/changed (not just format changes): description of processing.
process_date	date	If data has been processed/changed (not just format changes): date of processing.
person_id	integer	Foreign key to PERSON.
Module DATA_ORGANIZATION, Version 1.3	12 TABLES	-
additionally into PARAMETER	TYPE*SIZE	EXPLANATION / COMMENT
data_org_id	integer	Foreign key to DATA_ORG.
Table DATA_ORG E	TYPE*SIZE	EXPLANATION / COMMENT
data_org_id	integer	Primary key.
data_org_acronym	char*31	Acronym of the data organization in space and time, described by the information in this record.
data_org_name	char*250	Name of the data organization in space and time, described by the information in this record.
data_org_descr	char*2000	Description of the data organization in space and time, described by the information in this record.
space_id	integer	Foreign key to SPACE.
time_id	integer	Foreign key to TIME.
Table SPACE E	TYPE*SIZE	EXPLANATION / COMMENT
space_id	integer	Primary key.
space_acronym	char*31	Acronym of the spatial data organization, described by the information in this record.
space_name	char*250	Name of the spatial data organization, described by the information in this record.
space_descr	char*2000	Description of the spatial data organization, described by the information in this record.
x_scale_id	integer	Foreign key to SCALE, pointing to the scale of coordinate x.
y_scale_id	integer	Foreign key to SCALE, pointing to the scale of coordinate y.
z_scale_id	integer	Foreign key to SCALE, pointing to the scale of coordinate z.
point_set_id	integer	Foreign key to POINT_SET.
Table POINT_SET E	TYPE*SIZE	EXPLANATION / COMMENT
data_org_id	integer	Primary key.
point_set_acronym	char*31	Acronym of the group of points.
point_set_name	char*250	Name of the group of points.
point_set_descr	char*2000	Description of the group of points.
num_points	integer*4	Number of points in the point set.
Table POINT E	TYPE*SIZE	EXPLANATION / COMMENT
point_id	integer	Primary key.
point_name	char*80	Name of the point.
x_value	float*4	x position of the point, longitude if applicable. East positive.
unit_x_id	integer	Foreign key to UNIT.
y_value	float*4	y position of the point, latitude if applicable. North positive.
unit_y_id	integer	Foreign key to UNIT.
z_value	float*4	z position of the point, altitude if applicable. Depth negative.
unit_z_id	integer	Foreign key to UNIT.
Table SCALE E	TYPE*SIZE	aliased as SCALE1, SCALE2
scale_id	integer	Primary key.
scale_acronym	char*31	Acronym or explication of the scale.
scale_name	char*250	Name or explication of the scale.
scale_descr	char*2000	Description or explication of the scale.
num_points	integer*4	Number of points defining the scale in this dimension.
dim_type_id	integer	Foreign key to DIM_TYPE.
Table POSITION E	TYPE*SIZE	EXPLANATION / COMMENT
position_id	integer	Primary key.
position_name	char*80	Name or explication of this position on the axis.
position_value	float*4	Coordinate value of this position on the axis.
unit_id	integer	Foreign key to UNIT.
Table TIME E	TYPE*SIZE	EXPLANATION / COMMENT
time_id	integer	Primary key.
time_acronym	char*31	Acronym or explication of the time scale.
time_name	char*250	Name or explication of the time scale.
time_descr	char*2000	Description or explication of the time scale.
num_points	integer*4	Number of points defining the time scale.
dim_type_id	integer	Foreign key to DIM_TYPE.
Table MOMENT E	TYPE*SIZE	EXPLANATION / COMMENT
moment_id	integer	Primary key.
moment_name	char*80	Name or explication of this moment (position on the time axis).
year	integer*8	Year of this moment.
month	integer*1	Month of this moment.
day	integer*1	Day of this moment.
hour	integer*1	Hour of this moment.
minute	integer*1	Minute of this moment.
second	integer*1	Second of this moment.
utc_difference	float*4	Difference of the scale to UTC in hours as UTC minus local hour, i.e. being west of Greenwich results in positive values of utc_difference.
Table DIM_TYPE L	TYPE*SIZE	EXPLANATION / COMMENT
dim_type_id	integer	Primary key.
dim_type_name	char*80	Type of the scale in this dimension.
basic set of values :	name	equidistant grid; irregular grid; single point(s); spectral.
Table POINT_CONNECT R	TYPE*SIZE	EXPLANATION / COMMENT
point_set_id	integer	Foreign key to POINT_SET.
point_id	integer	Foreign key to POINT.
moment_id	integer	Foreign key to MOMENT.
sequence_no	integer*4	Sequence number of a point within one point set.
Table SCALE_CONNECT R	TYPE*SIZE	EXPLANATION / COMMENT
scale_id	integer	Foreign key to SCALE.
position_id	integer	Foreign key to POSITION.
sequence_no	integer*4	Sequence number of a scale position in this dimension.
Table TIME_CONNECT R	TYPE*SIZE	EXPLANATION / COMMENT
time_id	integer	Foreign key to TIME.
moment_id	integer	Foreign key to MOMENT.
Submodule PATCHED_DIMENSION, Version 1.0	2 TABLES	-
Table SCALE_PATCHES	TYPE*SIZE	EXPLANATION / COMMENT
scale_id	integer	Foreign key to SCALE.
patch_id	integer	Foreign key to SCALE.
specifier	integer	Normally, the sequence number of the axis patch.
Table TIME_PATCHES	TYPE*SIZE	EXPLANATION / COMMENT
time_id	integer	Foreign key to TIME.
patch_id	integer	Foreign key to TIME.
specifier	integer	Normally, the sequence number of the axis patch.
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.

Go to top of document.

Pages are optimized for NETSCAPE. For comments and suggestions contact CERA Admin.

Last change: Tue Oct 2 15:38:44 NFT 2001