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


Alter table "D01_03" drop constraint "FK_D01_03_D01"
/
Alter table "D01_04" drop constraint "FK_D01_04_D01"
/
Alter table "D01_06" drop constraint "FK_D01_06_D01"
/
Alter table "D01_10" drop constraint "FK_D01_10_D01"
/
Alter table "D01_11" drop constraint "FK_D01_11_D01"
/
Alter table "D02" drop constraint "FK_D02_D01"
/
Alter table "D03" drop constraint "FK_D03_D01"
/
Alter table "D04_01" drop constraint "FK_D04_01_D01"
/
Alter table "D04_02" drop constraint "FK_D04_02_D01"
/
Alter table "D04_03" drop constraint "FK_D04_03_D01"
/
Alter table "D04_04" drop constraint "FK_D04_04_D01"
/
Alter table "D04_06" drop constraint "FK_D04_06_D01"
/
Alter table "D04_08" drop constraint "FK_D04_08_D01"
/
Alter table "D04_10" drop constraint "FK_D04_10_D01"
/
Alter table "D04_11" drop constraint "FK_D04_11_D01"
/
Alter table "D04_13" drop constraint "FK_D04_13_D01"
/
Alter table "D04_16" drop constraint "FK_D04_16_D01"
/
Alter table "D04_17" drop constraint "FK_D04_17_D01"
/
Alter table "D05" drop constraint "FK_D05_D01"
/
Alter table "D06" drop constraint "FK_D06_D01"
/
Alter table "D07" drop constraint "FK_D07_D01"
/
Alter table "D09" drop constraint "FK_D09_D01"
/
Alter table "D04_04" drop constraint "FK_D04_04_D04_01"
/
Alter table "D04_06" drop constraint "FK_D04_06_D04_01"
/
Alter table "D04_08" drop constraint "FK_D04_08_D04_01"
/
Alter table "D06_04" drop constraint "FK_D06_04_D04_01"
/
Alter table "D07_05" drop constraint "FK_D07_05_D04_01"
/
Alter table "D06_08" drop constraint "FK_D06_08_D06_01"
/
Alter table "D07_05" drop constraint "FK_D07_05_D07_01"
/
Alter table "D08" drop constraint "FK_D08_D07_01"
/



Drop table "D09"
/
Drop table "D08"
/
Drop table "D07_05"
/
Drop table "D07"
/
Drop table "D06_08"
/
Drop table "D06_04"
/
Drop table "D06"
/
Drop table "D05"
/
Drop table "D04_17"
/
Drop table "D04_16"
/
Drop table "D04_13"
/
Drop table "D04_11"
/
Drop table "D04_10"
/
Drop table "D04_08"
/
Drop table "D04_06"
/
Drop table "D04_04"
/
Drop table "D04_03"
/
Drop table "D04_02"
/
Drop table "D04_01"
/
Drop table "D03"
/
Drop table "D02"
/
Drop table "D01_11"
/
Drop table "D01_10"
/
Drop table "D01_06"
/
Drop table "D01_04"
/
Drop table "D01_03"
/
Drop table "D01"
/














