V1.0.1__base_tables.sql

CREATE TABLE THE.CUT_BLOCK_OPEN_ADMIN (
	CUT_BLOCK_OPEN_ADMIN_ID NUMBER(10,0),
	FOREST_FILE_ID VARCHAR2(10),
	TIMBER_MARK VARCHAR2(10),
	CUT_BLOCK_ID VARCHAR2(10),
	CUTTING_PERMIT_ID VARCHAR2(3),
	DISTURBANCE_GROSS_AREA NUMBER(11,4),
	DISTURBANCE_START_DATE DATE,
	DISTURBANCE_END_DATE DATE,
	OPENING_ID NUMBER(10,0),
	OPENING_GROSS_AREA NUMBER(11,4),
	PLANNED_HARVEST_DATE DATE,
	PLANNED_GROSS_BLOCK_AREA NUMBER(11,4),
	PLANNED_NET_BLOCK_AREA NUMBER(11,4),
	OPENING_PRIME_LICENCE_IND VARCHAR2(1),
	CB_SKEY NUMBER(10,0),
	REVISION_COUNT NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	CONSTRAINT AVCON_1054232647_OPENI_000 CHECK (
OPENING_PRIME_LICENCE_IND IN ('N', 'Y')
),
	CONSTRAINT CBOA_PK PRIMARY KEY (CUT_BLOCK_OPEN_ADMIN_ID),
	CONSTRAINT SYS_C0021117_CBOA_CT CHECK ("CUT_BLOCK_OPEN_ADMIN_ID" IS NOT NULL),
	CONSTRAINT SYS_C0021119_CBOA_CT CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT SYS_C0021121_CBOA_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0021123_CBOA_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0021124_CBOA_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0021125_CBOA_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL)
);
CREATE INDEX CBOA_CBLK_FK_I ON THE.CUT_BLOCK_OPEN_ADMIN (CUT_BLOCK_ID,TIMBER_MARK,FOREST_FILE_ID);
CREATE INDEX CBOA_CBSKEY_I ON THE.CUT_BLOCK_OPEN_ADMIN (CB_SKEY);
CREATE INDEX CBOA_FFID_MARK_BLK_I ON THE.CUT_BLOCK_OPEN_ADMIN (FOREST_FILE_ID,TIMBER_MARK,CUT_BLOCK_ID);
CREATE INDEX CBOA_MARK_BLK_I ON THE.CUT_BLOCK_OPEN_ADMIN (TIMBER_MARK,CUT_BLOCK_ID);
CREATE INDEX CBOA_O_FK_I ON THE.CUT_BLOCK_OPEN_ADMIN (OPENING_ID);

