create table BARRICADING_SOURCE(
	SOURCE_CODE VARCHAR2(1) NOT NULL,
	DESCRIPTION VARCHAR2(100) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table COUNTRY(
	COUNTRY_CODE VARCHAR2(2) NOT NULL,
	NAME VARCHAR2(75) NOT NULL
);

create table CRITERIA(
	CRITERIA_CODE VARCHAR2(10) NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL,
	QDE_ENGINE VARCHAR2(255) NULL
);

create table EXPED_AMMO_DETAIL(
	PARENT_ITEM_ID INT NOT NULL,
	SUB_ITEM_ID INT NOT NULL,
	QUANTITY NUMERIC(18,2) NULL,
	NOTES VARCHAR2(4000) NULL
);

create table EXPED_AMMO_ITEM(
	ITEM_ID INT NOT NULL,
	NAME VARCHAR2(50) NULL,
	NSN VARCHAR2(50) NULL,
	ROUNDS_PER INT NULL,
	HZD_CLASS_DIV VARCHAR2(6) NULL,
	NEW_PER_ROUND NUMERIC(9,2) NULL,
	MCE NUMERIC(9,2) NULL,
	LENGTH NUMERIC(9,2) NULL,
	WIDTH NUMERIC(9,2) NULL,
	HEIGHT NUMERIC(9,2) NULL,
	CUBIC_AREA NUMERIC(9,2) NULL,
	WEIGHT NUMERIC(9,2) NULL,
	SHORT_TONS NUMERIC(9,2) NULL,
	IS_MISSILE SMALLINT NULL,
	IS_CL SMALLINT NULL,
	IS_CAT_ONE SMALLINT NULL,
	IS_SAFETY_WALL SMALLINT NULL,
	IS_PREFERRED_MUN SMALLINT NULL,
	IS_STACKABLE SMALLINT NULL,
	COMPLETE_ROUND_TYPE SMALLINT NULL,
	ROW_TYPE SMALLINT NULL,
	OBSOLETE INT NULL,
	NOTES NCHAR NULL
);

create table EXPED_PAD(
	PAD_ID INT NOT NULL,
	SECTION_ID INT NULL,
	FACILITY_ID INT NULL,
	ROW_ID INT NOT NULL
);

create table EXPED_PROJECT(
	PROJECT_ID INT NOT NULL,
	IM_RULE SMALLINT NULL,
	SITE_TYPE SMALLINT NULL,
	MAX_SECTIONS SMALLINT NULL,
	LAYOUT_STYLE SMALLINT NULL,
	PAD_NEW_LIMIT INT NULL,
	DEFAULT_PAD_LENGTH INT NULL,
	DEFAULT_PAD_WIDTH INT NULL,
	DEFAULT_MSL_PAD_LENGTH INT NULL,
	DEFAULT_MSL_PAD_WIDTH INT NULL
);

create table EXPED_QUANTITY(
	PAD_ID INT NOT NULL,
	ITEM_ID INT NOT NULL,
	QUANTITY DECIMAL NULL,
	IS_STACKED SMALLINT NULL
);

create table EXPED_ROW(
	ROW_ID INT NOT NULL,
	ROW_NAME VARCHAR2(50) NOT NULL,
	SECTION_ID INT NOT NULL,
	ROW_TYPE SMALLINT NULL
);

create table EXPED_SECTION(
	SECTION_ID INT NOT NULL,
	SECTION_NAME VARCHAR2(50) NULL,
	PROJECT_ID INT NOT NULL
);

create table EXPED_STOCKAGE_OBJECTIVE(
	PROJECT_ID INT NOT NULL,
	ITEM_ID INT NOT NULL,
	QUANTITY INT NULL,
	IS_STACKABLE SMALLINT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_BARRICADING(
	FACILITY_A INT NOT NULL,
	FACILITY_B INT NOT NULL,
	FACILITY_A_SECTOR SMALLINT NOT NULL,
	FACILITY_B_SECTOR SMALLINT NOT NULL,
	RECORD_SOURCE VARCHAR2(1) NOT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_EXPLOSIVE(
	PES_ID INT NOT NULL,
	HAZARD_CLASS VARCHAR2(10) NOT NULL,
	PES_NEW NUMERIC(18,2) NOT NULL,
	MCE NUMERIC(18,2) NULL,
	QUANTITY_SOURCE VARCHAR2(50) NULL,
	SINGLE_ROUND_NEW NUMERIC(18,2) NULL,
	COMBUSTIBLE_PACKING SMALLINT NULL,
	FRAGMENTING_ITEM SMALLINT NULL,
	GUN_AMMO_30MM_OR_LESS SMALLINT NULL,
	HFD_XX INT NULL,
	IDS_DIAMETER REAL NULL,
	IDS_ITEM SMALLINT NULL,
	LIMITED_QUANTITY SMALLINT NULL,
	CRITICAL_AREA_OVERRIDE SMALLINT NULL,
	HIGH_DENSITY_OVERRIDE SMALLINT NULL,
	TACTICAL_MISSILE_OR_PYROTEK SMALLINT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_INFO(
	FACILITY_OID INT NOT NULL,
	INSTALLATION_ID INT NOT NULL,
	LAYER_ID INT NOT NULL,
	SDS_ID VARCHAR2(60) NOT NULL,
	FACILITY_TIER SMALLINT NOT NULL,
	FACILITY_ACTIVE SMALLINT NOT NULL,
	FACILITY_NUMBER VARCHAR2(60) NULL,
	FACILITY_DESC VARCHAR2(255) NULL,
	FACILITY_NAME VARCHAR2(255) NULL,
	LOCATION VARCHAR2(255) NULL,
	TYPE_CODE VARCHAR2(5) NULL,
	SUB_CATEGORY_CODE VARCHAR2(10) NULL,
	TYPE_CODE_JUSTIFICATION VARCHAR2(255) NULL,
	SUB_CAT_CODE_JUSTIFICATION VARCHAR2(255) NULL,
	OWNER VARCHAR2(50) NULL,
	USING_ORGANIZATION VARCHAR2(50) NULL,
	AIRCRAFT_PARKING VARCHAR2(1) NULL,
	COMBUSTIBLE SMALLINT NULL,
	HARDENED VARCHAR2(1) NULL,
	HEADWALL_TYPE VARCHAR2(1) NULL,
	OPEN_LOCATION SMALLINT NULL,
	SPAN_LENGTH INT NULL,
	HIGH_VOLTAGE SMALLINT NULL,
	OPERATIONAL_NECESSITY SMALLINT NULL,
	PERCENT_HD11_NEW SMALLINT NULL,
	FRAG_CONTAINED SMALLINT NULL,
	MARITIME_PREPOSITIONED_SHIP SMALLINT NULL,
	REINFORCED_OPENINGS SMALLINT NULL,
	PORT_FACIL_EXCEPTION SMALLINT NULL,
	POWER_LOSS SMALLINT NULL,
	SINGLE_AIRCRAFT SMALLINT NULL,
	SPECIFIC_ITEM_CODE VARCHAR2(10) NULL,
	STORAGE_TANK_CONTENTS VARCHAR2(10) NULL,
	FRONT_BARRICADED SMALLINT NULL,
	EXTERNAL_LENGTH SMALLINT NULL,
	EXTERNAL_WIDTH SMALLINT NULL,
	INTERNAL_LENGTH SMALLINT NULL,
	INTERNAL_WIDTH SMALLINT NULL,
	INTERNAL_VOLUME INT NULL,
	POP_DENSITY_COUNT INT NULL,
	POP_DENSITY_CODE VARCHAR2(1) NULL,
	LINE_WIDTH SMALLINT NULL,
	FRONT_ANGLE INT NULL,
	WALL_THICKNESS NCHAR NULL,
	DOOR_WIDTH NCHAR NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_MISSION(
	FACILITY_OID INT NOT NULL,
	MISSION VARCHAR2(50) NOT NULL,
	MISSION_NOTES VARCHAR2(4000) NULL
);

create table FACILITY_MITIGATION(
	FACILITY_ID INT NOT NULL,
	MITIGATION_NAME VARCHAR2(50) NOT NULL,
	MITIGATION_TYPE VARCHAR2(10) NOT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_PES_ES(
	PES_ID INT NOT NULL,
	ES_ID INT NOT NULL,
	PES_SECTOR SMALLINT NOT NULL,
	ES_SECTOR SMALLINT NOT NULL,
	ACTUAL_DISTANCE NUMERIC(18,2) NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_RELATED(
	PES_ID INT NOT NULL,
	ES_ID INT NOT NULL,
	RELATED_CODE VARCHAR2(2) NOT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table FACILITY_VALUE_HISTORY(
	FACILITY_OID INT NULL,
	APPLIED_VALUE VARCHAR2(255) NULL,
	VALUE_TYPE VARCHAR2(10) NULL,
	TIME_STAMP TIMESTAMP NULL,
	ASSIGNED_BY VARCHAR2(255) NULL,
	JUSTIFICATION VARCHAR2(4000) NULL
);

create table FOLDER_PATH(
	INSTALLATION_ID INT NOT NULL,
	FOLDER_NAME VARCHAR2(50) NOT NULL,
	PATH VARCHAR2(255) NOT NULL
);

create table GRAPHIC_LINK(
	PARENT INT NOT NULL,
	CHILD INT NOT NULL
);

create table HAZARD_CLASS(
	HAZARD_CLASS VARCHAR2(10) NOT NULL,
	DESCRIPTION VARCHAR2(255) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table INSTALLATION(
	INSTALLATION_ID INT NOT NULL,
	INSTALLATION_NAME VARCHAR2(50) NULL,
	COUNTRY_CODE VARCHAR2(2) NULL,
	HOST_SERVICE VARCHAR2(50) NULL,
	HOST_UNIT VARCHAR2(50) NULL,
	GLOC VARCHAR2(4) NULL,
	CLEAR_ZONE_DISTANCE NUMERIC(18,2) NULL,
	DEFAULT_QDE VARCHAR2(50) NULL,
	INCLUSION_FACTOR NUMERIC(9,1) NULL
);

create table MAP_LAYER(
	LAYER_ID INT NOT NULL,
	LAYER_NAME VARCHAR2(255) NOT NULL,
	INSTALLATION_ID INT NOT NULL,
	LOAD_ORDER SMALLINT NOT NULL,
	LAYER_CLASS_NAME VARCHAR2(255) NULL,
	LAYER_PERSIST VARCHAR2(255) NOT NULL,
	LAYER_FILE_PATH VARCHAR2(255) NULL,
	LAYER_CATEGORY VARCHAR2(50) NULL,
	FEATURE_SOURCE VARCHAR2(50) NULL,
	FEATURE_USAGE VARCHAR2(50) NULL,
	SHAPE_TYPE VARCHAR2(50) NULL,
	IS_PES_TABLE SMALLINT NOT NULL,
	SDS_TABLE_ID INT NULL,
	SDS_FAC_FIELD VARCHAR2(50) NULL,
	SDS_ID_FIELD VARCHAR2(50) NULL,
	SDS_DESC_FIELD VARCHAR2(50) NULL,
	NOTES VARCHAR2(4000) NULL
);

create table MESSAGE_TYPE(
	MESSAGE_TYPE VARCHAR2(1) NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table MESSAGE_VALUE(
	CRITERIA_CODE VARCHAR2(10) NOT NULL,
	MESSAGE_TYPE VARCHAR2(1) NOT NULL,
	MESSAGE_ID INT NOT NULL,
	SHORT_MESSAGE VARCHAR2(4000) NULL,
	LONG_MESSAGE VARCHAR2(4000) NULL,
	PAGE_NUMBER SMALLINT NULL,
	NOTES VARCHAR2(4000) NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table MITIGATION_TYPE(
	MITIGATION_TYPE_CODE VARCHAR2(10) NOT NULL,
	NAME VARCHAR2(50) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table ORIENTATION_CODE(
	SECTOR SMALLINT NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL
);

create table PROJECT_SETTING(
	INSTALLATION_ID INT NOT NULL,
	SETTING_NAME VARCHAR2(50) NOT NULL,
	SETTING_VALUE VARCHAR2(4000) NULL,
	DESCRIPTION VARCHAR2(4000) NULL
);

create table QDE_ANALYSIS(
	ANALYSIS_ID INT NOT NULL,
	FACILITY_OID INT NOT NULL,
	CRITERIA_CODE VARCHAR2(10) NOT NULL,
	QDENGINE_VERSION VARCHAR2(50) NOT NULL,
	EVALUATION_ZONE INT NULL,
	VIOLATIONS_PRESENT SMALLINT NULL,
	DRAW_MODE SMALLINT NULL,
	PACKAGE_NAME VARCHAR2(50) NULL,
	PACKAGE_BOUNDS VARCHAR2(255) NULL
);

create table QDE_ES(
	ANALYSIS_ID INT NOT NULL,
	ES_ID INT NOT NULL,
	AIRCRAFT_PARKING VARCHAR2(1) NULL,
	ES_COMBUSTIBLE SMALLINT NULL,
	ES_HARDENED VARCHAR2(1) NULL,
	ES_HEADWALLTYPE VARCHAR2(1) NULL,
	ES_OPENLOCATION SMALLINT NULL,
	ES_POPDENSITY VARCHAR2(1) NULL,
	ES_SPANLENGTH INT NULL,
	ES_TYPE VARCHAR2(3) NULL,
	HIGH_VOLTAGE SMALLINT NULL,
	OPERATIONAL_NECESSITY SMALLINT NULL,
	POWER_LOSS SMALLINT NULL,
	STORAGETANK_CONTENTS VARCHAR2(10) NULL
);

create table QDE_HC(
	ANALYSIS_ID INT NOT NULL,
	PES_ID INT NOT NULL,
	HAZARD_CLASS VARCHAR2(5) NOT NULL,
	COMBUSTIBLE_PACKING SMALLINT NULL,
	FRAGMENTING_ITEM SMALLINT NULL,
	GUN_AMMO_30MM_OR_LESS SMALLINT NULL,
	HFD_XX INT NULL,
	IDS_DIAMETER REAL NULL,
	IDS_ITEM SMALLINT NULL,
	LIMITED_QUANTITY SMALLINT NULL,
	NEW_HIGHDENSITY SMALLINT NULL,
	PES_AREA SMALLINT NULL,
	PES_MCE NUMERIC(18,2) NOT NULL,
	PES_NEW NUMERIC(18,2) NULL,
	SINGLE_ROUND_NEW NUMERIC(18,2) NULL,
	TACTICAL_MISSL_OR_PYROTEK SMALLINT NULL
);

create table QDE_PES(
	ANALYSIS_ID INT NOT NULL,
	PES_ID INT NOT NULL,
	PERCENT_HD11_NEW SMALLINT NULL,
	PES_COMBUSTIBLE SMALLINT NULL,
	PES_FRAGCONTAINED SMALLINT NULL,
	PES_HARDENED VARCHAR2(1) NULL,
	PES_HEADWALLTYPE VARCHAR2(1) NULL,
	PES_MPS SMALLINT NULL,
	PES_OPENLOCATION SMALLINT NULL,
	PES_REINFOPENINGS SMALLINT NULL,
	PES_TYPE VARCHAR2(3) NULL,
	PORT_FACIL_EXCEPTION SMALLINT NULL,
	SINGLE_AIRCRAFT SMALLINT NULL,
	SPECIFIC_ITEM_CODE VARCHAR2(10) NULL
);

create table QDE_PES_ES(
	ANALYSIS_ID INT NOT NULL,
	PES_ID INT NOT NULL,
	ES_ID INT NOT NULL,
	PES_SECTOR SMALLINT NOT NULL,
	ES_SECTOR SMALLINT NOT NULL,
	ACTUAL_DISTANCE NUMERIC(18,2) NULL,
	PES_BARRICADED SMALLINT NULL,
	ES_BARRICADED SMALLINT NULL,
	ES_RELATED VARCHAR2(1) NULL
);

create table QDE_RESULT(
	ANALYSIS_ID INT NOT NULL,
	PES_ID INT NOT NULL,
	ES_ID INT NOT NULL,
	PES_SECTOR SMALLINT NOT NULL,
	ES_SECTOR SMALLINT NOT NULL,
	HAZARD_CLASS VARCHAR2(5) NOT NULL,
	QD_DISTANCE_RESULT NUMERIC(18,2) NULL,
	QD_K_FACTOR_RESULT NUMERIC(18,2) NULL,
	DQ_NEW_RESULT NUMERIC(9,2) NULL,
	DQ_MCE_RESULT NUMERIC(9,2) NULL,
	DQ_DISTANCE_RESULT NUMERIC(18,2) NULL,
	DQ_K_FACTOR_RESULT NUMERIC(18,2) NULL,
	EXPOSURE VARCHAR2(5) NULL,
	QD_VIOLATION SMALLINT NULL,
	MITIGATION VARCHAR2(50) NULL,
	OVERPRESSURE_DISTANCE INT NULL,
	PRIMARY_FRAGMENT_DISTANCE INT NULL,
	SECONDARY_FRAGMENT_DISTANCE INT NULL,
	QDE_CRITERIA_REFERENCE INT NULL,
	QDE_FOOTNOTE_REFERENCE INT NULL,
	QDE_MESSAGE_REFERENCE INT NULL,
	CRITICAL_PAIR SMALLINT NULL,
	GOV_EXPOSURE SMALLINT NULL
);

create table RELATED_FACILITY_CODE(
	RELATED_CODE VARCHAR2(2) NOT NULL,
	DESCRIPTION VARCHAR2(255) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SDS_ATTRIBUTE_CODE(
	ATTRIBUTE_ID SMALLINT NOT NULL,
	SDS_TABLE_ID SMALLINT NOT NULL,
	ATTRIBUTE_NAME VARCHAR2(50) NOT NULL,
	DESCRIPTION VARCHAR2(255) NOT NULL,
	IS_PRIMARY_SDS_KEY SMALLINT NOT NULL,
	IS_PRIMARY_DESCRIPTION SMALLINT NOT NULL,
	IS_PRIMARY_NUMBER SMALLINT NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SDS_TABLE_CODE(
	SDS_TABLE_ID SMALLINT NOT NULL,
	NAME VARCHAR2(50) NOT NULL,
	SDS_SET VARCHAR2(50) NULL,
	SDS_CLASS VARCHAR2(50) NULL,
	SDS_TYPE VARCHAR2(50) NULL,
	ID_FIELD VARCHAR2(50) NULL,
	SHAPE_TYPE VARCHAR2(50) NULL,
	DEFAULT_NAME VARCHAR2(50) NULL,
	IS_PES_TABLE SMALLINT NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SELECTION_BOOKMARK(
	INSTALLATION_ID SMALLINT NOT NULL,
	BOOKMARK_ID SMALLINT NOT NULL,
	NAME VARCHAR2(50) NOT NULL,
	SORT_ORDER SMALLINT NULL
);

create table SELECTION_BOOKMARK_ITEM(
	BOOKMARK_ID SMALLINT NOT NULL,
	FACILITY_ID INT NOT NULL
);

create table SERVICE(
	SERVICE_NAME VARCHAR2(10) NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SITEPLAN_STATE_CODE(
	STATE_CODE VARCHAR2(1) NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SITEPLAN_STATUS_CODE(
	STATUS_CODE VARCHAR2(1) NOT NULL,
	DESCRIPTION VARCHAR2(50) NOT NULL,
	OBSOLETE SMALLINT NOT NULL
);

create table SPATIAL_BOOKMARK(
	INSTALLATION_ID SMALLINT NOT NULL,
	NAME VARCHAR2(50) NOT NULL,
	TOP_Y NUMERIC(10,8) NOT NULL,
	BOTTOM_y NUMERIC(10,8) NOT NULL,
	LEFT_X NUMERIC(10,8) NOT NULL,
	RIGHT_X NUMERIC(10,8) NOT NULL,
	SORT_ORDER INT NULL
);

create table SUB_CATCODE_TYPECODE_LINK(
	SUB_CATEGORY_CODE VARCHAR2(10) NOT NULL,
	TYPE_CODE VARCHAR2(5) NOT NULL
);

create table SUB_CATEGORY_CODE(
	SUB_CATEGORY_CODE VARCHAR2(10) NOT NULL,
	CRITERIA VARCHAR2(10) NOT NULL,
	NAME VARCHAR2(255) NOT NULL,
	DESCRIPTION VARCHAR2(4000) NULL,
	IMPORT_TYPE_CODE VARCHAR2(5) NULL,
	OBSOLETE SMALLINT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table TYPE_CODE(
	TYPE_CODE VARCHAR2(5) NOT NULL,
	DESCRIPTION VARCHAR2(100) NOT NULL,
	PES SMALLINT NOT NULL,
	QDE_TYPE_CODE VARCHAR2(5) NOT NULL,
	OBSOLETE SMALLINT NOT NULL,
	NOTES VARCHAR2(4000) NULL
);

create table TYPE_CODE_SEGMENT(
	TYPE_CODE VARCHAR2(5) NOT NULL,
	ORIENTATION SMALLINT NOT NULL,
	LEFT_ANGLE SMALLINT NOT NULL,
	RIGHT_ANGLE SMALLINT NOT NULL,
	NOTES VARCHAR2(4000) NULL
);


alter table BARRICADING_SOURCE add primary key(SOURCE_CODE);
alter table COUNTRY add primary key(COUNTRY_CODE);
alter table CRITERIA add primary key(CRITERIA_CODE);
alter table EXPED_AMMO_DETAIL add primary key(PARENT_ITEM_ID,SUB_ITEM_ID);
alter table EXPED_AMMO_ITEM add primary key(ITEM_ID);
alter table EXPED_PAD add primary key(PAD_ID);
alter table EXPED_PROJECT add primary key(PROJECT_ID);
alter table EXPED_QUANTITY add primary key(PAD_ID,ITEM_ID);
alter table EXPED_ROW add primary key(ROW_ID);
alter table EXPED_SECTION add primary key(SECTION_ID);
alter table EXPED_STOCKAGE_OBJECTIVE add primary key(PROJECT_ID,ITEM_ID);
alter table FACILITY_BARRICADING add primary key(FACILITY_A,FACILITY_B,FACILITY_A_SECTOR,FACILITY_B_SECTOR);
alter table FACILITY_EXPLOSIVE add primary key(PES_ID,HAZARD_CLASS);
alter table FACILITY_INFO add primary key(FACILITY_OID);
alter table FACILITY_MISSION add primary key(FACILITY_OID,MISSION);
alter table FACILITY_MITIGATION add primary key(FACILITY_ID,MITIGATION_NAME);
alter table FACILITY_PES_ES add primary key(PES_ID,ES_ID,PES_SECTOR,ES_SECTOR);
alter table FACILITY_RELATED add primary key(PES_ID,ES_ID);
alter table FOLDER_PATH add primary key(INSTALLATION_ID,FOLDER_NAME);
alter table GRAPHIC_LINK add primary key(PARENT,CHILD);
alter table HAZARD_CLASS add primary key(HAZARD_CLASS);
alter table INSTALLATION add primary key(INSTALLATION_ID);
alter table MAP_LAYER add primary key(LAYER_ID);
alter table MESSAGE_TYPE add primary key(MESSAGE_TYPE);
alter table MESSAGE_VALUE add primary key(CRITERIA_CODE,MESSAGE_TYPE,MESSAGE_ID);
alter table MITIGATION_TYPE add primary key(MITIGATION_TYPE_CODE);
alter table ORIENTATION_CODE add primary key(SECTOR);
alter table PROJECT_SETTING add primary key(INSTALLATION_ID,SETTING_NAME);
alter table QDE_ANALYSIS add primary key(ANALYSIS_ID);
alter table QDE_ES add primary key(ANALYSIS_ID,ES_ID);
alter table QDE_HC add primary key(ANALYSIS_ID,PES_ID,HAZARD_CLASS);
alter table QDE_PES add primary key(ANALYSIS_ID,PES_ID);
alter table QDE_PES_ES add primary key(ANALYSIS_ID,PES_ID,ES_ID,PES_SECTOR,ES_SECTOR);
alter table QDE_RESULT add primary key(ANALYSIS_ID,PES_ID,ES_ID,PES_SECTOR,ES_SECTOR,HAZARD_CLASS);
alter table RELATED_FACILITY_CODE add primary key(RELATED_CODE);
alter table SDS_ATTRIBUTE_CODE add primary key(ATTRIBUTE_ID);
alter table SDS_TABLE_CODE add primary key(SDS_TABLE_ID);
alter table SELECTION_BOOKMARK add primary key(INSTALLATION_ID,BOOKMARK_ID);
alter table SERVICE add primary key(SERVICE_NAME);
alter table SITEPLAN_STATE_CODE add primary key(STATE_CODE);
alter table SITEPLAN_STATUS_CODE add primary key(STATUS_CODE);
alter table SPATIAL_BOOKMARK add primary key(INSTALLATION_ID,NAME);
alter table SUB_CATCODE_TYPECODE_LINK add primary key(SUB_CATEGORY_CODE,TYPE_CODE);
alter table SUB_CATEGORY_CODE add primary key(SUB_CATEGORY_CODE,CRITERIA);
alter table TYPE_CODE add primary key(TYPE_CODE);
alter table TYPE_CODE_SEGMENT add primary key(TYPE_CODE,ORIENTATION);


alter table FACILITY_INFO add foreign key (LAYER_ID) references MAP_LAYER(LAYER_ID);
alter table SDS_ATTRIBUTE_CODE add foreign key (SDS_TABLE_ID) references SDS_TABLE_CODE(SDS_TABLE_ID);
alter table FACILITY_BARRICADING add foreign key (RECORD_SOURCE) references BARRICADING_SOURCE(SOURCE_CODE);
alter table FACILITY_BARRICADING add foreign key (FACILITY_A_SECTOR) references ORIENTATION_CODE(SECTOR);
alter table FACILITY_BARRICADING add foreign key (FACILITY_B_SECTOR) references ORIENTATION_CODE(SECTOR);
alter table EXPED_PAD add foreign key (ROW_ID) references EXPED_ROW(ROW_ID);
alter table EXPED_ROW add foreign key (SECTION_ID) references EXPED_SECTION(SECTION_ID);
alter table MAP_LAYER add foreign key (INSTALLATION_ID) references INSTALLATION(INSTALLATION_ID);
alter table EXPED_PROJECT add foreign key (PROJECT_ID) references INSTALLATION(INSTALLATION_ID);
alter table FACILITY_INFO add foreign key (INSTALLATION_ID) references INSTALLATION(INSTALLATION_ID);
alter table EXPED_STOCKAGE_OBJECTIVE add foreign key (PROJECT_ID) references EXPED_PROJECT(PROJECT_ID);
alter table EXPED_SECTION add foreign key (PROJECT_ID) references EXPED_PROJECT(PROJECT_ID);
alter table EXPED_AMMO_DETAIL add foreign key (SUB_ITEM_ID) references EXPED_AMMO_ITEM(ITEM_ID);
alter table EXPED_STOCKAGE_OBJECTIVE add foreign key (ITEM_ID) references EXPED_AMMO_ITEM(ITEM_ID);
alter table EXPED_QUANTITY add foreign key (ITEM_ID) references EXPED_AMMO_ITEM(ITEM_ID);
alter table FACILITY_MITIGATION add foreign key (MITIGATION_TYPE) references MITIGATION_TYPE(MITIGATION_TYPE_CODE);
alter table FACILITY_MITIGATION add foreign key (FACILITY_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_PES_ES add foreign key (PES_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_PES_ES add foreign key (ES_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_RELATED add foreign key (ES_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_RELATED add foreign key (PES_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_BARRICADING add foreign key (FACILITY_B) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_BARRICADING add foreign key (FACILITY_A) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_EXPLOSIVE add foreign key (PES_ID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_VALUE_HISTORY add foreign key (FACILITY_OID) references FACILITY_INFO(FACILITY_OID);
alter table FACILITY_MISSION add foreign key (FACILITY_OID) references FACILITY_INFO(FACILITY_OID);
alter table EXPED_PAD add foreign key (PAD_ID) references FACILITY_INFO(FACILITY_OID);
alter table QDE_ANALYSIS add foreign key (FACILITY_OID) references FACILITY_INFO(FACILITY_OID);
alter table QDE_RESULT add foreign key (ANALYSIS_ID) references QDE_ANALYSIS(ANALYSIS_ID);
alter table QDE_HC add foreign key (ANALYSIS_ID) references QDE_ANALYSIS(ANALYSIS_ID);
alter table QDE_PES add foreign key (ANALYSIS_ID) references QDE_ANALYSIS(ANALYSIS_ID);
alter table QDE_ES add foreign key (ANALYSIS_ID) references QDE_ANALYSIS(ANALYSIS_ID);
alter table QDE_PES_ES add foreign key (ANALYSIS_ID) references QDE_ANALYSIS(ANALYSIS_ID);
alter table EXPED_QUANTITY add foreign key (PAD_ID) references EXPED_PAD(PAD_ID);