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

  CREATE TABLE "STORETW"."LU_MAD_VMETHOD" 
   (	"PK_ISN" NUMBER(12,0), 
	"ID_CODE" VARCHAR2(12 CHAR), 
	"ELEVATION_METHOD" VARCHAR2(254 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" 
   CACHE ;

   COMMENT ON COLUMN "STORETW"."LU_MAD_VMETHOD"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_MAD_VMETHOD.';
   COMMENT ON COLUMN "STORETW"."LU_MAD_VMETHOD"."ID_CODE" IS 'A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced.';
   COMMENT ON COLUMN "STORETW"."LU_MAD_VMETHOD"."ELEVATION_METHOD" IS 'The code that represents the method used to determine elevation of a point of interest.';
   COMMENT ON TABLE "STORETW"."LU_MAD_VMETHOD"  IS 'Vertical Method lookup table';
REM INSERTING into STORETW.LU_MAD_VMETHOD
SET DEFINE OFF;
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (1,'001','GPS Carrier Phase Static Relative Position');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (2,'002','GPS Carrier Phase Kinematic Relative Position');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (3,'003','GPS Code (Pseudo Range) Differential');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (4,'004','GPS Code (Pseudo Range) Precise Position');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (5,'005','GPS Code (Pseudo Range) Standard Position (SA Off)');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (6,'006','GPS Code (Pseudo Range) Standard Position (SA On)');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (7,'007','Classical Surveying Techniques');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (8,'008','Other');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (9,'009','Altimetry');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (10,'010','Precise Leveling-Bench Mark');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (11,'011','Leveling-Non Bench Mark Control Points');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (12,'012','Trigonometric Leveling');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (13,'013','Photogrammetric');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (14,'014','Topographic Map Interpolation');
Insert into STORETW.LU_MAD_VMETHOD (PK_ISN,ID_CODE,ELEVATION_METHOD) values (3351,'015','UNKNOWN');
--------------------------------------------------------
--  DDL for Index DB_VMETHOD02
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."DB_VMETHOD02" ON "STORETW"."LU_MAD_VMETHOD" (UPPER("ELEVATION_METHOD")) 
  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 DB_VMETHOD01
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."DB_VMETHOD01" ON "STORETW"."LU_MAD_VMETHOD" ("ID_CODE") 
  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_MAD_VMETHOD
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_MAD_VMETHOD" ON "STORETW"."LU_MAD_VMETHOD" ("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 "STORETDATA_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table LU_MAD_VMETHOD
--------------------------------------------------------

  ALTER TABLE "STORETW"."LU_MAD_VMETHOD" ADD CONSTRAINT "PK_MAD_VMETHOD" 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 "STORETDATA_STORMODP"  ENABLE;
  ALTER TABLE "STORETW"."LU_MAD_VMETHOD" MODIFY ("ID_CODE" NOT NULL ENABLE);
