/*
Created		7/20/2005
Modified		7/20/2005
Project		
Model		
Company		
Author		
Version		
Database		Oracle 9i 
*/





Create table "dbo"."E01" (
	"pk_E01_01" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"E01_01" Varchar2(30) NOT NULL ,
	"E01_02" Varchar2(30) NOT NULL ,
	"E01_03" Varchar2(30) NOT NULL ,
	"E01_04" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."E02" (
	"pk_E01_01" Integer NOT NULL ,
	"E02_01" Varchar2(15) NOT NULL ,
	"E02_02" Varchar2(15),
	"E02_03" Varchar2(15),
	"E02_04" Integer NOT NULL ,
	"E02_05" Integer NOT NULL ,
	"E02_11" Varchar2(30),
	"E02_12" Varchar2(15) NOT NULL ,
	"E02_13" Varchar2(30),
	"E02_14" Varchar2(30),
	"E02_15_Lat" Decimal(4,2),
	"E02_15_Long" Decimal(5,2),
	"E02_16" Decimal(6,1),
	"E02_17" Decimal(6,1),
	"E02_18" Decimal(6,1),
	"E02_19" Decimal(6,1),
	"E02_20" Integer NOT NULL ) 
/

Create table "dbo"."E02_06" (
	"pk_E02_06" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E02_06" Integer NOT NULL ) 
/

Create table "dbo"."E02_07" (
	"pk_E02_07" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E02_07" Integer NOT NULL ) 
/

Create table "dbo"."E02_08" (
	"pk_E02_08" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E02_08" Integer NOT NULL ) 
/

Create table "dbo"."E02_09" (
	"pk_E02_09" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E02_09" Integer NOT NULL ) 
/

Create table "dbo"."E02_10" (
	"pk_E02_10" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E02_10" Integer NOT NULL ) 
/

Create table "dbo"."E03" (
	"pk_E01_01" Integer NOT NULL ,
	"E03_01" Integer NOT NULL ,
	"E03_02" Integer NOT NULL ,
	"E03_03" Varchar2(10)) 
/

Create table "dbo"."E04" (
	"pk_E04" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E04_01" Varchar2(15),
	"E04_02" Varchar2(255),
	"E04_03" Varchar2(100)) 
/

Create table "dbo"."E05" (
	"pk_E01_01" Integer NOT NULL ,
	"E05_01" Date,
	"E05_02" Date,
	"E05_03" Date,
	"E05_04" Date NOT NULL ,
	"E05_05" Date,
	"E05_06" Date,
	"E05_07" Date,
	"E05_08" Date,
	"E05_09" Date,
	"E05_10" Date,
	"E05_11" Date NOT NULL ,
	"E05_12" Date,
	"E05_13" Date) 
/

Create table "dbo"."E06" (
	"pk_E01_01" Integer NOT NULL ,
	"E06_01" Varchar2(20),
	"E06_02" Varchar2(20),
	"E06_03" Varchar2(20),
	"E06_04" Varchar2(30),
	"E06_05" Varchar2(30),
	"E06_06" Varchar2(5),
	"E06_07" Varchar2(3),
	"E06_08" Varchar2(10) NOT NULL ,
	"E06_09" Varchar2(20),
	"E06_10" Varchar2(11),
	"E06_11" Integer NOT NULL ,
	"E06_12" Integer NOT NULL ,
	"E06_13" Integer NOT NULL ,
	"E06_14" Integer,
	"E06_15" Integer NOT NULL ,
	"E06_16" Date,
	"E06_17" Varchar2(10),
	"E06_18" Varchar2(3),
	"E06_19" Varchar2(30)) 
/

Create table "dbo"."E07" (
	"pk_E01_01" Integer NOT NULL ,
	"E07_01" Integer NOT NULL ,
	"E07_02" Integer,
	"E07_15" Integer,
	"E07_16" Integer,
	"E07_17" Integer,
	"E07_32" Varchar2(10),
	"E07_33" Integer,
	"E07_34" Integer NOT NULL ) 
/

Create table "dbo"."E07_03_0" (
	"pk_E07_03_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E07_03" Varchar2(30),
	"E07_04" Integer,
	"E07_05" Varchar2(30),
	"E07_06" Varchar2(30),
	"E07_07" Varchar2(3),
	"E07_08" Varchar2(10),
	"E07_09" Varchar2(30),
	"E07_10" Varchar2(30),
	"E07_11" Varchar2(20),
	"E07_12" Varchar2(20),
	"E07_13" Varchar2(20),
	"E07_14" Integer,
	"E07_18" Varchar2(20),
	"E07_19" Varchar2(20),
	"E07_20" Varchar2(20),
	"E07_21" Varchar2(30),
	"E07_22" Varchar2(30),
	"E07_23" Varchar2(3),
	"E07_24" Varchar2(10),
	"E07_25" Varchar2(10),
	"E07_26" Integer,
	"E07_27" Varchar2(30),
	"E07_28" Varchar2(30),
	"E07_29" Varchar2(30),
	"E07_30" Varchar2(3),
	"E07_31" Varchar2(10)) 
/

Create table "dbo"."E07_35_0" (
	"pk_E07_35_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E07_35" Varchar2(30) NOT NULL ,
	"E07_36" Varchar2(30)) 
/

Create table "dbo"."E07_37" (
	"pk_E07_37" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E07_37" Integer NOT NULL ) 
/

Create table "dbo"."E08" (
	"pk_E01_01" Integer NOT NULL ,
	"E08_03" Integer,
	"E08_04" Date,
	"E08_05" Integer NOT NULL ,
	"E08_06" Integer NOT NULL ,
	"E08_07" Integer NOT NULL ,
	"E08_08" Varchar2(30),
	"E08_09" Varchar2(30),
	"E08_10_Lat" Decimal(4,2),
	"E08_10_Long" Decimal(5,2),
	"E08_11" Varchar2(30),
	"E08_12" Varchar2(30),
	"E08_13" Varchar2(5),
	"E08_14" Varchar2(3),
	"E08_15" Varchar2(10) NOT NULL ) 
/

Create table "dbo"."E08_01" (
	"pk_E08_01" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E08_01" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."E08_02" (
	"pk_E08_02" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E08_02" Integer NOT NULL ) 
/

Create table "dbo"."E09" (
	"pk_E01_01" Integer NOT NULL ,
	"E09_03" Integer NOT NULL ,
	"E09_04" Integer NOT NULL ,
	"E09_05" Varchar2(50),
	"E09_06" Integer,
	"E09_07" Integer,
	"E09_08" Varchar2(50),
	"E09_09" Integer,
	"E09_10" Integer,
	"E09_11" Integer NOT NULL ,
	"E09_12" Integer NOT NULL ,
	"E09_13" Integer NOT NULL ,
	"E09_15" Integer NOT NULL ,
	"E09_16" Integer NOT NULL ) 
/

Create table "dbo"."E09_01" (
	"pk_E09_01" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E09_01" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."E09_02" (
	"pk_E09_02" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E09_02" Integer NOT NULL ) 
/

Create table "dbo"."E09_14" (
	"pk_E09_14" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E09_14" Integer NOT NULL ) 
/

Create table "dbo"."E10" (
	"pk_E01_01" Integer NOT NULL ,
	"E10_01" Integer NOT NULL ,
	"E10_02" Integer,
	"E10_06" Integer,
	"E10_07" Integer,
	"E10_10" Integer) 
/

Create table "dbo"."E10_03" (
	"pk_E10_03" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E10_03" Varchar2(255) NOT NULL ) 
/

Create table "dbo"."E10_04" (
	"pk_E10_04" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E10_04" Integer NOT NULL ) 
/

Create table "dbo"."E10_05" (
	"pk_E10_05" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E10_05" Integer NOT NULL ) 
/

Create table "dbo"."E10_08" (
	"pk_E10_08" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E10_08" Integer NOT NULL ) 
/

Create table "dbo"."E10_09" (
	"pk_E10_09" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E10_09" Integer NOT NULL ) 
/

Create table "dbo"."E11" (
	"pk_E01_01" Integer NOT NULL ,
	"E11_01" Integer NOT NULL ,
	"E11_02" Integer NOT NULL ,
	"E11_04" Integer,
	"E11_05" Integer,
	"E11_06" Integer,
	"E11_07" Integer,
	"E11_08" Integer,
	"E11_09" Date,
	"E11_10" Integer) 
/

Create table "dbo"."E11_03" (
	"pk_E11_03" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E11_03" Varchar2(255) NOT NULL ) 
/

Create table "dbo"."E11_11" (
	"pk_E11_11" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E11_11" Varchar2(255)) 
/

Create table "dbo"."E12" (
	"pk_E01_01" Integer NOT NULL ,
	"E12_02" Varchar2(30),
	"E12_03" Varchar2(30),
	"E12_04" Varchar2(20),
	"E12_05" Varchar2(20),
	"E12_06" Varchar2(20),
	"E12_11" Integer,
	"E12_18" Integer,
	"E12_20" Integer) 
/

Create table "dbo"."E12_01" (
	"pk_E12_01" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_01" Integer NOT NULL ) 
/

Create table "dbo"."E12_07" (
	"pk_E12_07" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_07" Integer NOT NULL ) 
/

Create table "dbo"."E12_08" (
	"pk_E12_08" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_08" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."E12_09" (
	"pk_E12_09" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_09" Integer NOT NULL ) 
/

Create table "dbo"."E12_10" (
	"pk_E12_10" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_10" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."E12_12_0" (
	"pk_E12_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_12" Integer NOT NULL ,
	"E12_13" Integer) 
/

Create table "dbo"."E12_14_0" (
	"pk_E12_14_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_14" Varchar2(30) NOT NULL ,
	"E12_15" Decimal(8,2),
	"E12_16" Integer,
	"E12_17" Integer) 
/

Create table "dbo"."E12_19" (
	"pk_E12_19" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E12_19" Integer NOT NULL ) 
/

Create table "dbo"."E13" (
	"pk_E01_01" Integer NOT NULL ,
	"E13_01" Varchar2(4000) NOT NULL ) 
/

Create table "dbo"."E14" (
	"pk_E14" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E14_01" Date,
	"E14_02" Integer,
	"E14_04" Integer,
	"E14_05" Integer,
	"E14_06" Integer,
	"E14_07" Integer,
	"E14_08" Integer,
	"E14_09" Integer,
	"E14_10" Integer,
	"E14_11" Integer,
	"E14_12" Integer,
	"E14_13" Integer,
	"E14_14" Integer,
	"E14_15" Integer,
	"E14_16" Integer,
	"E14_17" Integer,
	"E14_18" Integer,
	"E14_19" Integer,
	"E14_20" Decimal(4,2),
	"E14_21" Integer,
	"E14_22" Integer,
	"E14_23" Integer,
	"E14_24" Integer,
	"E14_25" Integer,
	"E14_26" Integer,
	"E14_27" Integer,
	"E14_28" Integer) 
/

Create table "dbo"."E14_03" (
	"pk_E14_03" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E14_03" Varchar2(255) NOT NULL ) 
/

Create table "dbo"."E15" (
	"pk_E15" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E15_DE" Char(6) NOT NULL ,
	"E15_DE_VALUE" Integer NOT NULL ) 
/

Create table "dbo"."E16" (
	"pk_E01_01" Integer NOT NULL ,
	"E16_01" Decimal(4,1),
	"E16_02" Integer) 
/

Create table "dbo"."E16_00_0" (
	"pk_E16_00_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E16_03" Date,
	"E16_DE" Char(6) NOT NULL ,
	"E16_DE_VALUE" Integer NOT NULL ) 
/

Create table "dbo"."E17" (
	"pk_E17" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E17_01" Varchar2(100) NOT NULL ) 
/

Create table "dbo"."E18" (
	"pk_E18" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E18_01" Date,
	"E18_02" Integer,
	"E18_03" Varchar2(30) NOT NULL ,
	"E18_04" Integer,
	"E18_05" Decimal(8,2),
	"E18_06" Integer,
	"E18_07" Integer,
	"E18_09" Varchar2(15),
	"E18_10" Integer,
	"E18_11" Varchar2(20)) 
/

Create table "dbo"."E18_08" (
	"pk_E18_08" Integer NOT NULL ,
	"fk_E18" Integer NOT NULL ,
	"E18_08" Integer NOT NULL ) 
/

Create table "dbo"."E19_01_0" (
	"pk_E19_01_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E19_01" Date,
	"E19_02" Integer,
	"E19_03" Varchar2(255) NOT NULL ,
	"E19_04" Varchar2(20),
	"E19_05" Varchar2(255) NOT NULL ,
	"E19_06" Integer NOT NULL ,
	"E19_08" Integer,
	"E19_09" Varchar2(15),
	"E19_10" Integer,
	"E19_11" Varchar2(20)) 
/

Create table "dbo"."E19_07" (
	"pk_E19_07" Integer NOT NULL ,
	"fk_E19_01_0" Integer NOT NULL ,
	"E19_07" Integer NOT NULL ) 
/

Create table "dbo"."E19_12" (
	"pk_E19_12" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E19_12" Integer) 
/

Create table "dbo"."E19_13" (
	"pk_E19_13" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E19_13" Integer) 
/

Create table "dbo"."E19_14" (
	"pk_E19_14" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E19_14" Integer) 
/

Create table "dbo"."E20" (
	"pk_E01_01" Integer NOT NULL ,
	"E20_01" Varchar2(50),
	"E20_02" Varchar2(50),
	"E20_03" Varchar2(30),
	"E20_04" Varchar2(30),
	"E20_05" Varchar2(3),
	"E20_06" Varchar2(5),
	"E20_07" Varchar2(10) NOT NULL ,
	"E20_08_Lat" Decimal(4,2),
	"E20_08_Long" Decimal(5,2),
	"E20_09" Varchar2(30),
	"E20_10" Integer NOT NULL ,
	"E20_11" Integer,
	"E20_12" Integer,
	"E20_13" Integer,
	"E20_14" Integer NOT NULL ,
	"E20_15" Integer,
	"E20_16" Integer NOT NULL ,
	"E20_17" Integer NOT NULL ) 
/

Create table "dbo"."E21" (
	"pk_E21_01" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E21_01" Date,
	"E21_02" Integer,
	"E21_03" Integer,
	"E21_04" Long,
	"E21_05" Integer,
	"E21_06" Integer,
	"E21_07" Varchar2(2000),
	"E21_08" Integer,
	"E21_09" Decimal(5,1),
	"E21_10" Integer,
	"E21_11" Integer,
	"E21_12" Integer,
	"E21_13" Integer,
	"E21_14" Integer,
	"E21_15" Integer,
	"E21_16" Integer,
	"E21_17" Integer,
	"E21_18" Integer,
	"E21_19" Integer,
	"E21_20" Integer) 
/

Create table "dbo"."E22" (
	"pk_E01_01" Integer NOT NULL ,
	"E22_01" Integer NOT NULL ,
	"E22_02" Integer NOT NULL ,
	"E22_03" Varchar2(20),
	"E22_04" Varchar2(20),
	"E22_05" Varchar2(20),
	"E22_06" Varchar2(20)) 
/

Create table "dbo"."E23" (
	"pk_E01_01" Integer NOT NULL ,
	"E23_01" Integer,
	"E23_05" Integer,
	"E23_08" Integer,
	"E23_10" Varchar2(15)) 
/

Create table "dbo"."E23_02" (
	"pk_E23_02" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_02" Integer NOT NULL ) 
/

Create table "dbo"."E23_03" (
	"pk_E23_03" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_03" Integer NOT NULL ) 
/

Create table "dbo"."E23_04" (
	"pk_E23_04" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_04" Integer NOT NULL ) 
/

Create table "dbo"."E23_06" (
	"pk_E23_06" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_06" Integer NOT NULL ) 
/

Create table "dbo"."E23_07" (
	"pk_E23_07" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_07" Integer NOT NULL ) 
/

Create table "dbo"."E23_09_0" (
	"pk_E23_09_0" Integer NOT NULL ,
	"fk_E01_01" Integer NOT NULL ,
	"E23_09" Varchar2(50) NOT NULL ,
	"E23_11" Varchar2(30) NOT NULL ) 
/

Create table "dbo"."Header" (
	"pk_D01" Integer NOT NULL ,
	"D01_01" Varchar2(15) NOT NULL ,
	"D01_03" Varchar2(3) NOT NULL ,
	"D01_04" Varchar2(5) NOT NULL ,
	"D01_07" Varchar2(100) NOT NULL ,
	"D01_08" Integer NOT NULL ,
	"D01_09" Integer NOT NULL ,
	"D01_21" Varchar2(10) NOT NULL ,
	"D02_07" Varchar2(255) NOT NULL ) 
/



Alter table "dbo"."E01" add Constraint "PK_E01" primary key ("pk_E01_01") 
/
Alter table "dbo"."E02" add Constraint "PK_E02" primary key ("pk_E01_01") 
/
Alter table "dbo"."E02_06" add Constraint "PK_E02_06" primary key ("pk_E02_06") 
/
Alter table "dbo"."E02_07" add Constraint "PK_E02_07" primary key ("pk_E02_07") 
/
Alter table "dbo"."E02_08" add Constraint "PK_E02_08" primary key ("pk_E02_08") 
/
Alter table "dbo"."E02_09" add Constraint "PK_E02_09" primary key ("pk_E02_09") 
/
Alter table "dbo"."E02_10" add Constraint "PK_E02_10" primary key ("pk_E02_10") 
/
Alter table "dbo"."E03" add Constraint "PK_E03" primary key ("pk_E01_01") 
/
Alter table "dbo"."E04" add Constraint "PK_E04" primary key ("pk_E04") 
/
Alter table "dbo"."E05" add Constraint "PK_E05" primary key ("pk_E01_01") 
/
Alter table "dbo"."E06" add Constraint "PK_E06" primary key ("pk_E01_01") 
/
Alter table "dbo"."E07" add Constraint "PK_E07" primary key ("pk_E01_01") 
/
Alter table "dbo"."E07_03_0" add Constraint "PK_E07_03_0" primary key ("pk_E07_03_0") 
/
Alter table "dbo"."E07_35_0" add Constraint "PK_E07_35_0" primary key ("pk_E07_35_0") 
/
Alter table "dbo"."E07_37" add Constraint "PK_E07_37" primary key ("pk_E07_37") 
/
Alter table "dbo"."E08" add Constraint "PK_E08" primary key ("pk_E01_01") 
/
Alter table "dbo"."E08_01" add Constraint "PK_E08_01" primary key ("pk_E08_01") 
/
Alter table "dbo"."E08_02" add Constraint "PK_E08_02" primary key ("pk_E08_02") 
/
Alter table "dbo"."E09" add Constraint "PK_E09" primary key ("pk_E01_01") 
/
Alter table "dbo"."E09_01" add Constraint "PK_E09_01" primary key ("pk_E09_01") 
/
Alter table "dbo"."E09_02" add Constraint "PK_E09_02" primary key ("pk_E09_02") 
/
Alter table "dbo"."E09_14" add Constraint "PK_E09_14" primary key ("pk_E09_14") 
/
Alter table "dbo"."E10" add Constraint "PK_E10" primary key ("pk_E01_01") 
/
Alter table "dbo"."E10_03" add Constraint "PK_E10_03" primary key ("pk_E10_03") 
/
Alter table "dbo"."E10_04" add Constraint "PK_E10_04" primary key ("pk_E10_04") 
/
Alter table "dbo"."E10_05" add Constraint "PK_E10_05" primary key ("pk_E10_05") 
/
Alter table "dbo"."E10_08" add Constraint "PK_E10_08" primary key ("pk_E10_08") 
/
Alter table "dbo"."E10_09" add Constraint "PK_E10_09" primary key ("pk_E10_09") 
/
Alter table "dbo"."E11" add Constraint "PK_E11" primary key ("pk_E01_01") 
/
Alter table "dbo"."E11_03" add Constraint "PK_E11_03" primary key ("pk_E11_03") 
/
Alter table "dbo"."E11_11" add Constraint "PK_E11_11" primary key ("pk_E11_11") 
/
Alter table "dbo"."E12" add Constraint "PK_E12" primary key ("pk_E01_01") 
/
Alter table "dbo"."E12_01" add Constraint "PK_E12_01" primary key ("pk_E12_01") 
/
Alter table "dbo"."E12_07" add Constraint "PK_E12_07" primary key ("pk_E12_07") 
/
Alter table "dbo"."E12_08" add Constraint "PK_E12_08" primary key ("pk_E12_08") 
/
Alter table "dbo"."E12_09" add Constraint "PK_E12_09" primary key ("pk_E12_09") 
/
Alter table "dbo"."E12_10" add Constraint "PK_E12_10" primary key ("pk_E12_10") 
/
Alter table "dbo"."E12_12_0" add Constraint "PK_E12_12_0" primary key ("pk_E12_0") 
/
Alter table "dbo"."E12_14_0" add Constraint "PK_E12_14_0" primary key ("pk_E12_14_0") 
/
Alter table "dbo"."E12_19" add Constraint "PK_E12_19" primary key ("pk_E12_19") 
/
Alter table "dbo"."E13" add Constraint "PK_E13" primary key ("pk_E01_01") 
/
Alter table "dbo"."E14" add Constraint "PK_E14" primary key ("pk_E14") 
/
Alter table "dbo"."E14_03" add Constraint "PK_E14_03" primary key ("pk_E14_03") 
/
Alter table "dbo"."E15" add Constraint "PK_E15" primary key ("pk_E15") 
/
Alter table "dbo"."E16" add Constraint "PK_E16" primary key ("pk_E01_01") 
/
Alter table "dbo"."E16_00_0" add Constraint "PK_E16_00_0" primary key ("pk_E16_00_0") 
/
Alter table "dbo"."E17" add Constraint "PK_E17" primary key ("pk_E17") 
/
Alter table "dbo"."E18" add Constraint "PK_E18" primary key ("pk_E18") 
/
Alter table "dbo"."E18_08" add Constraint "PK_E18_08" primary key ("pk_E18_08") 
/
Alter table "dbo"."E19_01_0" add Constraint "PK_E19_01_0" primary key ("pk_E19_01_0") 
/
Alter table "dbo"."E19_07" add Constraint "PK_E19_07" primary key ("pk_E19_07") 
/
Alter table "dbo"."E19_12" add Constraint "PK_E19_12" primary key ("pk_E19_12") 
/
Alter table "dbo"."E19_13" add Constraint "PK_E19_13" primary key ("pk_E19_13") 
/
Alter table "dbo"."E19_14" add Constraint "PK_E19_14" primary key ("pk_E19_14") 
/
Alter table "dbo"."E20" add Constraint "PK_E20" primary key ("pk_E01_01") 
/
Alter table "dbo"."E21" add Constraint "PK_E21" primary key ("pk_E21_01") 
/
Alter table "dbo"."E22" add Constraint "PK_E22" primary key ("pk_E01_01") 
/
Alter table "dbo"."E23" add Constraint "PK_E23" primary key ("pk_E01_01") 
/
Alter table "dbo"."E23_02" add Constraint "PK_E23_02" primary key ("pk_E23_02") 
/
Alter table "dbo"."E23_03" add Constraint "PK_E23_03" primary key ("pk_E23_03") 
/
Alter table "dbo"."E23_04" add Constraint "PK_E23_04" primary key ("pk_E23_04") 
/
Alter table "dbo"."E23_06" add Constraint "PK_E23_06" primary key ("pk_E23_06") 
/
Alter table "dbo"."E23_07" add Constraint "PK_E23_07" primary key ("pk_E23_07") 
/
Alter table "dbo"."E23_09_0" add Constraint "PK_E23_09_0" primary key ("pk_E23_09_0") 
/
Alter table "dbo"."Header" add Constraint "PK_Header" primary key ("pk_D01") 
/





Alter table "dbo"."E02" add Constraint "FK_E02_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E02_06" add Constraint "FK_E02_06_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E02_07" add Constraint "FK_E02_07_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E02_08" add Constraint "FK_E02_08_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E02_09" add Constraint "FK_E02_09_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E02_10" add Constraint "FK_E02_10_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E03" add Constraint "FK_E03_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E04" add Constraint "FK_E04_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E05" add Constraint "FK_E05_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E06" add Constraint "FK_E06_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E07" add Constraint "FK_E07_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E07_03_0" add Constraint "FK_E07_03_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E07_35_0" add Constraint "FK_E07_35_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E07_37" add Constraint "FK_E07_37_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E08" add Constraint "FK_E08_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E08_01" add Constraint "FK_E08_01_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E08_02" add Constraint "FK_E08_02_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E09" add Constraint "FK_E09_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E09_01" add Constraint "FK_E09_01_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E09_02" add Constraint "FK_E09_02_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E09_14" add Constraint "FK_E09_14_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10" add Constraint "FK_E10_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10_03" add Constraint "FK_E10_03_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10_04" add Constraint "FK_E10_04_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10_05" add Constraint "FK_E10_05_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10_08" add Constraint "FK_E10_08_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E10_09" add Constraint "FK_E10_09_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E11" add Constraint "FK_E11_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E11_03" add Constraint "FK_E11_03_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E11_11" add Constraint "FK_E11_11_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12" add Constraint "FK_E12_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_01" add Constraint "FK_E12_01_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_07" add Constraint "FK_E12_07_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_08" add Constraint "FK_E12_08_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_09" add Constraint "FK_E12_09_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_10" add Constraint "FK_E12_10_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_12_0" add Constraint "FK_E12_12_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_14_0" add Constraint "FK_E12_14_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E12_19" add Constraint "FK_E12_19_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E13" add Constraint "FK_E13_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E14" add Constraint "FK_E14_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E14_03" add Constraint "FK_E14_03_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E15" add Constraint "FK_E15_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E16" add Constraint "FK_E16_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E16_00_0" add Constraint "FK_E16_00_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E17" add Constraint "FK_E17_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E18" add Constraint "FK_E18_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E19_01_0" add Constraint "FK_E19_01_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E19_12" add Constraint "FK_E19_12_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E19_13" add Constraint "FK_E19_13_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E19_14" add Constraint "FK_E19_14_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E20" add Constraint "FK_E20_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E21" add Constraint "FK_E21_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E22" add Constraint "FK_E22_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23" add Constraint "FK_E23_E01" foreign key ("pk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_02" add Constraint "FK_E23_02_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_03" add Constraint "FK_E23_03_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_04" add Constraint "FK_E23_04_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_06" add Constraint "FK_E23_06_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_07" add Constraint "FK_E23_07_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E23_09_0" add Constraint "FK_E23_09_0_E01" foreign key ("fk_E01_01") references "dbo"."E01" ("pk_E01_01") 
/

Alter table "dbo"."E18_08" add Constraint "FK_E18_08_E18" foreign key ("fk_E18") references "dbo"."E18" ("pk_E18") 
/

Alter table "dbo"."E19_07" add Constraint "FK_E19_07_E19_01_0" foreign key ("fk_E19_01_0") references "dbo"."E19_01_0" ("pk_E19_01_0") 
/

Alter table "dbo"."E01" add Constraint "FK_E01_Header" foreign key ("fk_D01") references "dbo"."Header" ("pk_D01") 
/