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

  CREATE TABLE "STORETW"."LU_ESTRY_SECONDARY" 
   (	"PK_ISN" NUMBER(12,0), 
	"SECONDARY_ESTUARY" VARCHAR2(30 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 90 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 10485760 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_ESTRY_SECONDARY"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_ESTRY_SECONDARY.';
   COMMENT ON COLUMN "STORETW"."LU_ESTRY_SECONDARY"."SECONDARY_ESTUARY" IS 'seconary estuary name';
   COMMENT ON TABLE "STORETW"."LU_ESTRY_SECONDARY"  IS 'secondary estuary lookup table';
REM INSERTING into STORETW.LU_ESTRY_SECONDARY
SET DEFINE OFF;
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (1,'Agua Hedionda Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (2,'Alligator River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (3,'Alsea River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (4,'Anacostia River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (5,'Apalachicola River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (6,'Arcata Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (7,'Ashepoo River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (8,'Assateague Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (9,'Back River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (10,'Baker Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (11,'Batchelor Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (12,'Bay River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (13,'Bayou Grande');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (14,'Bayou Texar');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (15,'Beardslee Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (16,'Big River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (17,'Biloxi Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (18,'Bohemia River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (19,'Bolinas Lagoon');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (20,'Bradbury Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (21,'Breton Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (22,'Catching Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (23,'Cathlamet Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (24,'Chester River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (25,'Choctawhatchee River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (26,'Choptank River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (27,'Chowan River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (28,'Churn Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (29,'Clatskanie River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (30,'Cohansey Cove');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (31,'Combahee River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (32,'Cooper River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (33,'Coos River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (34,'Coosawhatchie River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (35,'Delaware River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (36,'Discovery Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (37,'Drakes Estero');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (38,'Dungeness Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (39,'East Basin');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (40,'Edisto River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (41,'Elevenmile');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (42,'Elk River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (43,'Escambia River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (44,'Estero Americano');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (45,'Estero de San Antonio');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (46,'Fairlee Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (47,'Freshwater Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (48,'Grass Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (49,'Grays Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (50,'Greys Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (51,'Gunpowder River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (52,'Herring Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (53,'Hillsborough River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (54,'Hoko River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (55,'Hood Canal');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (56,'Johnson Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (57,'King Harbor');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (58,'Knappa Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (59,'Langford Creek E. Fork');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (60,'Langford Creek W. Fork');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (61,'Little Manatee River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (62,'Little Nestucca River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (63,'Long Beach Outer Harbor');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (64,'Los Angeles Outer Harbor');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (65,'Los Angeles River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (66,'Magothy River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (67,'Mahon River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (68,'Manatee River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (69,'Manokin River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (70,'Marsh Island Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (71,'Mattawoman Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (72,'Middle River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (73,'Miles River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (74,'Monterey Harbor');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (75,'Myakka River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (76,'Nanjemoy Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (77,'Nanticoke River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (78,'Nehalem River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (79,'Nestucca River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (80,'Neuse River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (81,'North River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (82,'Northeast River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (83,'Pajaro River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (84,'Pamlico River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (85,'Pasquotank River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (86,'Patapsco River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (87,'Peace River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (88,'Perdido River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (89,'Pines River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (90,'Pocomoke River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (91,'Port Tobacco River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (92,'Providence River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (93,'Pungo River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (94,'Rinearson Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (95,'Rodeo River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (96,'Saint Clement Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (97,'Saint Martin River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (98,'Saint Marys River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (99,'Santa Cruz Harbor');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (100,'Sassafras River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (101,'Saugus River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (102,'Scholfield Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (103,'Severn River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (104,'Smith River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (105,'Smyrna River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (106,'South River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (107,'South Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (108,'Southeast Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (109,'Still Pond Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (110,'Susquehanna River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (111,'Thames River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (112,'Toms Cove');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (113,'Trappe Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (114,'Tred Avon River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (115,'Turville Creek');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (116,'Wallace Slough');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (117,'West Basin');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (118,'West Bay');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (119,'White Oak River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (120,'Wicomico River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (121,'Wye East River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (122,'Wye River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (123,'Yaquina River');
Insert into STORETW.LU_ESTRY_SECONDARY (PK_ISN,SECONDARY_ESTUARY) values (124,'Youngs Bay');
--------------------------------------------------------
--  DDL for Index PK_ESTRY_SECONDARY
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_ESTRY_SECONDARY" ON "STORETW"."LU_ESTRY_SECONDARY" ("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" ;
--------------------------------------------------------
--  DDL for Index IESTRY_SECONDARY01
--------------------------------------------------------

  CREATE INDEX "STORETW"."IESTRY_SECONDARY01" ON "STORETW"."LU_ESTRY_SECONDARY" ("SECONDARY_ESTUARY") 
  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 LU_ESTRY_SECONDARY
--------------------------------------------------------

  ALTER TABLE "STORETW"."LU_ESTRY_SECONDARY" ADD CONSTRAINT "PK_ESTRY_SECONDARY" 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;
