-- File     Test.txt                     
-- Document Table Key • Unit Article Task    
-- Layer    Base                        1

-----------
-- Table --
-----------

-- Area --
CREATE TABLE Area (
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- AreaJob --
CREATE TABLE AreaJob (
    -- Collection of Tasks for the Area
    -- The Tasks are projected.
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- AreaJobOccurrence --
CREATE TABLE AreaJobOccurrence (
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL,  --
    DateTime       DateTime      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- AreaType --
CREATE TABLE AreaType (
    AreaTypeCode   AreaTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- Article --
CREATE TABLE Article (
    SiteCode           SiteCode          NOT NULL,  --
    AreaTypeCode       AreaTypeCode      NOT NULL,  --
    AreaCode           AreaCode          NOT NULL,  --
    ArticleTypeCode    ArticleTypeCode   NOT NULL,  --
    ArticleGroupCode   ArticleGroupCode  NOT NULL,  --
    [Quantity]         [Quantity]        NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- ArticleTask --
CREATE TABLE ArticleTask (
    -- Article Task:
    -- -  either ArticleTypeTaskRecur disabled
    -- -  or Task specific to the Article 
    -- (which may be a replacement for 
    -- disabled ArticleTypeTaskRecur)
    SiteCode             SiteCode            NOT NULL,  --
    AreaTypeCode         AreaTypeCode        NOT NULL,  --
    AreaCode             AreaCode            NOT NULL,  --
    ArticleTypeCode      ArticleTypeCode     NOT NULL,  --
    ArticleGroupCode     ArticleGroupCode    NOT NULL,  --
    Task                 Task                NOT NULL,  --
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL,  --
    StartTime            StartTime           NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- ArticleTaskOccurrence --
CREATE TABLE ArticleTaskOccurrence (
    AreaTypeCode       AreaTypeCode      NOT NULL,  --
    AreaCode           AreaCode          NOT NULL,  --
    ArticleTypeCode    ArticleTypeCode   NOT NULL,  --
    ArticleGroupCode   ArticleGroupCode  NOT NULL,  --
    Task               Task              NOT NULL,  --
    StartTime          StartTime         NOT NULL,  --
    DateTime           DateTime          NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- ArticleTask_Specific --
   -- No columns

-- ArticleTask_TypeDisabled --
   -- No columns

-- ArticleType --
CREATE TABLE ArticleType (
    ArticleTypeCode   ArticleTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- ArticleTypeTask --
CREATE TABLE ArticleTypeTask (
    -- Set of Tasks for all Articles of this ArticleType.
    -- Not exclusive.
    ArticleTypeCode   ArticleTypeCode  NOT NULL,  --
    Task              Task             NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- ArticleTypeTaskRecur --
CREATE TABLE ArticleTypeTaskRecur (
    ArticleTypeCode      ArticleTypeCode     NOT NULL,  --
    Task                 Task                NOT NULL,  --
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL,  --
    StartTime            StartTime           NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- RecurrenceType --
CREATE TABLE RecurrenceType (
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- Sensor --
CREATE TABLE Sensor (
    -- SensorNo is independent  of UniType{Analog|Switch
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL,  --
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    UnitCode       UnitCode      NOT NULL,  --
    SensorNo       SensorNo      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SensorAnalog --
    -- Lower
    -- Middle
    -- Upper
   -- No columns

-- SensorAnalogDisplayType --
CREATE TABLE SensorAnalogDisplayType (
    SensorAnalogDisplayTypeCode   SensorAnalogDisplayTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SensorAnalogUsageType --
CREATE TABLE SensorAnalogUsageType (
    SensorAnalogUsageTypeCode   SensorAnalogUsageTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SensorSwitch --
   -- No columns

-- SensorSwitchDisplayType --
CREATE TABLE SensorSwitchDisplayType (
    SensorSwitchDisplayTypeCode   SensorSwitchDisplayTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SensorSwitchType --
CREATE TABLE SensorSwitchType (
    SensorSwitchTypeCode   SensorSwitchTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SensorType --
CREATE TABLE SensorType (
    SensorTypeCode   SensorTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- Site --
CREATE TABLE Site (
    SiteCode   SiteCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- SiteType --
CREATE TABLE SiteType (
    SiteTypeCode   SiteTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- Task --
CREATE TABLE Task (
    Task   Task  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- TaskRecurDaily --
   -- No columns

-- TaskRecurMonthly --
   -- No columns

-- TaskRecurWeekDaily --
   -- No columns

-- TaskRecurWeekly --
   -- No columns

-- TaskRecurrence --
CREATE TABLE TaskRecurrence (
    Task                 Task                NOT NULL,  --
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL,  --
    StartTime            StartTime           NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- Unit --
CREATE TABLE Unit (
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL,  --
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    UnitCode       UnitCode      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitGroup --
CREATE TABLE UnitGroup (
    UnitGroupCode   UnitGroupCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitMember --
CREATE TABLE UnitMember (
    UnitGroupCode   UnitGroupCode  NOT NULL,  --
    SiteCode        SiteCode       NOT NULL,  --
    AreaTypeCode    AreaTypeCode   NOT NULL,  --
    AreaCode        AreaCode       NOT NULL,  --
    UnitTypeCode    UnitTypeCode   NOT NULL,  --
    UnitCode        UnitCode       NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTask --
CREATE TABLE UnitTask (
    -- Unit Task:
    -- -  either UnitTypeTaskRecur disabled
    -- -  or Task specific to the Unit 
    -- (which may be a replacement for 
    -- disabled UnitTypeTaskRecur)
    SiteCode             SiteCode            NOT NULL,  --
    AreaTypeCode         AreaTypeCode        NOT NULL,  --
    AreaCode             AreaCode            NOT NULL,  --
    UnitTypeCode         UnitTypeCode        NOT NULL,  --
    UnitCode             UnitCode            NOT NULL,  --
    Task                 Task                NOT NULL,  --
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL,  --
    StartTime            StartTime           NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTaskOccurrence --
CREATE TABLE UnitTaskOccurrence (
    SiteCode       SiteCode      NOT NULL,  --
    AreaTypeCode   AreaTypeCode  NOT NULL,  --
    AreaCode       AreaCode      NOT NULL,  --
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    UnitCode       UnitCode      NOT NULL,  --
    Task           Task          NOT NULL,  --
    StartTime      StartTime     NOT NULL,  --
    DateTime       DateTime      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTask_Specific --
   -- No columns

-- UnitTask_TypeDisabled --
   -- No columns

-- UnitType --
CREATE TABLE UnitType (
    UnitTypeCode   UnitTypeCode  NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTypeAnalog --
CREATE TABLE UnitTypeAnalog (
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    SensorNo       SensorNo      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTypeSwitch --
CREATE TABLE UnitTypeSwitch (
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    SensorNo       SensorNo      NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTypeTask --
CREATE TABLE UnitTypeTask (
    UnitTypeCode   UnitTypeCode  NOT NULL,  --
    Task           Task          NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-- UnitTypeTaskRecur --
CREATE TABLE UnitTypeTaskRecur (
    -- Set of Tasks for all Units of this UnitType.  May be Disabled.
    UnitTypeCode         UnitTypeCode        NOT NULL,  --
    Task                 Task                NOT NULL,  --
    RecurrenceTypeCode   RecurrenceTypeCode  NOT NULL,  --
    StartTime            StartTime           NOT NULL   --
    )
    LOCK ALLPAGES
    ON data_seg
GO

-----------
-- Index --
-----------

-- Area --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Area(
        SiteCode
        AreaTypeCode
        AreaCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Area(
        Name
        )
    ON NCI_seg
GO

-- AreaJob --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON AreaJob(
        SiteCode
        AreaTypeCode
        AreaCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON AreaJob(
        Name
        )
    ON NCI_seg
GO

-- AreaJobOccurrence --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON AreaJobOccurrence(
        SiteCode
        AreaTypeCode
        AreaCode
        DateTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON AreaJobOccurrence(
        Name
        )
    ON NCI_seg
GO

-- AreaType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON AreaType(
        AreaTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON AreaType(
        Name
        )
    ON NCI_seg
GO

-- Article --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Article(
        SiteCode
        AreaTypeCode
        AreaCode
        ArticleTypeCode
        ArticleGroupCode
        [Quantity]
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Article(
        Name
        )
    ON NCI_seg
GO

-- ArticleTask --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON ArticleTask(
        SiteCode
        AreaTypeCode
        AreaCode
        ArticleTypeCode
        ArticleGroupCode
        Task
        RecurrenceTypeCode
        StartTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON ArticleTask(
        Name
        )
    ON NCI_seg
GO

-- ArticleTaskOccurrence --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON ArticleTaskOccurrence(
        AreaTypeCode
        AreaCode
        ArticleTypeCode
        ArticleGroupCode
        Task
        StartTime
        DateTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON ArticleTaskOccurrence(
        Name
        )
    ON NCI_seg
GO

-- ArticleTask_Specific --
   -- No columns

-- ArticleTask_TypeDisabled --
   -- No columns

-- ArticleType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON ArticleType(
        ArticleTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON ArticleType(
        Name
        )
    ON NCI_seg
GO

-- ArticleTypeTask --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON ArticleTypeTask(
        ArticleTypeCode
        Task
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON ArticleTypeTask(
        Name
        )
    ON NCI_seg
GO

-- ArticleTypeTaskRecur --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON ArticleTypeTaskRecur(
        ArticleTypeCode
        Task
        RecurrenceTypeCode
        StartTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON ArticleTypeTaskRecur(
        Name
        )
    ON NCI_seg
GO

-- RecurrenceType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON RecurrenceType(
        RecurrenceTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON RecurrenceType(
        Name
        )
    ON NCI_seg
GO

-- Sensor --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Sensor(
        SiteCode
        AreaTypeCode
        AreaCode
        UnitTypeCode
        UnitCode
        SensorNo
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Sensor(
        Name
        )
    ON NCI_seg
GO

-- SensorAnalog --
   -- No columns

-- SensorAnalogDisplayType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SensorAnalogDisplayType(
        SensorAnalogDisplayTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SensorAnalogDisplayType(
        Name
        )
    ON NCI_seg
GO

-- SensorAnalogUsageType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SensorAnalogUsageType(
        SensorAnalogUsageTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SensorAnalogUsageType(
        Name
        )
    ON NCI_seg
GO

-- SensorSwitch --
   -- No columns

-- SensorSwitchDisplayType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SensorSwitchDisplayType(
        SensorSwitchDisplayTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SensorSwitchDisplayType(
        Name
        )
    ON NCI_seg
GO

-- SensorSwitchType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SensorSwitchType(
        SensorSwitchTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SensorSwitchType(
        Name
        )
    ON NCI_seg
GO

-- SensorType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SensorType(
        SensorTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SensorType(
        Name
        )
    ON NCI_seg
GO

-- Site --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Site(
        SiteCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Site(
        Name
        )
    ON NCI_seg
GO

-- SiteType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON SiteType(
        SiteTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON SiteType(
        Name
        )
    ON NCI_seg
GO

-- Task --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Task(
        Task
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Task(
        Name
        )
    ON NCI_seg
GO

-- TaskRecurDaily --
   -- No columns

-- TaskRecurMonthly --
   -- No columns

-- TaskRecurWeekDaily --
   -- No columns

-- TaskRecurWeekly --
   -- No columns

-- TaskRecurrence --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON TaskRecurrence(
        Task
        RecurrenceTypeCode
        StartTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON TaskRecurrence(
        Name
        )
    ON NCI_seg
GO

-- Unit --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON Unit(
        SiteCode
        AreaTypeCode
        AreaCode
        UnitTypeCode
        UnitCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON Unit(
        Name
        )
    ON NCI_seg
GO

-- UnitGroup --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitGroup(
        UnitGroupCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitGroup(
        Name
        )
    ON NCI_seg
GO

-- UnitMember --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitMember(
        UnitGroupCode
        SiteCode
        AreaTypeCode
        AreaCode
        UnitTypeCode
        UnitCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitMember(
        Name
        )
    ON NCI_seg
GO

-- UnitTask --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTask(
        SiteCode
        AreaTypeCode
        AreaCode
        UnitTypeCode
        UnitCode
        Task
        RecurrenceTypeCode
        StartTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTask(
        Name
        )
    ON NCI_seg
GO

-- UnitTaskOccurrence --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTaskOccurrence(
        SiteCode
        AreaTypeCode
        AreaCode
        UnitTypeCode
        UnitCode
        Task
        StartTime
        DateTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTaskOccurrence(
        Name
        )
    ON NCI_seg
GO

-- UnitTask_Specific --
   -- No columns

-- UnitTask_TypeDisabled --
   -- No columns

-- UnitType --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitType(
        UnitTypeCode
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitType(
        Name
        )
    ON NCI_seg
GO

-- UnitTypeAnalog --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTypeAnalog(
        UnitTypeCode
        SensorNo
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTypeAnalog(
        Name
        )
    ON NCI_seg
GO

-- UnitTypeSwitch --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTypeSwitch(
        UnitTypeCode
        SensorNo
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTypeSwitch(
        Name
        )
    ON NCI_seg
GO

-- UnitTypeTask --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTypeTask(
        UnitTypeCode
        Task
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTypeTask(
        Name
        )
    ON NCI_seg
GO

-- UnitTypeTaskRecur --
CREATE UNIQUE CLUSTERED INDEX UC_PK
    ON UnitTypeTaskRecur(
        UnitTypeCode
        Task
        RecurrenceTypeCode
        StartTime
        )
    ON data_seg
CREATE UNIQUE NONCLUSTERED INDEX U__A
    ON UnitTypeTaskRecur(
        Name
        )
    ON NCI_seg
GO

-----------------
-- Foreign Key --
-----------------

ALTER TABLE CHILD
    ADD CONSTRAINT Belongs_To
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Classifies
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Classifies
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Classifies
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Classifies
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Comprises
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Contains
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Describes
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Describes
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Describes
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Describes
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Discriminates
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Does
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Does
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Expands
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Expands_As
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Has
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Divided_Into
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Executed_On
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Executed_On
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Executed_On
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Executed_On
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Is_Monitored_With
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Recurs_As
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Recurs_As
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Requires
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Requires
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Requires
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Requires
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO

ALTER TABLE CHILD
    ADD CONSTRAINT Schedules
    FOREIGN KEY      ( CHILD_KEY )
    REFERENCES PARENT( PARENT_KEY )
GO