HOME UP

CERA SQL: Basic DDL

On this page you find the SQL for the Data Definition Language for all CERA-2.5 tables:
- GEN.sql: Generates all tables, using the other scripts as subroutines.
- GENcoreENTITIES.sql: Generates CERA Core-2.5 entities.
- GENcoreRELATIONS.sql: Generates CERA Core-2.5 relations.
- GENcoreVALUES.sql: Generates CERA Core-2.5 lists of values.
- GENmodDATA_ACCESS.sql: Generates CERA Module DATA_ACCESS 1.0.
- GENmodDATA_ORGANIZATION.sql: Generates CERA Module DATA_ORGANIZATION 1.3.
- GENmodMETADATA_STANDARD.sql: Generates CERA Module METADATA_STANDARD.
- GENmodMODEL_INPUT.sql: Generates CERA Module MODEL_INPUT.
- GENmodPROCESS_STEP.sql: Generates CERA Module PROCESS_STEP 1.0.
- GENsubmodPATCHED_DIMENSION.sql: Generates CERA Module PROCESS_STEP 1.0.
- TablePIKInstitute.sql: The PIK version of table INSTITUTE.
- TablePIKLocation.sql: The PIK version of table LOCATION.
- TablePIKPerson.sql: The PIK version of table PERSON.
- TablePIKTopic.sql: Generates table TOPIC in the DKRZ version.
- TablePIKTopicChange.sql: Adds changes for PIK for CERA compatibility.
- TablePIKlov.sql: The PIK version of most lists of values (LOVs).
- dropAll: Deletes all tables, sequences, and synonyms generated by GEN.sql.

Go to bottom of document

Mar 28 13:42 : GEN.sql ( 774 Bytes )

Mar 28 13:42 : GENcoreENTITIES.sql ( 8265 Bytes )

Jul 26 13:00 : GENcoreRELATIONS.sql ( 4632 Bytes )

Aug 02 10:08 : GENcoreVALUES.sql ( 65178 Bytes )

Mar 28 13:42 : GENmodDATA_ACCESS.sql ( 3611 Bytes )

Jul 26 11:48 : GENmodDATA_ORGANIZATION.sql ( 7593 Bytes )

Mar 28 13:42 : GENmodMETADATA_STANDARD.sql ( 470 Bytes )

Jul 26 10:27 : GENmodMODEL_INPUT.sql ( 2103 Bytes )

Mar 28 13:42 : GENmodPROCESS_STEP.sql ( 532 Bytes )

Jul 26 11:47 : GENsubmodPATCHED_DIMENSION.sql ( 992 Bytes )

Mar 28 13:42 : TablePIKInstitute.sql ( 30526 Bytes )