Create table "D01" (
	"pk_D01" Integer NOT NULL ,
	"D01_01" Char(15) NOT NULL ,
	"D01_02" Char(50) NOT NULL ,
	"D01_05" Integer,
	"D01_07" Char(30) NOT NULL ,
	"D01_08" Integer NOT NULL ,
	"D01_09" Integer NOT NULL ,
	"D01_19" Integer,
	"D01_20" Integer,
	"D01_21" Char(10) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D01_03" (
	"pk_D01_03" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D01_03" Char(2) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D01_04" (
	"pk_D01_04" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D01_04" Char(5) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D01_06" (
	"pk_D01_06" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D01_06" Integer NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D01_10" (
	"pk_D01_10" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D01_10" Integer NOT NULL ,
	"D01_12" Integer NOT NULL ,
	"D01_13" Integer NOT NULL ,
	"D01_14" Integer NOT NULL ,
	"D01_15" Integer NOT NULL ,
	"D01_16" Integer NOT NULL ,
	"D01_17" Integer NOT NULL ,
	"D01_18" Integer) 
/

Create table "D01_11" (
	"pk_D01_11" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D01_11" Char(50) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D02" (
	"pk_D02" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D02_01" Char(20) NOT NULL ,
	"D02_02" Char(20),
	"D02_03" Char(20) NOT NULL ,
	"D02_04" Char(30),
	"D02_05" Char(30),
	"D02_06" Char(3),
	"D02_07" Char(10) NOT NULL ,
	"D02_08" Char(10),
	"D02_09" Char(10),
	"D02_10" Char(100),
	"D02_11" Char(100),
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D03" (
	"pk_D03" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D03_01" Char(20) NOT NULL ,
	"D03_02" Char(20),
	"D03_03" Char(20) NOT NULL ,
	"D03_04" Char(30),
	"D03_05" Char(30),
	"D03_06" Char(3),
	"D03_07" Char(10),
	"D03_08" Char(10),
	"D03_09" Char(10),
	"D03_10" Integer,
	"D03_11" Char(100),
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_01" (
	"pk_D04_01" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_01" Char(30) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_02" (
	"pk_D04_02" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_02" Char(30) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_03" (
	"pk_D04_03" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_03" Char(30) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_04" (
	"pk_D04_04" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_04" Char(30) NOT NULL ,
	"fk_D04_01" Integer,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_06" (
	"pk_D04_06" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_06" Char(30) NOT NULL ,
	"fk_D04_01" Integer,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_08" (
	"pk_D04_08" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_08" Char(30) NOT NULL ,
	"fk_D04_01" Integer,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_10" (
	"pk_D04_10" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_10" Char(30) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_11" (
	"pk_D04_11" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_11" Char(50) NOT NULL ,
	"D04_12" Char(30) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_13" (
	"pk_D04_13" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_13" Char(50) NOT NULL ,
	"D04_14" Char(30) NOT NULL ,
	"D04_15" Integer NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_16" (
	"pk_D04_16" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_16" Char(100) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D04_17" (
	"pk_D04_17" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D04_17" Char(50) NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D05" (
	"pk_D05" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D05_01" Char(50) NOT NULL ,
	"D05_02" Char(50) NOT NULL ,
	"D05_03" Char(30),
	"Lat" Char(10),
	"Long" Char(10),
	"D05_05" Char(30),
	"D05_06" Char(30),
	"D05_07" Char(3) NOT NULL ,
	"D05_08" Char(10),
	"D05_09" Char(10),
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D06" (
	"pk_D06_01" Char(50) NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D06_03" Integer NOT NULL ,
	"D06_06" Float,
	"D06_07" Integer,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D06_04" (
	"pk_D06_04" Integer NOT NULL ,
	"fk_D06_01" Char(50) NOT NULL ,
	"fk_D04_01" Integer NOT NULL ,
	"D06_05" Integer NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D06_08" (
	"pk_D06_08" Integer NOT NULL ,
	"fk_D06_01" Char(50) NOT NULL ,
	"D06_08" Integer NOT NULL ,
	"D06_09" Integer NOT NULL ,
	"D06_10" Integer NOT NULL ,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D07" (
	"pk_D07_01" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D07_02" Integer NOT NULL ,
	"D07_03" Integer NOT NULL ,
	"D07_04" Date,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D07_05" (
	"pk_D07_05" Integer NOT NULL ,
	"fk_D07_01" Integer NOT NULL ,
	"fk_D04_01" Integer NOT NULL ,
	"D07_06" Date,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D08" (
	"pk_D08" Integer NOT NULL ,
	"fk_D07_01" Integer NOT NULL ,
	"D08_01" Char(20) NOT NULL ,
	"D08_02" Char(20),
	"D08_03" Char(20) NOT NULL ,
	"D08_04" Char(30),
	"D08_05" Char(30),
	"D08_06" Char(3),
	"D08_07" Char(10),
	"D08_08" Char(10),
	"D08_09" Char(10),
	"D08_10" Char(100),
	"D08_11" Date,
	"D08_12" Integer NOT NULL ,
	"D08_13" Integer,
	"D08_14" Integer,
	"fk_D04_01" Integer,
	"D08_16" Integer,
	"D08_17" Date,
	"D08_18" Date,
	"D08_19" Integer,
	"D08_20" Date,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/

Create table "D09" (
	"pk_D09" Integer NOT NULL ,
	"fk_D01" Integer NOT NULL ,
	"D09_01" Char(50),
	"D09_02" Char(50) NOT NULL ,
	"D09_03" Char(50) NOT NULL ,
	"D09_04" Char(50) NOT NULL ,
	"D09_05" Date,
	"Status" Char(1) NOT NULL ,
	"Created_Date" Date NOT NULL ,
	"Update_Date" Date NOT NULL ) 
/






Alter table "D01" add Constraint "PK_D01" primary key ("pk_D01") 
/
Alter table "D01_03" add Constraint "PK_D01_03" primary key ("pk_D01_03") 
/
Alter table "D01_04" add Constraint "PK_D01_04" primary key ("pk_D01_04") 
/
Alter table "D01_06" add Constraint "PK_D01_06" primary key ("pk_D01_06") 
/
Alter table "D01_10" add Constraint "PK_D01_10" primary key ("pk_D01_10") 
/
Alter table "D01_11" add Constraint "PK_D01_11" primary key ("pk_D01_11") 
/
Alter table "D02" add Constraint "PK_D02" primary key ("pk_D02") 
/
Alter table "D03" add Constraint "PK_D03" primary key ("pk_D03") 
/
Alter table "D04_01" add Constraint "PK_D04_01" primary key ("pk_D04_01") 
/
Alter table "D04_02" add Constraint "PK_D04_02" primary key ("pk_D04_02") 
/
Alter table "D04_03" add Constraint "PK_D04_03" primary key ("pk_D04_03") 
/
Alter table "D04_04" add Constraint "PK_D04_04" primary key ("pk_D04_04") 
/
Alter table "D04_06" add Constraint "PK_D04_06" primary key ("pk_D04_06") 
/
Alter table "D04_08" add Constraint "PK_D04_08" primary key ("pk_D04_08") 
/
Alter table "D04_10" add Constraint "PK_D04_10" primary key ("pk_D04_10") 
/
Alter table "D04_11" add Constraint "PK_D04_11" primary key ("pk_D04_11") 
/
Alter table "D04_13" add Constraint "PK_D04_13" primary key ("pk_D04_13") 
/
Alter table "D04_16" add Constraint "PK_D04_16" primary key ("pk_D04_16") 
/
Alter table "D04_17" add Constraint "PK_D04_17" primary key ("pk_D04_17") 
/
Alter table "D05" add Constraint "PK_D05" primary key ("pk_D05") 
/
Alter table "D06" add Constraint "PK_D06_01" primary key ("pk_D06_01") 
/
Alter table "D06_04" add Constraint "PK_D06_04" primary key ("pk_D06_04") 
/
Alter table "D06_08" add Constraint "PK_D06_08" primary key ("pk_D06_08") 
/
Alter table "D07" add Constraint "PK_D07_01" primary key ("pk_D07_01") 
/
Alter table "D07_05" add Constraint "PK_D07_05" primary key ("pk_D07_05") 
/
Alter table "D08" add Constraint "PK_D08" primary key ("pk_D08") 
/
Alter table "D09" add Constraint "PK_D09" primary key ("pk_D09") 
/