--------------------------------------------------------
--  File created - Wednesday-September-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table DI_ACTIVITY_MATRIX
--------------------------------------------------------

  CREATE TABLE "STORETW"."DI_ACTIVITY_MATRIX" 
   (	"PK_ISN" NUMBER(12,0), 
	"MATRIX_CODE" VARCHAR2(4 BYTE), 
	"MATRIX_NAME" VARCHAR2(256 BYTE), 
	"MATRIX_DESCRIPTION" VARCHAR2(120 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 90 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETDATA_STORMODP" ;

   COMMENT ON COLUMN "STORETW"."DI_ACTIVITY_MATRIX"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_ACTIVITY_MATRIX.';
   COMMENT ON COLUMN "STORETW"."DI_ACTIVITY_MATRIX"."MATRIX_CODE" IS 'A cryptic code which represents the sampled matrix.  Used as a shorthand or abbreviation to represent the Sampled Matrix in batch data update runs. ';
   COMMENT ON COLUMN "STORETW"."DI_ACTIVITY_MATRIX"."MATRIX_NAME" IS 'The short name of the Sample Matrix. Used in populating the drop down list on data entry windows.';
   COMMENT ON COLUMN "STORETW"."DI_ACTIVITY_MATRIX"."MATRIX_DESCRIPTION" IS 'Full description or definition of the sampled matrix.';
   COMMENT ON TABLE "STORETW"."DI_ACTIVITY_MATRIX"  IS 'Activity matrix dimension table';
REM INSERTING into STORETW.DI_ACTIVITY_MATRIX
SET DEFINE OFF;
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (1,'AQ','Air QC Matrix','Air Quality Control Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (2,'AE','Air, Vapor Well Effluent','Air, Vapor Extraction Well Effluent');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3,'AA','Ambient Air','Ambient Air');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (4,'LA','Aqueous Phase/Sample','Aqueous Phase of a Multiple Phase Liquid or Solid Sample');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (5,'SB','Bentonite','Bentonite');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (6,'SP','Casing (various)','Casing (PVC, Stainless Steel, Cast Iron, Iron Piping, etc.)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (7,'SC','Cement','Cement');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (8,'CA','Cinder-Ash','Cinder-Ash');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (9,'WM','Disturbed Water','Disturbed Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (10,'DG','Dredged Material','Dredged Material');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (11,'DC','Drill Cuttings','Drill Cuttings');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (12,'WA','Drill Cuttings, Aqueous','Drill Cuttings, Aqueous Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (13,'SD','Drill Cuttings, Solid','Drill Cuttings, Solid Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (14,'AD','Drilling Air','Drilling Air');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (15,'LD','Drilling Fluid','Drilling Fluid');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (16,'WC','Drilling Water','Drilling Water (Used for Well Construction)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (17,'WP','Drinking Water','Drinking Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (18,'LU','Elutriate','Elutriate extracted from porous material');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (19,'WH','Equipment Wash Water','Equipment Wash Water, i.e., Water used for Washing');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (20,'WE','Estuary','Estuary');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (21,'SF','Filter Sandpack','Filter Sandpack');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (22,'CF','Fly Ash Cinder','Fly Ash Cinder');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (23,'FL','Forest Litter','Forest Litter');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (24,'GE','Gaseous Effluent','Gaseous Effluent (Stack Gas)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (25,'WG','Ground Water','Ground Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (26,'MH','Haz. Multiphase Waste','Hazardous Multiple Phase Waste');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (27,'GL','Headspace, Liquid Sample','Headspace of Liquid Sample');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (28,'WL','Leachate','Leachate');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (29,'LH','Liq Waste<.5% Dry Solids','Free-Flowing, or Liquid Waste Containing Less Than 0.5% Dry Solids');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (30,'LC','Liquid Condensate','Liquid Condensate');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (31,'LE','Liquid Emulsion','Liquid Emulsion');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (32,'LV','Liquid-Vadose Zone','Liquid from Vadose Zone');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (33,'SN','Misc. Solid Materials','Miscellaneous Solid Materials - Building Materials');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (34,'LM','Multiphase Liquid Sample','Multiple Phase Liquid Waste Sample');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (35,'WO','Ocean Water','Ocean Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (36,'OIL','Oil_1','Oil_1');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (37,'LO','Organic Liquid','Organic Liquid');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (38,'PL','Plant','Plant');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (39,'LF','Product on GW Table','Floating/Free Product on Groundwater Table');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (40,'RK','Rock/Cobbles/Gravel','Rock/Cobbles/Gravel');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (41,'SS','Scrapings','Scrapings');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (42,'SL','Sludge','Sludge');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (43,'GS','Soil Gas','Soil Gas');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (44,'SQ','Soil/Solid QC Matrix','Soil/Solid Quality Control Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (45,'SH','Sol Waste>.5% Dry Solids','Solid Waste Containing greater than or equal to 0.5% Dry Solids');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (46,'SM','Solid Filter Material','Water Filter (Solid Material used to filter Water)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (47,'ST','Solid Waste','Solid Waste');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (48,'WZ','Special Water QC Matrix','Special Water Quality Control Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (49,'RW','Stormwater','Stormwater, runoff, or collected precipitation');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (50,'SI','Subsurface Soil','Subsurface Soil');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (51,'SO','Surface Soil','Surface Soil');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (52,'WS','Surface Water','Surface Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (53,'SE','Surface Water Sediment','Sediment (Associated with Surface Water)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (54,'SU','Suspended Sediment','Suspended Sediment ');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (55,'SW','Swab or Wipe','Swab or Wipe');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (56,'U','Unknown','Unknown');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (57,'WW','Waste Water','Waste Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (58,'W','Water','Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (59,'SR','Water Filter Residue','Water Filter Residue (Solid that gets filtered out of Water)');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (60,'WG','Water Gas','Water Gas, gas in water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (61,'WQ','Water QC Matrix','Water Quality Control Matrix');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (62,'WR','Water Undifferentiated','Undifferentiated Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (63,'WV','Water-Vadose Zone','Water From Vadose Zone');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (64,'WD','Well Development Water','Well Development Water');
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (101,null,'Groundwater',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (102,null,'Finished Water',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (103,null,'Municipal Waste',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (104,null,'Industrial Waste',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (105,null,'Septic Effluent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (106,null,'Industrial Effluent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (107,null,'Const. Material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (108,null,'Dry Fall Material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (109,null,'Wet Fall Material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (110,null,'Stack Gases',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (111,null,'Indoor Air',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (112,null,'Oil/Oily Sludge',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (113,null,'Filter Residue',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (114,null,'Wipe',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (115,null,'Subsurface Soil/Sediment',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (116,null,'Surface Soil/Sediment',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (117,null,'Sieved Sediment',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (118,null,'UnSieved Sediment',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (351,null,'Lake Sediment',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (681,null,'Borrow Soil, Waste Rock, and Protore material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (484,null,'Interstitial Water',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3641,null,'Bottom material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3642,null,'Core material',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3643,null,'Solids',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3644,null,'Borehole cuttings',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3645,null,'Air moisture',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3646,null,'Untreated water supply',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3647,null,'Canopy water',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3648,null,'Landfill effluent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3649,null,'Hyporheic zone',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3650,null,'Soil moisture',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3651,null,'Treated water supply',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (1231,null,'Wastewater Treatment Plant Effluent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (1232,null,'Wastewater Treatment Plant Influent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (1233,null,'Rainwater',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (1234,null,'Snowmelt',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (2511,null,'Municipal Sewage Effluent',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (2512,null,'Mine Tailings Pond',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (3721,null,'Bulk Deposition',null);
Insert into STORETW.DI_ACTIVITY_MATRIX (PK_ISN,MATRIX_CODE,MATRIX_NAME,MATRIX_DESCRIPTION) values (4341,null,'Pore water',null);
--------------------------------------------------------
--  DDL for Index IACT_MATRIX01
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."IACT_MATRIX01" ON "STORETW"."DI_ACTIVITY_MATRIX" (UPPER("MATRIX_NAME")) 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  DDL for Index PK_DI_ACTIVITY_MATRIX
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_DI_ACTIVITY_MATRIX" ON "STORETW"."DI_ACTIVITY_MATRIX" ("PK_ISN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table DI_ACTIVITY_MATRIX
--------------------------------------------------------

  ALTER TABLE "STORETW"."DI_ACTIVITY_MATRIX" ADD CONSTRAINT "PK_DI_ACTIVITY_MATRIX" PRIMARY KEY ("PK_ISN")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP"  ENABLE;
