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

  CREATE TABLE "STORETW"."SEQ_GEN" 
   (	"SEQUENCE_NAME" VARCHAR2(128 BYTE), 
	"TABLE_NAME" VARCHAR2(50 CHAR), 
	"MAX_NUMBER" NUMBER, 
	"SEQ_CR_STMT" VARCHAR2(2000 CHAR), 
	"SEQ_GEN_FLAG" CHAR(1 CHAR), 
	"COLUMN_NAME" VARCHAR2(100 CHAR), 
	"SEQ_CUR_VALUE" NUMBER, 
	"SEQ_NEW_VALUE" NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 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"."SEQ_GEN"."SEQUENCE_NAME" IS 'Sequence Name';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."TABLE_NAME" IS 'Table Name';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."MAX_NUMBER" IS 'Maximum  Number';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."SEQ_CR_STMT" IS 'Sequence CR Statement';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."SEQ_GEN_FLAG" IS 'Sequence Generated Flag';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."COLUMN_NAME" IS 'Column Name';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."SEQ_CUR_VALUE" IS 'Sequence Current Value';
   COMMENT ON COLUMN "STORETW"."SEQ_GEN"."SEQ_NEW_VALUE" IS 'Sequence New Value';
REM INSERTING into STORETW.SEQ_GEN
SET DEFINE OFF;
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ACTIVITY_INTENT','DI_ACTIVITY_INTENT',2021,null,'Y','PK_ISN',4361,4363);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ACTIVITY_MATRIX','DI_ACTIVITY_MATRIX',4341,null,'Y','PK_ISN',4501,4503);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_BIOPART','DI_BIOPART',4232,null,'Y','PK_ISN',4441,4443);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_COMMUNITY_SAMPLED','DI_COMMUNITY_SAMPLED',281,null,'Y','PK_ISN',4361,4363);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_DB_CAT','DI_DB_CAT',2287,null,'Y','PK_ISN',6621,6623);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_DI_DATE','DI_DATE',55152,null,'Y','PK_ISN',59491,59493);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_DI_PROJECT','DI_PROJECT',71616,null,'Y','PK_ISN',71627,71629);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_DW_DATA_REQUEST_ID','DW_DATA_REQUESTS',934156,null,'Y','REQUEST_ID',934157,934159);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ESTRY_PRIMARY','LU_ESTRY_PRIMARY',265,null,'Y','PK_ISN',4601,4603);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ESTRY_SECONDARY','LU_ESTRY_SECONDARY',124,null,'Y','PK_ISN',4471,4473);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_FA_BIOLOGICAL_RESULT','FA_BIOLOGICAL_RESULT',393135374,null,'Y','PK_ISN',-1,393136002);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_FA_HABITAT_RESULT','FA_HABITAT_RESULT',393117613,null,'Y','PK_ISN',-1,393136004);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_FA_REGULAR_RESULT','FA_REGULAR_RESULT',393107700,null,'Y','PK_ISN',393136005,393136007);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_FA_STATION','FA_STATION',1262461,null,'Y','PK_ISN',1262544,1262546);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_GEO_COUNTY','DI_GEO_COUNTY',6145,null,'Y','PK_ISN',7861,7863);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_GEO_STATE','DI_GEO_STATE',2741,null,'Y','PK_ISN',4461,4463);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_GROUP_TYPE','DI_GROUP_TYPE',4,null,'Y','PK_ISN',4341,4343);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_LU_CHAR_ALIAS_TYPE','LU_CHAR_ALIAS_TYPE',25,null,'Y','PK_ISN',5209,5211);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_LU_EXTERNAL_REF_SCHEME','LU_EXTERNAL_REF_SCHEME',25326,null,'Y','PK_ISN',25911,25913);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_LU_STATION_ALIAS','LU_STATION_ALIAS',91812,null,'Y','PK_ISN',92393,92395);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MAD_HDATUM','LU_MAD_HDATUM',3671,null,'Y','PK_ISN',4361,4363);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MAD_HMETHOD','LU_MAD_HMETHOD',39,null,'Y','PK_ISN',4391,4393);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MAD_VDATUM','LU_MAD_VDATUM',6,null,'Y','PK_ISN',4341,4343);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MAD_VMETHOD','LU_MAD_VMETHOD',3351,null,'Y','PK_ISN',4371,4373);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_ANALYTICAL_PROC','MD_ANALYTICAL_PROC',34914,null,'Y','PK_ISN',34921,34923);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_CITATION','MD_CITATION',5835,null,'Y','PK_ISN',6681,6683);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_COOP','MD_COOP',399,null,'Y','PK_ISN',4771,4773);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_COOP_ADDRESS','MD_COOP_ADDRESS',55,null,'Y','PK_ISN',4391,4393);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_COOP_EADDRESS','MD_COOP_EADDRESS',91,null,'Y','PK_ISN',4431,4433);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_LAB','MD_LAB',10341,null,'Y','PK_ISN',10481,10483);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_LAB_ADDR','MD_LAB_ADDRESS',403,null,'Y','PK_ISN',4741,4743);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_LAB_EADDR','MD_LAB_EADDRESS',528,null,'Y','PK_ISN',4871,4873);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_LAB_SPP','MD_LAB_SAMPLE_PREP_PROCEDURE',173188322,null,'Y','PK_ISN',173188351,173188353);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_ORG_ADDRESS','MD_ORG_ADDRESS',7925,null,'Y','PK_ISN',7931,7933);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_ORG_EADDRESS','MD_ORG_EADDRESS',16859,null,'Y','PK_ISN',16861,16863);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_PROGRAM','MD_PROGRAM',0,null,'Y','PK_ISN',4361,4363);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_SAMPLE_GEAR','MD_SAMPLE_GEAR',11981,null,'Y','PK_ISN',11991,11993);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_SAMPLE_PRESRV','MD_SAMPLE_PRESRV',6022,null,'Y','PK_ISN',6031,6033);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_MD_SAMPLE_PROC','MD_SAMPLE_PROC',115818,null,'Y','PK_ISN',115871,115873);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ORG','DI_ORG',7272,null,'Y','PK_ISN',7281,7283);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_STATN_TYPES','DI_STATN_TYPES',4354,null,'Y','PK_ISN',4501,4503);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_SUBJECT_TAXON','DI_SUBJECT_TAXON',13685,null,'Y','PK_ISN',-1,-1);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_ACTIVITY_MEDIUM','DI_ACTIVITY_MEDIUM',49,null,'Y','PK_ISN',4368,4370);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_LU_UNIT_CONVERSION','LU_UNIT_CONVERSION',1008303,null,'Y','PK_ISN',1009260,1009262);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_DI_CHARACTERISTIC','DI_CHARACTERISTIC',1084337,null,'Y','PK_ISN',1084356,1084358);
Insert into STORETW.SEQ_GEN (SEQUENCE_NAME,TABLE_NAME,MAX_NUMBER,SEQ_CR_STMT,SEQ_GEN_FLAG,COLUMN_NAME,SEQ_CUR_VALUE,SEQ_NEW_VALUE) values ('SEQ_FA_BLOB','FA_BLOB',1090817,null,'Y','TSMBLOB_IS_NUMBER',1090820,1090822);
