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

  CREATE TABLE "STORETW"."LU_CHARGRPTYPE" 
   (	"PK_ISN" NUMBER, 
	"CHARACTERISTIC_GROUP_TYPE" VARCHAR2(256 CHAR), 
	"DESCRIPTION" VARCHAR2(4000 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 163840 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"."LU_CHARGRPTYPE"."PK_ISN" IS 'WQP Characteristic group type lookup table primary key';
   COMMENT ON COLUMN "STORETW"."LU_CHARGRPTYPE"."CHARACTERISTIC_GROUP_TYPE" IS 'WQP Characteristic group type short names.';
   COMMENT ON COLUMN "STORETW"."LU_CHARGRPTYPE"."DESCRIPTION" IS 'Water Quality Portal (NWIS parameter group) Characteristic group type description.';
   COMMENT ON TABLE "STORETW"."LU_CHARGRPTYPE"  IS 'Characteristic Group Type lookup table';
REM INSERTING into STORETW.LU_CHARGRPTYPE
SET DEFINE OFF;
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (17,'Habitat','Habitat related characteristics (**RETIRED**)');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (18,'Sediment','Physical sediment-related constituents, including suspended sediment and bedload sediment.');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (19,'Toxicity','Toxicity-test measurements.');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (1,'Biological','Biological characteristics');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (2,'Information','Habitat and Assessment related characteristics');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (3,'Inorganics, Major, Metals','Major metallic cations (including sodium, calcium, magnesium, and potassium)');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (4,'Inorganics, Major, Non-metals','Major non-metallic anions (including chloride, sulfate, and alkalinity related)');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (5,'Inorganics, Minor, Metals','Trace metal cations or metal-based compounds');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (6,'Inorganics, Minor, Non-metals','Trace non-metallic elements or non-metallic based compounds');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (7,'Microbiological','Microbiologicals');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (8,'Not Assigned','Not Assigned');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (9,'Nutrient','Nutrients');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (10,'Organics, Other','Organics, others');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (11,'Organics, PCBs','PCBs');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (12,'Organics, Pesticide','Pesticides');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (13,'Physical','Physicals characteristics');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (14,'Population/Community','Taxanomic');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (15,'Radiochemical','Radioactive isotopes');
Insert into STORETW.LU_CHARGRPTYPE (PK_ISN,CHARACTERISTIC_GROUP_TYPE,DESCRIPTION) values (16,'Stable Isotopes','Isotopic constituents that are stable and not radioactive in nature, including isotope ratios');
--------------------------------------------------------
--  DDL for Index ICHARGRPTYPE01
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."ICHARGRPTYPE01" ON "STORETW"."LU_CHARGRPTYPE" ("CHARACTERISTIC_GROUP_TYPE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 655360 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_CHARGRPTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_CHARGRPTYPE" ON "STORETW"."LU_CHARGRPTYPE" ("PK_ISN") 
  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" ;
