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.

© Copyright 1997-2001 POSC. All rights reserved.