POSC Specifications Version 2.3 | Projection Tool |
This directory contains the oracle DDL for the meta data that the
Projection Tool uses when setting up the meta data tables.
The following files are contained in this directory:
File | Description |
---|---|
CreateCheck.sql | Contains DDL for check constraints for epicentre. Currently, this file only contains check constraints for the 'ENTITY_DEF_NM' column. This column contains the name of the entity that a particular row in a table is an instance of, in case a table can hold instances of multiple entities. The check constraints ensures that only valid entity names can be filled in for the particular table. |
CreateComment.sql | Creates comments on tables and columns. |
CreateFK.sql | Contains DDL that creates foreign key constraints where possible. |
CreateIndex.sql | Contains DDL that creates indices and uniqueness constraints. |
CreatePK.sql | Contains DDL that creates the primary key constraints constraints. |
CreateTable.sql | Creates the epicentre tables in the database. |
CreateView.sql | Creates useful views. |
DropCheck.sql | Drops all check constraints. |
DropFK.sql | Drops all foreign key constraints. |
DropIndex.sql | Drops all indices and uniqueness constraints. |
DropPK.sql | Drops all primary key constraints. |
DropTable.sql | Drops all epicentre tables. |
DropView.sql | Drops views. |
README | The ASCII version of this file. |
README.htm | The HTML version of this file. |