CREATE TABLE THE.OPENING_ATTACHMENT (
	OPENING_ATTACHMENT_FILE_ID NUMBER(10,0),
	OPENING_ID NUMBER(10,0),
	ATTACHMENT_NAME VARCHAR2(50),
	ATTACHMENT_DESCRIPTION VARCHAR2(120),
	MIME_TYPE_CODE VARCHAR2(3),
	ATTACHMENT_DATA BLOB,
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	OPENING_ATTACHMENT_GUID RAW(16) DEFAULT sys_guid() ,
	CONSTRAINT OPATT_GUID_UK UNIQUE (OPENING_ATTACHMENT_GUID),
	CONSTRAINT OPENING_ATTACHMENT_PK PRIMARY KEY (OPENING_ATTACHMENT_FILE_ID),
	CONSTRAINT SYS_C00170771_OPATT_CT CHECK ("OPENING_ATTACHMENT_GUID" IS NOT NULL),
	CONSTRAINT SYS_C0040027_OPATT_CT CHECK ("OPENING_ATTACHMENT_FILE_ID" IS NOT NULL),
	CONSTRAINT SYS_C0040028_OPATT_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0040029_OPATT_CT CHECK ("ATTACHMENT_NAME" IS NOT NULL),
	CONSTRAINT SYS_C0040030_OPATT_CT CHECK ("ATTACHMENT_DATA" IS NOT NULL),
	CONSTRAINT SYS_C0040031_OPATT_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0040032_OPATT_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0040033_OPATT_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0040034_OPATT_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0040035_OPATT_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX OA_MTC_FK_I ON THE.OPENING_ATTACHMENT (MIME_TYPE_CODE);
CREATE INDEX OA_O_FK_I ON THE.OPENING_ATTACHMENT (OPENING_ID);

CREATE TABLE THE.OPENING (
	OPENING_ID NUMBER(10,0),
	GEO_DISTRICT_NO NUMBER(10,0),
	ADMIN_DISTRICT_NO NUMBER(10,0),
	MAPSHEET_GRID VARCHAR2(3),
	MAPSHEET_LETTER VARCHAR2(1),
	MAPSHEET_SQUARE VARCHAR2(3),
	MAPSHEET_QUAD VARCHAR2(1),
	MAPSHEET_SUB_QUAD VARCHAR2(1),
	OPENING_NUMBER VARCHAR2(4),
	OPENING_LOCN_NAME VARCHAR2(30),
	OPEN_CATEGORY_CODE VARCHAR2(7),
	LICENSEE_OPENING_ID VARCHAR2(30),
	TSB_NUMBER_CODE VARCHAR2(3),
	OPENING_STATUS_CODE VARCHAR2(3),
	ORG_UNIT_NO NUMBER(10,0),
	DIST_ADMIN_ZONE VARCHAR2(2),
	MAX_ALLOW_PERMNT_ACCESS_PCT NUMBER(3,1),
	PREV_AGE_CLASS_CODE VARCHAR2(1),
	PREV_SITE_INDEX NUMBER(5,0),
	PREV_SITE_INDEX_SOURCE_CODE VARCHAR2(1),
	PREV_HEIGHT_CLASS_CODE VARCHAR2(1),
	PREV_SITE_CLASS_CODE VARCHAR2(1),
	PREV_STOCKING_CLASS_CODE VARCHAR2(1),
	PREV_STOCKING_STATUS_CODE VARCHAR2(3),
	PREV_TREE_SPP1_CODE VARCHAR2(8),
	PREV_TREE_SPP2_CODE VARCHAR2(8),
	APP_ENT_BY_USERID VARCHAR2(30),
	APPROVE_DATE DATE,
	AMENDMENT_IND VARCHAR2(1),
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT O_PK PRIMARY KEY (OPENING_ID),
	CONSTRAINT SYS_C0039363_O_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0039364_O_CT CHECK ("GEO_DISTRICT_NO" IS NOT NULL),
	CONSTRAINT SYS_C0039365_O_CT CHECK ("ADMIN_DISTRICT_NO" IS NOT NULL),
	CONSTRAINT SYS_C0039366_O_CT CHECK ("OPEN_CATEGORY_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0039367_O_CT CHECK ("OPENING_STATUS_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0039368_O_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0039369_O_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0039370_O_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0039371_O_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0039372_O_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX O_LICENSEE_ID_I ON THE.OPENING (LICENSEE_OPENING_ID);
CREATE INDEX O_OPENING_NUMBER_I ON THE.OPENING (MAPSHEET_GRID,MAPSHEET_LETTER,MAPSHEET_QUAD,MAPSHEET_SQUARE,MAPSHEET_SUB_QUAD,OPENING_NUMBER);
CREATE INDEX O_OPEN_CATEGORY_CODE_I ON THE.OPENING (OPEN_CATEGORY_CODE);
CREATE INDEX O_OU_FK_I ON THE.OPENING (ADMIN_DISTRICT_NO);
CREATE INDEX O_STATUS_I ON THE.OPENING (OPENING_STATUS_CODE);

CREATE TABLE THE.RESULTS_ELECTRONIC_SUBMISSION (
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	SUBMISSION_TIMESTAMP DATE,
	SUBMITTED_BY VARCHAR2(30),
	CLIENT_NUMBER VARCHAR2(8),
	CLIENT_LOCN_CODE VARCHAR2(2),
	ORG_UNIT_NO NUMBER(10,0),
	USER_FILENAME VARCHAR2(50),
	USER_REFERENCE VARCHAR2(240),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT RES_PK PRIMARY KEY (RESULTS_SUBMISSION_ID),
	CONSTRAINT SYS_C008001_RES_CT CHECK ("RESULTS_SUBMISSION_ID" IS NOT NULL),
	CONSTRAINT SYS_C008002_RES_CT CHECK ("SUBMISSION_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C008003_RES_CT CHECK ("SUBMITTED_BY" IS NOT NULL),
	CONSTRAINT SYS_C008004_RES_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C008005_RES_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C008006_RES_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C008007_RES_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C008008_RES_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);

CREATE TABLE THE.SILV_ADMIN_ZONE (
	DIST_ADMIN_ZONE VARCHAR2(2),
	ORG_UNIT_NO NUMBER(10,0),
	ADMIN_ZONE_DESC VARCHAR2(50),
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT SILV_ADMIN_ZONE_PK PRIMARY KEY (ORG_UNIT_NO,DIST_ADMIN_ZONE),
	CONSTRAINT SYS_C007705_SAZ_CT CHECK ("DIST_ADMIN_ZONE" IS NOT NULL),
	CONSTRAINT SYS_C007706_SAZ_CT CHECK ("ORG_UNIT_NO" IS NOT NULL),
	CONSTRAINT SYS_C007707_SAZ_CT CHECK ("ADMIN_ZONE_DESC" IS NOT NULL),
	CONSTRAINT SYS_C007708_SAZ_CT CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT SAZ_OU_FK FOREIGN KEY (ORG_UNIT_NO) REFERENCES THE.ORG_UNIT(ORG_UNIT_NO)
);

CREATE TABLE THE.OPENING_AMENDMENT_HISTORY (
	OPENING_ID NUMBER(10,0),
	OPENING_AMENDMENT_NUMBER NUMBER(5,0),
	AMENDMENT_USERID VARCHAR2(30),
	AMENDMENT_DATE DATE,
	SUBMITTED_BY_USERID VARCHAR2(30),
	SUBMITTED_DATE DATE,
	APP_ENT_BY_USERID VARCHAR2(30),
	APPROVE_DATE DATE,
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT OAH_PK PRIMARY KEY (OPENING_ID,OPENING_AMENDMENT_NUMBER),
	CONSTRAINT SYS_C0026176_OAH_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0026178_OAH_CT CHECK ("OPENING_AMENDMENT_NUMBER" IS NOT NULL),
	CONSTRAINT SYS_C0026181_OAH_CT CHECK ("AMENDMENT_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026184_OAH_CT CHECK ("AMENDMENT_DATE" IS NOT NULL),
	CONSTRAINT SYS_C0026187_OAH_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026190_OAH_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0026193_OAH_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026196_OAH_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0026199_OAH_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);

CREATE TABLE THE.STOCKING_EVENT_HISTORY (
	STOCKING_EVENT_HISTORY_ID NUMBER(10,0),
	OPENING_ID NUMBER(10,0),
	OPENING_AMENDMENT_ID NUMBER(10,0),
	OPENING_AMENDMENT_NUMBER NUMBER(5,0),
	RESULTS_AUDIT_ACTION_CODE VARCHAR2(3),
	SUBMITTED_USERID VARCHAR2(30),
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	AMEND_EVENT_TIMESTAMP DATE,
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT SEH_PK PRIMARY KEY (STOCKING_EVENT_HISTORY_ID),
	CONSTRAINT SYS_C0016112_SEH_CT CHECK ("STOCKING_EVENT_HISTORY_ID" IS NOT NULL),
	CONSTRAINT SYS_C0016113_SEH_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0016114_SEH_CT CHECK ("RESULTS_AUDIT_ACTION_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0016115_SEH_CT CHECK ("AMEND_EVENT_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0016116_SEH_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0016117_SEH_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0016118_SEH_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX SEH_OAH_FK_I ON THE.STOCKING_EVENT_HISTORY (OPENING_AMENDMENT_ID,OPENING_AMENDMENT_NUMBER);
CREATE INDEX SEH_O_FK_I ON THE.STOCKING_EVENT_HISTORY (OPENING_ID);

CREATE TABLE THE.RESULTS_AUDIT_EVENT (
	RESULTS_AUDIT_EVENT_ID NUMBER(10,0),
	OPENING_ID NUMBER(10,0),
	STANDARDS_REGIME_ID NUMBER(10,0),
	SILVICULTURE_PROJECT_ID NUMBER(10,0),
	RESULTS_AUDIT_ACTION_CODE VARCHAR2(3),
	ACTION_DATE DATE,
	DESCRIPTION VARCHAR2(2000),
	USER_ID VARCHAR2(30),
	EMAIL_SENT_IND VARCHAR2(1),
	XML_SUBMISSION_ID NUMBER(10,0),
	OPENING_AMENDMENT_NUMBER NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	CONSTRAINT RAE_PK PRIMARY KEY (RESULTS_AUDIT_EVENT_ID),
	CONSTRAINT SYS_C0026137_RAE_CT CHECK ("RESULTS_AUDIT_EVENT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0026138_RAE_CT CHECK ("RESULTS_AUDIT_ACTION_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0026139_RAE_CT CHECK ("ACTION_DATE" IS NOT NULL),
	CONSTRAINT SYS_C0026140_RAE_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026141_RAE_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT RAE_RAAC_FK FOREIGN KEY (RESULTS_AUDIT_ACTION_CODE) REFERENCES THE.RESULTS_AUDIT_ACTION_CODE(RESULTS_AUDIT_ACTION_CODE)
);

CREATE TABLE THE.ACTIVITY_TREATMENT_UNIT (
	ACTIVITY_TREATMENT_UNIT_ID NUMBER(10,0),
	ACTIVITY_TU_SEQ_NO NUMBER(5,0),
	ORG_UNIT_NO NUMBER(10,0),
	OPENING_ID NUMBER(10,0),
	SILVICULTURE_PROJECT_ID NUMBER(10,0),
	PROJECT_UNIT_ID NUMBER(6,0),
	SILV_BASE_CODE VARCHAR2(2),
	SILV_TECHNIQUE_CODE VARCHAR2(2),
	SILV_METHOD_CODE VARCHAR2(5),
	SILV_OBJECTIVE_CODE_1 VARCHAR2(3),
	SILV_OBJECTIVE_CODE_2 VARCHAR2(3),
	SILV_OBJECTIVE_CODE_3 VARCHAR2(3),
	SILV_FUND_SRCE_CODE VARCHAR2(3),
	SILV_ACTIVITY_MEASUREMENT_CODE VARCHAR2(3),
	ACTIVITY_LICENSEE_ID VARCHAR2(30),
	TREATMENT_AMOUNT NUMBER(11,1),
	ACTUAL_TREATMENT_COST NUMBER(9,0),
	ACT_PLANTED_NO NUMBER(10,0),
	PLAN_SILV_TECHNIQUE_CODE VARCHAR2(2),
	PLAN_SILV_METHOD_CODE VARCHAR2(5),
	PLAN_SILV_FUND_SRCE_CODE VARCHAR2(3),
	PLANNED_DATE DATE,
	PLANNED_TREATMENT_AMOUNT NUMBER(11,1),
	PLANNED_TREATMENT_COST NUMBER(9,0),
	PLAN_SILV_OBJECTIVE_CODE_1 VARCHAR2(3),
	PLAN_SILV_OBJECTIVE_CODE_2 VARCHAR2(3),
	PLAN_SILV_OBJECTIVE_CODE_3 VARCHAR2(3),
	TARGET_PREPARED_SPOTS NUMBER(4,0),
	PRUNING_MIN_CROWN_PCT NUMBER(3,0),
	PRUNE_HEIGHT NUMBER(3,1),
	STEMS_TO_PRUNE NUMBER(4,0),
	MIN_ACCEPTABLE_DENSITY NUMBER(4,0),
	TOTAL_STEMS_PER_HA NUMBER(4,0),
	INTER_TREE_TARGET_DISTANCE NUMBER(3,1),
	INTER_TREE_VARIATION NUMBER(3,1),
	INTER_TREE_MIN_DISTANCE NUMBER(3,1),
	MAX_TREES_PER_PLOT NUMBER(2,0),
	MAX_TREES_PER_HA NUMBER(4,0),
	SURVEY_PLANNED_NUM_PLOTS NUMBER(4,0),
	SURVEY_ACTUAL_NUM_PLOTS NUMBER(4,0),
	SURVEY_MIN_PLOTS_PER_STRATUM NUMBER(10,0),
	SILV_TREE_SPECIES_CODE VARCHAR2(8),
	ATU_START_DATE DATE,
	ATU_COMPLETION_DATE DATE,
	RESULTS_IND VARCHAR2(1),
	UNIT_BID_PRICE NUMBER(9,2),
	FIA_PROJECT_ID VARCHAR2(10),
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	DISTURBANCE_CODE VARCHAR2(3),
	SILV_SYSTEM_CODE VARCHAR2(5),
	SILV_SYSTEM_VARIANT_CODE VARCHAR2(3),
	SILV_CUT_PHASE_CODE VARCHAR2(5),
	CUT_BLOCK_OPEN_ADMIN_ID NUMBER(10,0),
	DISTURBANCE_COMPLETED_IND VARCHAR2(1),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT ATU_PK PRIMARY KEY (ACTIVITY_TREATMENT_UNIT_ID),
	CONSTRAINT SYS_C0039733_ATU_CT CHECK ("ACTIVITY_TREATMENT_UNIT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0039734_ATU_CT CHECK ("ACTIVITY_TU_SEQ_NO" IS NOT NULL),
	CONSTRAINT SYS_C0039735_ATU_CT CHECK ("ORG_UNIT_NO" IS NOT NULL),
	CONSTRAINT SYS_C0039736_ATU_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0039737_ATU_CT CHECK ("SILV_BASE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0039738_ATU_CT CHECK ("SILV_ACTIVITY_MEASUREMENT_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0039739_ATU_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0039740_ATU_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0039741_ATU_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0039742_ATU_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0039743_ATU_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX ATU_ATU_I ON THE.ACTIVITY_TREATMENT_UNIT (OPENING_ID,SILV_BASE_CODE,SILV_METHOD_CODE,SILV_TECHNIQUE_CODE,TREATMENT_AMOUNT);
CREATE INDEX ATU_BASE_I ON THE.ACTIVITY_TREATMENT_UNIT (SILV_BASE_CODE,RESULTS_IND);
CREATE INDEX ATU_CBOA_FK_I ON THE.ACTIVITY_TREATMENT_UNIT (CUT_BLOCK_OPEN_ADMIN_ID);
CREATE INDEX ATU_LICENSEE_I ON THE.ACTIVITY_TREATMENT_UNIT (ACTIVITY_LICENSEE_ID);
CREATE INDEX ATU_O_FK_I ON THE.ACTIVITY_TREATMENT_UNIT (OPENING_ID);
CREATE INDEX ATU_PROJECT_I ON THE.ACTIVITY_TREATMENT_UNIT (FIA_PROJECT_ID,RESULTS_IND);
CREATE INDEX ATU_PROJ_FK_I ON THE.ACTIVITY_TREATMENT_UNIT (SILVICULTURE_PROJECT_ID);

CREATE TABLE THE.SILV_RELIEF_APPLICATION (
	SILV_RELIEF_APPLICATION_ID NUMBER(10,0),
	SILV_RELIEF_APPLICATION_NO NUMBER(3,0),
	ACTIVITY_TREATMENT_UNIT_ID NUMBER(10,0),
	SILV_RELIEF_APPL_STATUS_CODE VARCHAR2(3),
	PRE_EVENT_FOREST_COVER_DATE DATE,
	POST_EVENT_FOREST_COVER_DATE DATE,
	AMENDMENT_OPENING_ID NUMBER(10,0),
	OPENING_AMENDMENT_NUMBER NUMBER(5,0),
	OBLIGATION_RELIEF_IND VARCHAR2(1),
	OBLIGATION_MET_IND VARCHAR2(1),
	CAUSE_DAMAGE_IND VARCHAR2(1),
	OFFICIALLY_INDUCED_ERROR_IND VARCHAR2(1),
	DUE_DILIGENCE_IND VARCHAR2(1),
	AUTHORIZATION_CHECKED_IND VARCHAR2(1),
	SUBMITTED_DATE DATE,
	SUBMITTED_BY_USERID VARCHAR2(30),
	APPROVED_DATE DATE,
	APPROVED_BY_USERID VARCHAR2(30),
	REJECT_COMMENT VARCHAR2(2000),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT SRA_PK PRIMARY KEY (SILV_RELIEF_APPLICATION_ID),
	CONSTRAINT SYS_C0030824_SRA_CT CHECK ("SILV_RELIEF_APPLICATION_ID" IS NOT NULL),
	CONSTRAINT SYS_C0030825_SRA_CT CHECK ("SILV_RELIEF_APPLICATION_NO" IS NOT NULL),
	CONSTRAINT SYS_C0030826_SRA_CT CHECK ("ACTIVITY_TREATMENT_UNIT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0030827_SRA_CT CHECK ("SILV_RELIEF_APPL_STATUS_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0030828_SRA_CT CHECK ("PRE_EVENT_FOREST_COVER_DATE" IS NOT NULL),
	CONSTRAINT SYS_C0030829_SRA_CT CHECK ("POST_EVENT_FOREST_COVER_DATE" IS NOT NULL),
	CONSTRAINT SYS_C0030830_SRA_CT CHECK ("OBLIGATION_RELIEF_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030831_SRA_CT CHECK ("OBLIGATION_MET_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030832_SRA_CT CHECK ("CAUSE_DAMAGE_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030833_SRA_CT CHECK ("OFFICIALLY_INDUCED_ERROR_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030834_SRA_CT CHECK ("DUE_DILIGENCE_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030835_SRA_CT CHECK ("AUTHORIZATION_CHECKED_IND" IS NOT NULL),
	CONSTRAINT SYS_C0030836_SRA_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0030837_SRA_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0030838_SRA_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0030839_SRA_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0030840_SRA_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX SRA_ATU_FK_I ON THE.SILV_RELIEF_APPLICATION (ACTIVITY_TREATMENT_UNIT_ID);
CREATE INDEX SRA_OAH_FK_I ON THE.SILV_RELIEF_APPLICATION (AMENDMENT_OPENING_ID,OPENING_AMENDMENT_NUMBER);
CREATE INDEX SRA_SRASCD_FK_I ON THE.SILV_RELIEF_APPLICATION (SILV_RELIEF_APPL_STATUS_CODE);

CREATE TABLE THE.STOCKING_STANDARD_UNIT (
	STOCKING_STANDARD_UNIT_ID NUMBER(10,0),
	OPENING_ID NUMBER(10,0),
	STANDARDS_UNIT_ID VARCHAR2(4),
	STANDARDS_REGIME_ID NUMBER(10,0),
	NET_AREA NUMBER(7,1),
	MAX_ALLOW_SOIL_DISTURBANCE_PCT NUMBER(3,1),
	VARIANCE_IND VARCHAR2(1),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT SSU_PK PRIMARY KEY (STOCKING_STANDARD_UNIT_ID),
	CONSTRAINT SYS_C0030763_SSU_CT CHECK ("STOCKING_STANDARD_UNIT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0030764_SSU_CT CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C0030765_SSU_CT CHECK ("STANDARDS_UNIT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0030767_SSU_CT CHECK ("NET_AREA" IS NOT NULL),
	CONSTRAINT SYS_C0030769_SSU_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0030771_SSU_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0030773_SSU_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0030775_SSU_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0030776_SSU_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX SSU_O_FK_I ON THE.STOCKING_STANDARD_UNIT (OPENING_ID);
CREATE INDEX SSU_SR_FK_I ON THE.STOCKING_STANDARD_UNIT (STANDARDS_REGIME_ID);
CREATE INDEX SSU_SU_I ON THE.STOCKING_STANDARD_UNIT (OPENING_ID,STANDARDS_UNIT_ID);

CREATE TABLE THE.STOCKING_STANDARD_UNIT_AMD (
  STOCKING_STANDARD_UNIT_ID NUMBER(10,0) NOT NULL ENABLE,
	OPENING_ID NUMBER(10,0) NOT NULL ENABLE,
	STANDARDS_UNIT_ID VARCHAR2(4) NOT NULL ENABLE,
	STANDARDS_REGIME_ID NUMBER(10,0),
	NET_AREA NUMBER(7,1) NOT NULL ENABLE,
	MAX_ALLOW_SOIL_DISTURBANCE_PCT NUMBER(3,1),
	VARIANCE_IND VARCHAR2(1),
	REGEN_DELAY_OFFSET_YRS NUMBER(2,0),
	REGEN_OBLIGATION_IND VARCHAR2(1) NOT NULL ENABLE,
	NO_REGEN_EARLY_OFFSET_YRS NUMBER(2,0),
	NO_REGEN_LATE_OFFSET_YRS NUMBER(2,0),
	FREE_GROWING_EARLY_OFFSET_YRS NUMBER(2,0),
	FREE_GROWING_LATE_OFFSET_YRS NUMBER(2,0),
	AMENDMENT_RATIONALE_COMMENT VARCHAR2(2000),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
  CONSTRAINT SSUAMD_PK PRIMARY KEY (STOCKING_STANDARD_UNIT_ID) USING INDEX  ENABLE,
  CONSTRAINT AVCON_1080773726_REGEN_000 CHECK (REGEN_OBLIGATION_IND IN ('N', 'Y')) ENABLE
 );

CREATE TABLE THE.STOCKING_MILESTONE (
	STOCKING_STANDARD_UNIT_ID NUMBER(10,0),
	SILV_MILESTONE_TYPE_CODE VARCHAR2(3),
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	DECLARED_DATE DATE,
	DECLARED_USERID VARCHAR2(30),
	DECLARE_IND VARCHAR2(1),
	DECLARATION_SUBMITTED_DATE DATE,
	EARLY_OFFSET_YEARS NUMBER(2,0),
	LATE_OFFSET_YEARS NUMBER(2,0),
	DUE_EARLY_DATE DATE,
	DUE_LATE_DATE DATE,
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	EXTENT_FEASIBLE_DECLARED_IND VARCHAR2(1) DEFAULT 'N' ,
	CONSTRAINT SM_PK PRIMARY KEY (STOCKING_STANDARD_UNIT_ID,SILV_MILESTONE_TYPE_CODE),
	CONSTRAINT SYS_C00140760_SM_CT CHECK ("EXTENT_FEASIBLE_DECLARED_IND" IS NOT NULL),
	CONSTRAINT SYS_C0026482_SM_CT CHECK ("STOCKING_STANDARD_UNIT_ID" IS NOT NULL),
	CONSTRAINT SYS_C0026483_SM_CT CHECK ("SILV_MILESTONE_TYPE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0026484_SM_CT CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026485_SM_CT CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0026486_SM_CT CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C0026487_SM_CT CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C0026488_SM_CT CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX SM_DED_I ON THE.STOCKING_MILESTONE (DUE_EARLY_DATE);
CREATE INDEX SM_DLD_I ON THE.STOCKING_MILESTONE (DUE_LATE_DATE);

CREATE TABLE THE.FOREST_MGMT_UNIT (
  MGMT_SKEY NUMBER(10,0) NOT NULL ENABLE,
	MGMT_UNIT_TYPE_CODE VARCHAR2(1) NOT NULL ENABLE,
	MGMT_UNIT_ID VARCHAR2(4),
	DESCRIPTION VARCHAR2(100),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
	EFFECTIVE_DATE DATE NOT NULL ENABLE,
	EXPIRY_DATE DATE NOT NULL ENABLE,
	CONSTRAINT FMU_PK PRIMARY KEY (MGMT_SKEY) USING INDEX,
	CONSTRAINT FMU_UK1 UNIQUE (MGMT_UNIT_ID, MGMT_UNIT_TYPE_CODE)
);

CREATE TABLE THE.PROV_FOREST_USE (
	FOREST_FILE_ID VARCHAR2(10),
	FILE_STATUS_ST VARCHAR2(3),
	FILE_STATUS_DATE DATE,
	FILE_TYPE_CODE VARCHAR2(3),
	FOREST_REGION NUMBER(10,0),
	BCTS_ORG_UNIT NUMBER(10,0),
	SB_FUNDED_IND VARCHAR2(1) DEFAULT 'N' ,
	DISTRICT_ADMIN_ZONE VARCHAR2(4),
	MGMT_UNIT_TYPE VARCHAR2(1),
	MGMT_UNIT_ID VARCHAR2(4),
	REVISION_COUNT NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	FOREST_TENURE_GUID RAW(16) DEFAULT SYS_GUID() ,
	CONSTRAINT AVCON_1148331360_SB_FU_001 CHECK (
SB_FUNDED_IND IN ('N', 'Y')
),
	CONSTRAINT PFU_GUID_UK UNIQUE (FOREST_TENURE_GUID),
	CONSTRAINT PFU_PK PRIMARY KEY (FOREST_FILE_ID),
	CONSTRAINT PFU_SYS_C00111802 CHECK ("FOREST_TENURE_GUID" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012190 CHECK ("FOREST_FILE_ID" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012191 CHECK ("FOREST_REGION" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012192 CHECK ("SB_FUNDED_IND" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012193 CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012194 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012195 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012196 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT PFU_SYS_C0012197 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL)
);
CREATE INDEX PFU_FSC_FK_I ON THE.PROV_FOREST_USE (FILE_STATUS_ST);
CREATE INDEX PFU_FTCD_FK_I ON THE.PROV_FOREST_USE (FILE_TYPE_CODE);
CREATE INDEX PFU_I2 ON THE.PROV_FOREST_USE (FOREST_FILE_ID,FILE_TYPE_CODE,FILE_STATUS_ST);
CREATE INDEX PFU_OU_FK_I ON THE.PROV_FOREST_USE (FOREST_REGION);

CREATE TABLE THE.FOREST_FILE_CLIENT (
	FOREST_FILE_CLIENT_SKEY NUMBER(10,0),
	FOREST_FILE_ID VARCHAR2(10),
	CLIENT_NUMBER VARCHAR2(8),
	CLIENT_LOCN_CODE VARCHAR2(2),
	FOREST_FILE_CLIENT_TYPE_CODE VARCHAR2(1),
	LICENSEE_START_DATE DATE,
	LICENSEE_END_DATE DATE,
	REVISION_COUNT NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	CONSTRAINT FFC_CL_PK PRIMARY KEY (FOREST_FILE_CLIENT_SKEY),
	CONSTRAINT FFC_CL_UK1 UNIQUE (FOREST_FILE_ID,FOREST_FILE_CLIENT_TYPE_CODE,CLIENT_NUMBER,CLIENT_LOCN_CODE,LICENSEE_START_DATE),
	CONSTRAINT FFC_CL_UK2 UNIQUE (CLIENT_NUMBER,CLIENT_LOCN_CODE,FOREST_FILE_ID,FOREST_FILE_CLIENT_TYPE_CODE,LICENSEE_START_DATE),
	CONSTRAINT FFID_SYS_C0012731 CHECK ("FOREST_FILE_CLIENT_SKEY" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012732 CHECK ("FOREST_FILE_ID" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012733 CHECK ("CLIENT_NUMBER" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012734 CHECK ("CLIENT_LOCN_CODE" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012735 CHECK ("FOREST_FILE_CLIENT_TYPE_CODE" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012736 CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012737 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012738 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012739 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT FFID_SYS_C0012740 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL)
);
CREATE INDEX FFC_I2 ON THE.FOREST_FILE_CLIENT (FOREST_FILE_ID,FOREST_FILE_CLIENT_TYPE_CODE);

CREATE TABLE THE.CUT_BLOCK_CLIENT (
	CBLK_CLIENT_SKEY NUMBER(10,0),
	CB_SKEY NUMBER(10,0),
	CUT_BLOCK_CLIENT_TYPE_CODE VARCHAR2(1),
	LICENSEE_START_DATE DATE,
	LICENSEE_END_DATE DATE,
	CLIENT_LOCN_CODE VARCHAR2(2),
	CLIENT_NUMBER VARCHAR2(8),
	REVISION_COUNT NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	CONSTRAINT CBC_PK PRIMARY KEY (CBLK_CLIENT_SKEY),
	CONSTRAINT CBC_UK UNIQUE (CLIENT_NUMBER,CLIENT_LOCN_CODE,CB_SKEY,CUT_BLOCK_CLIENT_TYPE_CODE,LICENSEE_START_DATE),
	CONSTRAINT CBC_UK2 UNIQUE (CB_SKEY,CLIENT_NUMBER,CLIENT_LOCN_CODE,CUT_BLOCK_CLIENT_TYPE_CODE,LICENSEE_START_DATE),
	CONSTRAINT CBC_SYS_C0012759 CHECK ("CBLK_CLIENT_SKEY" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012760 CHECK ("CB_SKEY" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012761 CHECK ("CUT_BLOCK_CLIENT_TYPE_CODE" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012762 CHECK ("CLIENT_LOCN_CODE" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012764 CHECK ("CLIENT_NUMBER" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012766 CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012767 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012768 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012770 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT CBC_SYS_C0012772 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL)
);
CREATE INDEX CBC_CB_FK_I ON THE.CUT_BLOCK_CLIENT (CB_SKEY);
CREATE INDEX CBC_CL_FK_I ON THE.CUT_BLOCK_CLIENT (CLIENT_NUMBER,CLIENT_LOCN_CODE);

CREATE TABLE THE.CUT_BLOCK (
	CB_SKEY NUMBER(10,0),
	HVA_SKEY NUMBER(10,0),
	FOREST_FILE_ID VARCHAR2(10),
	CUTTING_PERMIT_ID VARCHAR2(3),
	TIMBER_MARK VARCHAR2(10),
	CUT_BLOCK_ID VARCHAR2(10),
	SP_EXEMPT_IND VARCHAR2(1) DEFAULT 'N' ,
	BLOCK_STATUS_DATE DATE,
	CUT_BLOCK_DESCRIPTION VARCHAR2(120),
	CUT_REGULATION_CODE VARCHAR2(3),
	BLOCK_STATUS_ST VARCHAR2(3),
	REFOREST_DECLARE_TYPE_CODE VARCHAR2(3),
	REVISION_COUNT NUMBER(5,0),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	IS_WASTE_ASSESSMENT_REQUIRED VARCHAR2(1) DEFAULT 'U' ,
	CUT_BLOCK_GUID RAW(16) DEFAULT SYS_GUID() ,
	FIRE_HARVESTING_REASON_CODE VARCHAR2(10),
	IS_UNDER_PARTITION_ORDER VARCHAR2(1),
	REPORTED_FIRE_DATE DATE,
	CONSTRAINT AVCON_1054232647_SP_EX_000 CHECK (
SP_EXEMPT_IND IN ('N', 'Y')
),
	CONSTRAINT CBLK_GUID_UK UNIQUE (CUT_BLOCK_GUID),
	CONSTRAINT CBLK_IS_WASTE_ASSESS_REQ_CK CHECK (IS_WASTE_ASSESSMENT_REQUIRED IN ('Y', 'N', 'U')),
	CONSTRAINT CBLK_PK PRIMARY KEY (CB_SKEY),
	CONSTRAINT CBLK_TM_FF_CB_UK UNIQUE (TIMBER_MARK,FOREST_FILE_ID,CUT_BLOCK_ID),
	CONSTRAINT CBLK_UK4 UNIQUE (HVA_SKEY,TIMBER_MARK,CUT_BLOCK_ID),
	CONSTRAINT CB_SYS_C00111793 CHECK ("CUT_BLOCK_GUID" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012353 CHECK ("CB_SKEY" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012356 CHECK ("FOREST_FILE_ID" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012359 CHECK ("CUT_BLOCK_ID" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012362 CHECK ("SP_EXEMPT_IND" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012365 CHECK ("BLOCK_STATUS_ST" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012368 CHECK ("REVISION_COUNT" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012371 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012373 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012374 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT CB_SYS_C0012375 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT CB_SYS_C0067185 CHECK ("IS_WASTE_ASSESSMENT_REQUIRED" IS NOT NULL)
);
CREATE INDEX CBLK1_I ON THE.CUT_BLOCK (FOREST_FILE_ID,CUTTING_PERMIT_ID,CUT_BLOCK_ID);
CREATE INDEX CBLK2_I ON THE.CUT_BLOCK (TIMBER_MARK,CUT_BLOCK_ID);
CREATE INDEX CBLK_FF_TM_CB_I ON THE.CUT_BLOCK (FOREST_FILE_ID,TIMBER_MARK,CUT_BLOCK_ID);
CREATE INDEX CBLK_I ON THE.CUT_BLOCK (TIMBER_MARK,FOREST_FILE_ID,CUTTING_PERMIT_ID,CUT_BLOCK_ID);

CREATE TABLE THE.OPEN_VIEWABLE_CATEGORY (
	OPEN_CATEGORY_CODE VARCHAR2(7),
	OPENING_STATUS_CODE VARCHAR2(3),
	VIEWABLE_IND VARCHAR2(1) DEFAULT 'N' ,
	CONSTRAINT AVCON_1215562930_VIEWA_000 CHECK (VIEWABLE_IND IN ('Y', 'N')),
	CONSTRAINT OVC_PK PRIMARY KEY (OPEN_CATEGORY_CODE),
	CONSTRAINT SYS_C0032241 CHECK ("OPEN_CATEGORY_CODE" IS NOT NULL),
	CONSTRAINT SYS_C0032243 CHECK ("VIEWABLE_IND" IS NOT NULL)
);

CREATE TABLE THE.FOR_CLIENT_LINK (
	FOR_CLIENT_LINK_SKEY NUMBER(10,0),
	FOREST_FILE_ID VARCHAR2(10),
	CUTTING_PERMIT_ID VARCHAR2(3),
	CUT_BLOCK_ID VARCHAR2(10),
	FILE_CLIENT_TYPE VARCHAR2(1),
	CLIENT_NUMBER VARCHAR2(8),
	CLIENT_LOCN_CODE VARCHAR2(2),
	LICENSEE_START_DT DATE,
	LICENSEE_END_DATE DATE,
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT FCL_PK PRIMARY KEY (FOR_CLIENT_LINK_SKEY),
	CONSTRAINT FCL_UK UNIQUE (FOREST_FILE_ID,CUTTING_PERMIT_ID,CUT_BLOCK_ID,FILE_CLIENT_TYPE,CLIENT_NUMBER,CLIENT_LOCN_CODE,LICENSEE_START_DT),
	CONSTRAINT SYS_C009505 CHECK ("FOR_CLIENT_LINK_SKEY" IS NOT NULL),
	CONSTRAINT SYS_C009506 CHECK ("FOREST_FILE_ID" IS NOT NULL),
	CONSTRAINT SYS_C009507 CHECK ("FILE_CLIENT_TYPE" IS NOT NULL),
	CONSTRAINT SYS_C009508 CHECK ("CLIENT_NUMBER" IS NOT NULL),
	CONSTRAINT SYS_C009509 CHECK ("CLIENT_LOCN_CODE" IS NOT NULL),
	CONSTRAINT SYS_C009510 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C009511 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C009512 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C009513 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C009514 CHECK ("REVISION_COUNT" IS NOT NULL)
);
CREATE INDEX FCL_I1 ON THE.FOR_CLIENT_LINK (FOREST_FILE_ID);

CREATE TABLE THE.TIMBER_MARK (
  TIMBER_MARK VARCHAR2(6) NOT NULL ENABLE,
	FOREST_FILE_ID VARCHAR2(10) NOT NULL ENABLE,
	CUTTING_PERMIT_ID VARCHAR2(3) NOT NULL ENABLE,
	FOREST_DISTRICT NUMBER(10,0) NOT NULL ENABLE,
	GEOGRAPHIC_DISTRCT NUMBER(10,0) NOT NULL ENABLE,
	CASCADE_SPLIT_CODE VARCHAR2(1),
	QUOTA_TYPE_CODE VARCHAR2(1),
	DECIDUOUS_IND VARCHAR2(1) DEFAULT 'N' NOT NULL ENABLE,
	CATASTROPHIC_IND VARCHAR2(1) DEFAULT NULL,
	CROWN_GRANTED_IND VARCHAR2(1) DEFAULT 'N' NOT NULL ENABLE,
	CRUISE_BASED_IND VARCHAR2(1) DEFAULT 'N' NOT NULL ENABLE,
	CERTIFICATE VARCHAR2(6),
	HDBS_TIMBER_MARK VARCHAR2(7),
	VM_TIMBER_MARK VARCHAR2(6),
	TENURE_TERM NUMBER(5,0),
	BCAA_FOLIO_NUMBER VARCHAR2(23),
	ACTIVATED_USERID VARCHAR2(30),
	AMENDED_USERID VARCHAR2(30),
	DISTRICT_ADMN_ZONE VARCHAR2(4),
	GRANTED_ACQRD_DATE DATE,
	LANDS_REGION VARCHAR2(1),
	CROWN_GRANTED_ACQ_DESC VARCHAR2(240),
	MARK_STATUS_ST VARCHAR2(3),
	MARK_STATUS_DATE DATE,
	MARK_AMEND_DATE DATE,
	MARK_APPL_DATE DATE,
	MARK_CANCEL_DATE DATE,
	MARK_EXTEND_DATE DATE,
	MARK_EXTEND_RSN_CD VARCHAR2(1),
	MARK_EXTEND_COUNT NUMBER(10,0),
	MARK_ISSUE_DATE DATE,
	MARK_EXPIRY_DATE DATE,
	MARKNG_INSTRMNT_CD VARCHAR2(1),
	MARKING_METHOD_CD VARCHAR2(1),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
	SMALL_PATCH_SALVAGE_IND VARCHAR2(1) DEFAULT 'N' NOT NULL ENABLE,
	SALVAGE_TYPE_CODE VARCHAR2(3),
	 CONSTRAINT AVCON_1054232647_CRUIS_000 CHECK (CRUISE_BASED_IND IN ('N', 'Y')) ENABLE,
	 CONSTRAINT AVCON_1054232647_CROWN_001 CHECK (CROWN_GRANTED_IND IN ('N', 'Y')) ENABLE,
	 CONSTRAINT AVCON_1054232647_CATAS_000 CHECK (CATASTROPHIC_IND IN ('N', 'Y')) ENABLE,
	 CONSTRAINT AVCON_1054232647_DECID_000 CHECK (DECIDUOUS_IND IN ('N', 'Y')) ENABLE,
	 CONSTRAINT TM_PK PRIMARY KEY (TIMBER_MARK) USING INDEX
);

CREATE TABLE THE.HARVESTING_AUTHORITY (
  HVA_SKEY NUMBER(10,0) NOT NULL ENABLE,
	FOREST_FILE_ID VARCHAR2(10) NOT NULL ENABLE,
	CUTTING_PERMIT_ID VARCHAR2(3),
	HARVESTING_AUTHORITY_ID VARCHAR2(30),
	FOREST_DISTRICT NUMBER(10,0) NOT NULL ENABLE,
	DISTRICT_ADMN_ZONE VARCHAR2(4),
	GEOGRAPHIC_DISTRICT NUMBER(10,0) NOT NULL ENABLE,
	MGMT_UNIT_ID VARCHAR2(4),
	MGMT_UNIT_TYPE_CODE VARCHAR2(1),
	LICENCE_TO_CUT_CODE VARCHAR2(2),
	HARVEST_TYPE_CODE VARCHAR2(1) NOT NULL ENABLE,
	HARVEST_AUTH_STATUS_CODE VARCHAR2(3),
	TENURE_TERM NUMBER(5,0),
	STATUS_DATE DATE,
	ISSUE_DATE DATE,
	EXPIRY_DATE DATE,
	EXTEND_DATE DATE,
	EXTEND_COUNT NUMBER(10,0),
	HARVEST_AUTH_EXTEND_REAS_CODE VARCHAR2(1),
	QUOTA_TYPE_CODE VARCHAR2(1),
	CROWN_LANDS_REGION_CODE VARCHAR2(1),
	SALVAGE_TYPE_CODE VARCHAR2(3),
	CASCADE_SPLIT_CODE VARCHAR2(1),
	CATASTROPHIC_IND VARCHAR2(1),
	CROWN_GRANTED_IND VARCHAR2(1) NOT NULL ENABLE,
	CRUISE_BASED_IND VARCHAR2(1) NOT NULL ENABLE,
	DECIDUOUS_IND VARCHAR2(1) NOT NULL ENABLE,
	BCAA_FOLIO_NUMBER VARCHAR2(23),
	LOCATION VARCHAR2(100),
	HIGHER_LEVEL_PLAN_REFERENCE VARCHAR2(30),
	HARVEST_AREA NUMBER(11,4),
	RETIREMENT_DATE DATE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	IS_WASTE_ASSESSMENT_REQUIRED VARCHAR2(1) DEFAULT 'U' NOT NULL ENABLE,
	IS_CP_EXTENSN_APPL_FEE_WAIVED VARCHAR2(1) DEFAULT 'U' NOT NULL ENABLE,
	IS_CP_EXTENSION_APPL_FEE_PAID VARCHAR2(1) DEFAULT 'U' NOT NULL ENABLE,
	IS_WITHIN_FIBRE_RECOVERY_ZONE VARCHAR2(1) DEFAULT 'U' NOT NULL ENABLE,
	HARVESTING_AUTHORITY_GUID RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE,
  CONSTRAINT HVA_IS_WASTE_ASSESS_REQ_CK CHECK (IS_WASTE_ASSESSMENT_REQUIRED IN ('Y', 'N', 'U')) ENABLE,
  CONSTRAINT AVCON_1148331360_DECID_000 CHECK (DECIDUOUS_IND IN ('N', 'Y')) ENABLE,
  CONSTRAINT HVA_GUID_UK UNIQUE (HARVESTING_AUTHORITY_GUID) USING INDEX  ENABLE,
  CONSTRAINT AVCON_1148331360_CROWN_000 CHECK (CROWN_GRANTED_IND IN ('N', 'Y')) ENABLE,
  CONSTRAINT AVCON_1148331360_CRUIS_000 CHECK (CRUISE_BASED_IND IN ('N', 'Y')) ENABLE,
  CONSTRAINT AVCON_1148331360_CATAS_000 CHECK (CATASTROPHIC_IND IN ('N', 'Y')) ENABLE,
  CONSTRAINT HVA_IS_CP_EXT_APPL_FEE_WA_CK CHECK (IS_CP_EXTENSN_APPL_FEE_WAIVED IN ('Y', 'N', 'U')) ENABLE,
  CONSTRAINT HVA_IS_WITHIN_FRZ_CK CHECK (IS_WITHIN_FIBRE_RECOVERY_ZONE IN ('Y', 'N', 'U')) ENABLE,
  CONSTRAINT HVA_IS_CP_EXT_APPL_FEE_PA_CK CHECK (IS_CP_EXTENSION_APPL_FEE_PAID IN ('Y', 'N', 'U')) ENABLE,
  CONSTRAINT HVA_PK PRIMARY KEY (HVA_SKEY) USING INDEX
);

CREATE TABLE THE.HAULING_AUTHORITY (
  TIMBER_MARK VARCHAR2(6) NOT NULL ENABLE,
	FOREST_FILE_ID VARCHAR2(10),
	MARKING_METHOD_CODE VARCHAR2(1),
	MARKING_INSTRUMENT_CODE VARCHAR2(1),
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	HAULING_AUTHORITY_GUID RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE,
  CONSTRAINT HAA_GUID_UK UNIQUE (HAULING_AUTHORITY_GUID) USING INDEX  ENABLE,
  CONSTRAINT HAA_PK PRIMARY KEY (TIMBER_MARK) USING INDEX  ENABLE
);

CREATE TABLE THE.RESULTS_AUDIT_DETAIL (
  RESULTS_AUDIT_DETAIL_ID NUMBER(12,0) NOT NULL ENABLE,
	RESULTS_AUDIT_EVENT_ID NUMBER(10,0) NOT NULL ENABLE,
	BUSINESS_IDENTIFIER VARCHAR2(30),
	TABLE_NAME VARCHAR2(30) NOT NULL ENABLE,
	COLUMN_NAME VARCHAR2(30) NOT NULL ENABLE,
	OLD_VALUE VARCHAR2(250),
	NEW_VALUE VARCHAR2(250),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
  CONSTRAINT RAD_PK PRIMARY KEY (RESULTS_AUDIT_DETAIL_ID) USING INDEX
)  ENABLE ROW MOVEMENT;

CREATE TABLE THE.CORP_CAPTURE_METHOD (
  CAPTURE_METHOD_CODE VARCHAR2(90) NOT NULL ENABLE,
	DESCRIPTION VARCHAR2(150) NOT NULL ENABLE,
	EFFECTIVE_DATE DATE NOT NULL ENABLE,
	EXPIRY_DATE DATE NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	CONSTRAINT CCM_PK PRIMARY KEY (CAPTURE_METHOD_CODE) USING INDEX
);

CREATE TABLE THE.STANDARDS_REGIME (
  STANDARDS_REGIME_ID NUMBER(10,0) NOT NULL ENABLE,
	STANDARDS_REGIME_NAME VARCHAR2(50),
	STANDARDS_REGIME_STATUS_CODE VARCHAR2(3) NOT NULL ENABLE,
	SILV_STATUTE_CODE VARCHAR2(3),
	STANDARDS_OBJECTIVE VARCHAR2(50),
	GEOGRAPHIC_DESCRIPTION VARCHAR2(50),
	MOF_DEFAULT_STANDARD_IND VARCHAR2(1) DEFAULT 'N' NOT NULL ENABLE,
	REGEN_DELAY_OFFSET_YRS NUMBER(2,0),
	REGEN_OBLIGATION_IND VARCHAR2(1) NOT NULL ENABLE,
	NO_REGEN_EARLY_OFFSET_YRS NUMBER(2,0),
	NO_REGEN_LATE_OFFSET_YRS NUMBER(2,0),
	FREE_GROWING_EARLY_OFFSET_YRS NUMBER(2,0),
	FREE_GROWING_LATE_OFFSET_YRS NUMBER(2,0),
	APPROVED_BY_USERID VARCHAR2(30),
	APPROVED_DATE DATE,
	SUBMITTED_BY_USERID VARCHAR2(30),
	SUBMITTED_DATE DATE,
	EFFECTIVE_DATE DATE,
	EXPIRY_DATE DATE,
	ADDITIONAL_STANDARDS VARCHAR2(4000),
	REJECT_NOTE VARCHAR2(2000),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
  CONSTRAINT SR_PK PRIMARY KEY (STANDARDS_REGIME_ID) USING INDEX
);

CREATE TABLE THE.FOREST_COVER (
  FOREST_COVER_ID NUMBER(10,0) NOT NULL ENABLE,
	OPENING_ID NUMBER(10,0) NOT NULL ENABLE,
	STOCKING_STANDARD_UNIT_ID NUMBER(10,0),
	SILV_POLYGON_NO VARCHAR2(30) NOT NULL ENABLE,
	SILV_POLYGON_AREA NUMBER(7,1) NOT NULL ENABLE,
	SILV_POLYGON_NET_AREA NUMBER(7,1) NOT NULL ENABLE,
	STOCKING_CLASS_CODE VARCHAR2(1),
	STOCKING_STATUS_CODE VARCHAR2(3),
	STOCKING_TYPE_CODE VARCHAR2(3),
	REFERENCE_YEAR NUMBER(4,0) NOT NULL ENABLE,
	REENTRY_YEAR NUMBER(4,0),
	SITE_CLASS_CODE VARCHAR2(1),
	SITE_INDEX NUMBER(5,0),
	SITE_INDEX_SOURCE_CODE VARCHAR2(1),
	SILV_RESERVE_CODE VARCHAR2(1),
	SILV_RESERVE_OBJECTIVE_CODE VARCHAR2(3),
	TREE_SPECIES_CODE VARCHAR2(8),
	TREE_COVER_PATTERN_CODE VARCHAR2(1),
	RESULTS_SUBMISSION_ID NUMBER(10,0),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
	CONSTRAINT FC3_PK PRIMARY KEY (FOREST_COVER_ID) USING INDEX
)  ENABLE ROW MOVEMENT;

  CREATE TABLE THE.STORAGE_FILES (
  GROUP_NAME_CD VARCHAR2(10) NOT NULL ENABLE,
	NAME VARCHAR2(60) NOT NULL ENABLE,
	LOCAL_DIRECTORY VARCHAR2(255) NOT NULL ENABLE,
	TILE_SIZE VARCHAR2(11) NOT NULL ENABLE,
	DATA_MATURITY_CD CHAR(1) NOT NULL ENABLE,
	STEWARD_ORG_UNIT_CD VARCHAR2(6),
	UPDATE_RESPONSIBILITY VARCHAR2(255),
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	ENTRY_USERID VARCHAR2(32) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(32) NOT NULL ENABLE,
	DESCRIPTION VARCHAR2(2000) NOT NULL ENABLE,
	SPECIAL_CONCERNS VARCHAR2(2000),
	DATA_AVAILABILITY VARCHAR2(2000),
	CONSTRAINT FILE_PK PRIMARY KEY (GROUP_NAME_CD) USING INDEX
);

CREATE TABLE THE.FEATURE_CLASSES (
  FEATURE_CLASS_SKEY NUMBER(10,0) NOT NULL ENABLE,
	GROUP_NAME_CD VARCHAR2(10) NOT NULL ENABLE,
	NAME VARCHAR2(60) NOT NULL ENABLE,
	FEATURE_TYPE_CD VARCHAR2(10) NOT NULL ENABLE,
	DATA_MATURITY_CD CHAR(1) NOT NULL ENABLE,
	OVERLAPPING_FEATURE_IND CHAR(1) NOT NULL ENABLE,
	SPAN_TILE_IND CHAR(1) NOT NULL ENABLE,
	DERIVED_DATA_IND CHAR(1) NOT NULL ENABLE,
	MANDATORY_METADATA_IND CHAR(1) NOT NULL ENABLE,
	CUSTODIAN_ORG_UNIT_CD VARCHAR2(6),
	DATA_STANDARDS_MANAGER VARCHAR2(60),
	STEWARD_ORG_UNIT_CD VARCHAR2(6),
	EXTENDED_ORG_UNIT_CD VARCHAR2(6),
	EXTENDED_DATA_CONTACT VARCHAR2(60),
	DISCIPLINE_STANDARD_CD VARCHAR2(4),
	COLLECTION_PROCESS VARCHAR2(255),
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	ENTRY_USERID VARCHAR2(32) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(32) NOT NULL ENABLE,
	DESCRIPTION VARCHAR2(2000) NOT NULL ENABLE,
	COMMENTS VARCHAR2(2000),
	CONSTRAINT FEATUR_CLS_PK PRIMARY KEY (FEATURE_CLASS_SKEY) USING INDEX
);

CREATE TABLE THE.FOREST_COVER_GEOMETRY (
  FOREST_COVER_ID NUMBER(10,0) NOT NULL ENABLE,
	GEOMETRY MDSYS.SDO_GEOMETRY  NOT NULL ENABLE,
	FEATURE_AREA NUMBER(11,4) NOT NULL ENABLE,
	FEATURE_PERIMETER NUMBER(11,4) NOT NULL ENABLE,
	CAPTURE_METHOD_CODE VARCHAR2(30),
	DATA_SOURCE_CODE VARCHAR2(10),
	FEATURE_CLASS_SKEY NUMBER(10,0) NOT NULL ENABLE,
	OBSERVATION_DATE DATE,
	DATA_QUALITY_COMMENT VARCHAR2(255),
	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
  CONSTRAINT FCG_PK PRIMARY KEY (FOREST_COVER_ID) USING INDEX
)
 VARRAY GEOMETRY.SDO_ELEM_INFO STORE AS SECUREFILE LOB
 VARRAY GEOMETRY.SDO_ORDINATES STORE AS SECUREFILE LOB;

 CREATE TABLE THE.SILVICULTURE_PROJECT (
  SILVICULTURE_PROJECT_ID NUMBER(10,0) NOT NULL ENABLE,
 	SILV_BASE_CODE VARCHAR2(2) NOT NULL ENABLE,
 	FISCAL_YEAR NUMBER(4,0) NOT NULL ENABLE,
 	ORG_UNIT_NO NUMBER(10,0) NOT NULL ENABLE,
 	PROJECT_SEQUENCE VARCHAR2(4) NOT NULL ENABLE,
 	PROJECT_LOCATION VARCHAR2(30),
 	SILV_PROJECT_STATUS_CODE VARCHAR2(3) NOT NULL ENABLE,
 	CLIENT_NUMBER VARCHAR2(8),
 	START_DATE DATE NOT NULL ENABLE,
 	VIEW_DATE DATE,
 	COORDINATOR_USERID VARCHAR2(30),
 	OVERHEAD_COST NUMBER(9,2),
 	CREW_CONTRACT_HIRE_CODE VARCHAR2(1),
 	DIST_ADMIN_ZONE VARCHAR2(2),
 	UNIT_BID_CODE VARCHAR2(3) NOT NULL ENABLE,
 	ENTRY_USERID VARCHAR2(30) NOT NULL ENABLE,
 	ENTRY_TIMESTAMP DATE NOT NULL ENABLE,
 	UPDATE_USERID VARCHAR2(30) NOT NULL ENABLE,
 	UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
 	REVISION_COUNT NUMBER(5,0) NOT NULL ENABLE,
 	CONSTRAINT PROJ_PK PRIMARY KEY (SILVICULTURE_PROJECT_ID) USING INDEX
);

CREATE TABLE THE.OPENING_COMMENT_LINK (
	OPENING_ID NUMBER(10,0),
	SILVICULTURE_COMMENT_ID NUMBER(10,0),
	CONSTRAINT OCL_PK PRIMARY KEY (OPENING_ID,SILVICULTURE_COMMENT_ID),
	CONSTRAINT SYS_C009143 CHECK ("OPENING_ID" IS NOT NULL),
	CONSTRAINT SYS_C009145 CHECK ("SILVICULTURE_COMMENT_ID" IS NOT NULL)
);

CREATE TABLE THE.SILVICULTURE_COMMENT (
	SILVICULTURE_COMMENT_ID NUMBER(10,0),
	COMMENT_DATE DATE,
	SILV_COMMENT_SOURCE_CODE VARCHAR2(4),
	SILV_COMMENT_TYPE_CODE VARCHAR2(8),
	COMMENT_TEXT VARCHAR2(2000),
	ENTRY_USERID VARCHAR2(30),
	ENTRY_TIMESTAMP DATE,
	UPDATE_USERID VARCHAR2(30),
	UPDATE_TIMESTAMP DATE,
	REVISION_COUNT NUMBER(5,0),
	CONSTRAINT SILVC_PK PRIMARY KEY (SILVICULTURE_COMMENT_ID),
	CONSTRAINT SYS_C008456 CHECK ("SILVICULTURE_COMMENT_ID" IS NOT NULL),
	CONSTRAINT SYS_C008460 CHECK ("COMMENT_DATE" IS NOT NULL),
	CONSTRAINT SYS_C008461 CHECK ("SILV_COMMENT_SOURCE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C008462 CHECK ("SILV_COMMENT_TYPE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C008463 CHECK ("COMMENT_TEXT" IS NOT NULL),
	CONSTRAINT SYS_C008464 CHECK ("ENTRY_USERID" IS NOT NULL),
	CONSTRAINT SYS_C008465 CHECK ("ENTRY_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C008466 CHECK ("UPDATE_USERID" IS NOT NULL),
	CONSTRAINT SYS_C008467 CHECK ("UPDATE_TIMESTAMP" IS NOT NULL),
	CONSTRAINT SYS_C008468 CHECK ("REVISION_COUNT" IS NOT NULL)
);

CREATE TABLE THE.SILV_COMMENT_XREF (
	SILV_COMMENT_SOURCE_CODE VARCHAR2(4),
	SILV_COMMENT_TYPE_CODE VARCHAR2(8),
	COMMENT_ORDER_NO NUMBER(5,0),
	CONSTRAINT SCX_PK PRIMARY KEY (SILV_COMMENT_TYPE_CODE,SILV_COMMENT_SOURCE_CODE),
	CONSTRAINT SYS_C008834 CHECK ("SILV_COMMENT_SOURCE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C008835 CHECK ("SILV_COMMENT_TYPE_CODE" IS NOT NULL),
	CONSTRAINT SYS_C008836 CHECK ("COMMENT_ORDER_NO" IS NOT NULL)
);