** table AGENCY ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(8) AGENCY_NAME VARCHAR2(25) ORGANIZATION_TYPE CHAR(3) DATA_DESCRIPTION01 VARCHAR2(25) DATA_DESCRIPTION02 VARCHAR2(25) DATA_DESCRIPTION03 VARCHAR2(25) RETIREMENT_NAME VARCHAR2(25) RETIREMENT_DATE CHAR(8) RETIREMENT_PHONE VARCHAR2(13) EPA_REGION_LOCATION VARCHAR2(2) FK_ORGANIZATION_CODE_ISN NUMBER(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_AGENCY CODE --INDEX: XIF38AGENCY FK_ORGANIZATION_CODE_ISN --CONSTRAINT: FK_ORGANIZATION_AGENCY FK_ORGANIZATION_CODE_ISN FOREIGN KEY ----REFERENCE CONSTRAINT: FK_ORGANIZATION_AGENCY AGENCY FK_ORGANIZATION_CODE_ISN --CONSTRAINT: PK_AGENCY CODE PRIMARY KEY --CONSTRAINT: SYS_C00772 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00773 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00774 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00775 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table AQUIFER ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(15) LONG_NAME VARCHAR2(70) --INDEX: PK_AQUIFER CODE --CONSTRAINT: PK_AQUIFER CODE PRIMARY KEY --CONSTRAINT: SYS_C00892 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table CHARACTERISTIC ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) UOM_TYPE NOT NULL CHAR(5) SEARCH_NAME NOT NULL VARCHAR2(60) DISPLAY_NAME NOT NULL VARCHAR2(60) CHARACTERISTIC_TYPE_CODE NOT NULL CHAR(1) TAXON_RANK_CODE CHAR(8) --INDEX: XPKCHARACTERISTIC CODE_ISN --CONSTRAINT: SYS_C00836 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00837 UOM_TYPE CHECK "UOM_TYPE" IS NOT NULL --CONSTRAINT: SYS_C00838 SEARCH_NAME CHECK "SEARCH_NAME" IS NOT NULL --CONSTRAINT: SYS_C00839 DISPLAY_NAME CHECK "DISPLAY_NAME" IS NOT NULL --CONSTRAINT: SYS_C00840 CHARACTERISTIC_TYPE_CODE CHECK "CHARACTERISTIC_TYPE_CODE" IS NOT NUL 1* SELECT DATA FROM TBL_METADATA ORDER BY SEQNO --CONSTRAINT: XPKCHARACTERISTIC CODE_ISN PRIMARY KEY ***************************************************************** ** table COMPOSITE_METHOD ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) NAME NOT NULL VARCHAR2(20) DESCRIPTION NOT NULL VARCHAR2(260) --INDEX: PK_COMPOSITE_METHOD CODE --CONSTRAINT: PK_COMPOSITE_METHOD CODE PRIMARY KEY --CONSTRAINT: SYS_C00841 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00842 NAME CHECK "NAME" IS NOT NULL --CONSTRAINT: SYS_C00843 DESCRIPTION CHECK "DESCRIPTION" IS NOT NULL ***************************************************************** ** table COMPOSITE_STATISTIC ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) NAME VARCHAR2(60) PRINT_FORMAT CHAR(3) PERFORMANCE_TYPE_IND CHAR(1) --INDEX: PK_COMPOSITE_STATISTIC CODE --CONSTRAINT: PK_COMPOSITE_STATISTIC CODE PRIMARY KEY --CONSTRAINT: SYS_C00826 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table DECIMAL_POINT ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL NUMBER(2) DESCRIPTION VARCHAR2(20) --INDEX: PK_DECIMAL_POINT CODE --CONSTRAINT: PK_DECIMAL_POINT CODE PRIMARY KEY --CONSTRAINT: SYS_C00844 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table DESCRIPTIVE_PARAGRAPH_LINE ** Name Null? Type ------------------------------- -------- ---- FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) PARAGRAPH_LINE_NUMBER NOT NULL NUMBER(2) TEXT CHAR(72) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_DESCRIPTIVE_PARAGRAPH FK_COMPUTER_SEQUENCE_NUMBER --INDEX: PK_DESCRIPTIVE_PARAGRAPH PARAGRAPH_LINE_NUMBER --INDEX: XIF41DESCRIPTIVE_PARAGRAPH FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: FK_STATION_DESC_PARAGRAPH FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_DESC_PARAGRAPH DESCRIPTIVE_PARAGRAPH_LINE FK_COMPUTER_SE unknown command beginning "QUENCE_NUM..." - rest of line ignored. --CONSTRAINT: PK_DESCRIPTIVE_PARAGRAPH FK_COMPUTER_SEQUENCE_NUMBER PRIMARY KEY --CONSTRAINT: PK_DESCRIPTIVE_PARAGRAPH PARAGRAPH_LINE_NUMBER PRIMARY KEY --CONSTRAINT: SYS_C00783 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00784 PARAGRAPH_LINE_NUMBER CHECK "PARAGRAPH_LINE_NUMBER" IS NOT NULL --CONSTRAINT: SYS_C00785 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00786 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00787 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table DUAL ** Name Null? Type ------------------------------- -------- ---- DUMMY VARCHAR2(1) ***************************************************************** ** table EFFLUENT_MONITORING_INTENT ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(2) NAME NOT NULL VARCHAR2(60) --INDEX: PK_EFF_MONITOR_INTENT CODE --CONSTRAINT: PK_EFF_MONITOR_INTENT CODE PRIMARY KEY --CONSTRAINT: SYS_C00845 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00846 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table EFFLUENT_STATISTIC ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) NAME VARCHAR2(60) PRINT_FORMAT CHAR(3) --INDEX: PK_EFFLUENT_STATISTIC CODE --CONSTRAINT: PK_EFFLUENT_STATISTIC CODE PRIMARY KEY --CONSTRAINT: SYS_C00847 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table EM_STATION_LOCATION_SDE ** Object does not exist. --INDEX: A1_IX1 FID --CONSTRAINT: A1_FK1 FID FOREIGN KEY ----REFERENCE CONSTRAINT: A1_FK1 EM_STATION_LOCATION_SDE FID ***************************************************************** ** table EM_STN_LOC_IX_HL61$ ** Object does not exist. ***************************************************************** ** table ERROR_LOG ** Name Null? Type ------------------------------- -------- ---- COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) ERROR_CODE_ISN NOT NULL NUMBER(12) SAMPLE_CODE_ISN NUMBER(12) DESTINATION_TABLE NOT NULL CHAR(30) ATTRIBUTE NOT NULL CHAR(30) REASON NOT NULL VARCHAR2(255) REQUIRED_ATTRIBUTE NOT NULL CHAR(1) RUN_NUMBER NOT NULL NUMBER(3) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) --INDEX: PK_ERROR_LOG ERROR_CODE_ISN --CONSTRAINT: PK_ERROR_LOG ERROR_CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00814 COMPUTER_SEQUENCE_NUMBER CHECK "COMPUTER_SEQUENCE_NUMBER" IS NOT NUL 1* SELECT DATA FROM TBL_METADATA ORDER BY SEQNO --CONSTRAINT: SYS_C00815 ERROR_CODE_ISN CHECK "ERROR_CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00816 DESTINATION_TABLE CHECK "DESTINATION_TABLE" IS NOT NULL --CONSTRAINT: SYS_C00817 ATTRIBUTE CHECK "ATTRIBUTE" IS NOT NULL --CONSTRAINT: SYS_C00818 REASON CHECK "REASON" IS NOT NULL --CONSTRAINT: SYS_C00819 REQUIRED_ATTRIBUTE CHECK "REQUIRED_ATTRIBUTE" IS NOT NULL --CONSTRAINT: SYS_C00820 RUN_NUMBER CHECK "RUN_NUMBER" IS NOT NULL --CONSTRAINT: SYS_C00821 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00822 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL ***************************************************************** ** table FIPS_HYDROLOGIC_UNIT ** Name Null? Type ------------------------------- -------- ---- FIPS_HYDROLOGICUNIT_STORETX NOT NULL NUMBER(12) FIPS_HYDROLOGIC_UNIT_CODE CHAR(8) NAME VARCHAR2(60) --INDEX: HUC_INDX FIPS_HYDROLOGIC_UNIT_CODE --INDEX: PK_FIPS_HUC FIPS_HYDROLOGICUNIT_STORETX --CONSTRAINT: PK_FIPS_HUC FIPS_HYDROLOGICUNIT_STORETX PRIMARY KEY --CONSTRAINT: SYS_C00808 FIPS_HYDROLOGICUNIT_STORETX CHECK "FIPS_HYDROLOGICUNIT_STORETX" IS N unknown command "OT NULL" - rest of line ignored. ***************************************************************** ** table INT_ORG ** Name Null? Type ------------------------------- -------- ---- CONTACT_NAME NOT NULL CHAR(25) CONTACT_ADDRESS_LINE01 CHAR(25) CONTACT_ADDRESS_LINE02 CHAR(25) CONTACT_PHONE NOT NULL CHAR(13) CONTACT_ADDRESS_LINE03 CHAR(25) CONTACT_ADDRESS_LINE04 CHAR(25) ALTERNATE_CONTACT_NAME CHAR(25) ALTERNATE_PHONE CHAR(13) --CONSTRAINT: SYS_C00848 CONTACT_NAME CHECK "CONTACT_NAME" IS NOT NULL --CONSTRAINT: SYS_C00849 CONTACT_PHONE CHECK "CONTACT_PHONE" IS NOT NULL ***************************************************************** ** table LAT_LONG_PRECISION ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL NUMBER(2) NAME VARCHAR2(20) --INDEX: PK_LAT_LONG_PRECISION CODE --CONSTRAINT: PK_LAT_LONG_PRECISION CODE PRIMARY KEY --CONSTRAINT: SYS_C00807 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL1 ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(260) --INDEX: PK_LEG_STORET_LEVEL1 NAME --CONSTRAINT: PK_LEG_STORET_LEVEL1 NAME PRIMARY KEY --CONSTRAINT: SYS_C00850 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL2A ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(260) --INDEX: PK_LEG_STORET_LEVEL2A NAME --CONSTRAINT: PK_LEG_STORET_LEVEL2A NAME PRIMARY KEY --CONSTRAINT: SYS_C00851 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL2B ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(250) --INDEX: PK_LEG_STORET_LEVEL2B NAME --CONSTRAINT: PK_LEG_STORET_LEVEL2B NAME PRIMARY KEY --CONSTRAINT: SYS_C00852 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL3 ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(250) --INDEX: PK_LEG_STORET_LEVEL3 NAME --CONSTRAINT: PK_LEG_STORET_LEVEL3 NAME PRIMARY KEY --CONSTRAINT: SYS_C00853 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL4 ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(250) --INDEX: PK_LEG_STORET_LEVEL4 NAME --CONSTRAINT: PK_LEG_STORET_LEVEL4 NAME PRIMARY KEY --CONSTRAINT: SYS_C00854 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL5 ** Name Null? Type ------------------------------- -------- ---- NAME NOT NULL VARCHAR2(12) DESCRIPTION VARCHAR2(250) --INDEX: PK_LEG_STORET_LEVEL5 NAME --CONSTRAINT: PK_LEG_STORET_LEVEL5 NAME PRIMARY KEY --CONSTRAINT: SYS_C00855 NAME CHECK "NAME" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_LEVEL5_ASSIGN2 ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) FK_LEGACY_STORET_LEVEL5_NAME NOT NULL VARCHAR2(12) FK_COMPUTER_SEQUENCE_NUMBER NUMBER(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_LEG_STO_LEV5_ASSIGN CODE_ISN --INDEX: XIF62OLD_STORET_LEVEL5_COMBO2 FK_COMPUTER_SEQUENCE_NUMBER --INDEX: XIF63OLD_STORET_LEVEL5_COMBO2 FK_LEGACY_STORET_LEVEL5_NAME --CONSTRAINT: FK_LEG_LEVEL5_LEG_LEV5_ASSIGN2 FK_LEGACY_STORET_LEVEL5_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL5_LEG_LEV5_ASSIGN2 LEGACY_STORET_LEVEL5_ASSIGN2 FK_LEGA unknown command beginning "CY_STORET_..." - rest of line ignored. --CONSTRAINT: FK_LEG_STN_TYPE_LEG_LEV5_ASSIN FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_STN_TYPE_LEG_LEV5_ASSIN LEGACY_STORET_LEVEL5_ASSIGN2 FK_COMP unknown command beginning "UTER_SEQUE..." - rest of line ignored. --CONSTRAINT: PK_LEG_STO_LEV5_ASSIGN CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00856 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00857 FK_LEGACY_STORET_LEVEL5_NAME CHECK "FK_LEGACY_STORET_LEVEL5_NAME" IS unknown command "NOT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00858 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00859 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00860 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table LEGACY_STORET_STATION_TYPE ** Name Null? Type ------------------------------- -------- ---- FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) FK_LEGACY_STORET_LEVEL4_NAME VARCHAR2(12) FK_LEGACY_STORET_LEVEL2A_NAME NOT NULL VARCHAR2(12) FK_LEGACY_STORET_LEVEL3_NAME VARCHAR2(12) FK_LEGACY_STORET_LEVEL2B_NAME VARCHAR2(12) FK_LEGACY_STORET_LEVEL1_NAME VARCHAR2(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_LEG_STO_STN_TYPE FK_COMPUTER_SEQUENCE_NUMBER --INDEX: XIF108LEGACY_STORET_STATION_TY FK_LEGACY_STORET_LEVEL2B_NAME --INDEX: XIF110LEGACY_STORET_STATION_TY FK_LEGACY_STORET_LEVEL2A_NAME --INDEX: XIF58OLD_STORET_LEVEL_CODE_COM FK_LEGACY_STORET_LEVEL1_NAME --INDEX: XIF60OLD_STORET_LEVEL_CODE_COM FK_LEGACY_STORET_LEVEL3_NAME --INDEX: XIF61OLD_STORET_LEVEL_CODE_COM FK_LEGACY_STORET_LEVEL4_NAME --CONSTRAINT: FK_LEG_LEVEL1_LEG_STN_TYPE FK_LEGACY_STORET_LEVEL1_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL1_LEG_STN_TYPE LEGACY_STORET_STATION_TYPE FK_LEGACY_STO unknown command beginning "RET_LEVEL1..." - rest of line ignored. --CONSTRAINT: FK_LEG_LEVEL2A_LEG_STN_TYPE FK_LEGACY_STORET_LEVEL2A_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL2A_LEG_STN_TYPE LEGACY_STORET_STATION_TYPE FK_LEGACY_ST unknown command beginning "ORET_LEVEL..." - rest of line ignored. --CONSTRAINT: FK_LEG_LEVEL2B_LEG_STN_TYPE FK_LEGACY_STORET_LEVEL2B_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL2B_LEG_STN_TYPE LEGACY_STORET_STATION_TYPE FK_LEGACY_ST unknown command beginning "ORET_LEVEL..." - rest of line ignored. --CONSTRAINT: FK_LEG_LEVEL3_LEG_STN_TYPE FK_LEGACY_STORET_LEVEL3_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL3_LEG_STN_TYPE LEGACY_STORET_STATION_TYPE FK_LEGACY_STO unknown command beginning "RET_LEVEL3..." - rest of line ignored. --CONSTRAINT: FK_LEG_LEVEL4_LEG_STN_TYPE FK_LEGACY_STORET_LEVEL4_NAME FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LEG_LEVEL4_LEG_STN_TYPE LEGACY_STORET_STATION_TYPE FK_LEGACY_STO unknown command beginning "RET_LEVEL4..." - rest of line ignored. --CONSTRAINT: FK_STATION_LEG_STORET_STN_TYPE FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_LEG_STORET_STN_TYPE LEGACY_STORET_STATION_TYPE FK_COMPUT unknown command beginning "ER_SEQUENC..." - rest of line ignored. --CONSTRAINT: PK_LEG_STO_STN_TYPE FK_COMPUTER_SEQUENCE_NUMBER PRIMARY KEY --CONSTRAINT: SYS_C00861 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00862 FK_LEGACY_STORET_LEVEL2A_NAME CHECK "FK_LEGACY_STORET_LEVEL2A_NAME" unknown command beginning "IS NOT NUL..." - rest of line ignored. --CONSTRAINT: SYS_C00863 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00864 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00865 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table LOCATION_POINT_TYPE ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) NAME VARCHAR2(30) --INDEX: PK_LOCATION_POINT_TYPE CODE --CONSTRAINT: PK_LOCATION_POINT_TYPE CODE PRIMARY KEY --CONSTRAINT: SYS_C00811 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table OMERNICH_LEVEL3_ECOREGION ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(2) NAME VARCHAR2(60) --INDEX: PK_OMERNICH_LEV3_ECOR CODE --CONSTRAINT: PK_OMERNICH_LEV3_ECOR CODE PRIMARY KEY --CONSTRAINT: SYS_C00812 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table ORGANIZATION ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) CONTACT_NAME NOT NULL VARCHAR2(25) CONTACT_PHONE NOT NULL CHAR(13) CONTACT_ADDRESS_LINE01 VARCHAR2(25) CONTACT_ADDRESS_LINE02 VARCHAR2(25) CONTACT_ADDRESS_LINE03 VARCHAR2(25) CONTACT_ADDRESS_LINE04 VARCHAR2(25) ALTERNATE_CONTACT_NAME VARCHAR2(25) ALTERNATE_PHONE CHAR(13) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_ORGANIZATION CODE_ISN --CONSTRAINT: PK_ORGANIZATION CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00801 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00802 CONTACT_NAME CHECK "CONTACT_NAME" IS NOT NULL --CONSTRAINT: SYS_C00803 CONTACT_PHONE CHECK "CONTACT_PHONE" IS NOT NULL --CONSTRAINT: SYS_C00804 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00805 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00806 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table PARAMETER ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(5) LONG_NAME VARCHAR2(50) FK_PARAMETER_GROUP_CODE NOT NULL NUMBER(2) SHORT_NAME01 CHAR(8) SHORT_NAME02 CHAR(8) SHORT_NAME03 CHAR(8) FK_REPORTING_UNITS_CODE VARCHAR2(8) FK_SMPL_MDIA_TYPE_CODE_ISN NUMBER(12) FK_DECIMAL_POINT_CODE NUMBER(2) FK_CHARACTERISTIC_CODE_ISN NUMBER(12) CAS_NUMBER NUMBER(9) NUMBER_OBSERVATIONS NUMBER(12) --INDEX: PK_PARAMETER CODE --INDEX: XIF112PARAMETER FK_PARAMETER_GROUP_CODE --INDEX: XIF114PARAMETER FK_CHARACTERISTIC_CODE_ISN --INDEX: XIF78PARAMETER FK_SMPL_MDIA_TYPE_CODE_ISN --INDEX: XIF82PARAMETER FK_REPORTING_UNITS_CODE --INDEX: XIF92PARAMETER FK_DECIMAL_POINT_CODE --CONSTRAINT: PK_PARAMETER CODE PRIMARY KEY --CONSTRAINT: SYS_C00866 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00867 FK_PARAMETER_GROUP_CODE CHECK "FK_PARAMETER_GROUP_CODE" IS NOT NULL ***************************************************************** ** table PARAMETER_COPY ** Object does not exist. --INDEX: PARAMETER_X CODE --CONSTRAINT: SYS_C00868 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00869 FK_PARAMETER_GROUP_CODE CHECK "FK_PARAMETER_GROUP_CODE" IS NOT NULL ***************************************************************** ** table PARAMETER_GROUP ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL NUMBER(2) NAME NOT NULL VARCHAR2(60) OFFICIAL_NAME NOT NULL VARCHAR2(10) --INDEX: PK_PARAM_GRP CODE --CONSTRAINT: PK_PARAM_GRP CODE PRIMARY KEY --CONSTRAINT: SYS_C00870 CODE CHECK "CODE" IS NOT NULL --CONSTRAINT: SYS_C00871 NAME CHECK "NAME" IS NOT NULL --CONSTRAINT: SYS_C00872 OFFICIAL_NAME CHECK "OFFICIAL_NAME" IS NOT NULL ***************************************************************** ** table PRIMARY_ACTIVITY_CATEGORY ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) NAME VARCHAR2(60) --INDEX: PK_PRIM_ACT_CATEGORY CODE --CONSTRAINT: PK_PRIM_ACT_CATEGORY CODE PRIMARY KEY --CONSTRAINT: SYS_C00823 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table PRMRY_SCNDRY_ACTVTY_COMBO2 ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) FK_PRMRY_ACTVTY_CATEGORY_CODE CHAR(1) FK_SCNDRY_ACTVTY_CATEGORY_CODE NUMBER(4) --INDEX: PK_PRMY_SECNDY_COMBO2 CODE_ISN --INDEX: XIF96PRMRY_SCNDRY_ACTVTY_COMBO FK_SCNDRY_ACTVTY_CATEGORY_CODE --INDEX: XIF97PRMRY_SCNDRY_ACTVTY_COMBO FK_PRMRY_ACTVTY_CATEGORY_CODE --CONSTRAINT: FK_PRIM_ACT_CAT_PRMY_SCDRY_COM FK_PRMRY_ACTVTY_CATEGORY_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_PRIM_ACT_CAT_PRMY_SCDRY_COM PRMRY_SCNDRY_ACTVTY_COMBO2 FK_PRMRY_ unknown command beginning "ACTVTY_CAT..." - rest of line ignored. --CONSTRAINT: FK_SEC_ACT_CAT_PRMY_SCDRY_COM FK_SCNDRY_ACTVTY_CATEGORY_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_SEC_ACT_CAT_PRMY_SCDRY_COM PRMRY_SCNDRY_ACTVTY_COMBO2 FK_SCNDRY_ unknown command beginning "ACTVTY_CAT..." - rest of line ignored. --CONSTRAINT: PK_PRMY_SECNDY_COMBO2 CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00825 CODE_ISN CHECK "CODE_ISN" IS NOT NULL ***************************************************************** ** table REPORTING_UNITS ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL VARCHAR2(8) NAME VARCHAR2(60) --INDEX: PK_REPORTING_UNITS CODE --CONSTRAINT: PK_REPORTING_UNITS CODE PRIMARY KEY --CONSTRAINT: SYS_C00879 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table RESULT ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) RESULT_VALUE VARCHAR2(12) FK_SAMPLE_CODE_ISN NUMBER(12) FK_COMPOSITE_STATISTIC_CODE CHAR(1) FK_EFFLUENT_STATISTIC_CODE CHAR(1) FK_PARAMETER_CODE CHAR(5) FK_STORET_RESULT_REMARK_CODE CHAR(1) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) RUN_NUMBER NOT NULL NUMBER(3) --INDEX: FK_RESULT_PARAMETER_CODE FK_PARAMETER_CODE --INDEX: FK_RESULT_SAMPLE_CODE_ISN FK_SAMPLE_CODE_ISN --INDEX: PK_RESULT CODE_ISN --INDEX: RESULT_RUN_NO_INDX RUN_NUMBER --INDEX: XIF75SMPLE_RSLTVAL_PARMETER_AS FK_STORET_RESULT_REMARK_CODE --INDEX: XIF79RESULT FK_EFFLUENT_STATISTIC_CODE --INDEX: XIF80RESULT FK_COMPOSITE_STATISTIC_CODE --CONSTRAINT: FK_COMPOSITE_STAT_RESULT FK_COMPOSITE_STATISTIC_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_COMPOSITE_STAT_RESULT RESULT FK_COMPOSITE_STATISTIC_CODE --CONSTRAINT: FK_EFFLUENT_STAT_RESULT FK_EFFLUENT_STATISTIC_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_EFFLUENT_STAT_RESULT RESULT FK_EFFLUENT_STATISTIC_CODE --CONSTRAINT: FK_STORET_RESULT_REMARK_RESULT FK_STORET_RESULT_REMARK_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STORET_RESULT_REMARK_RESULT RESULT FK_STORET_RESULT_REMARK_CODE --CONSTRAINT: PK_RESULT_CODE__ISN CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00831 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00832 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00833 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00834 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL --CONSTRAINT: SYS_C00835 RUN_NUMBER CHECK "RUN_NUMBER" IS NOT NULL ***************************************************************** ** table RESULT$ ** Object does not exist. --INDEX: I_RESULT1 TOID --INDEX: I_RESULT1 VERSION# --INDEX: I_RESULT1 METHOD# --INDEX: I_RESULT1 RESULT# --CONSTRAINT: SYS_C00585 TOID CHECK "TOID" IS NOT NULL --CONSTRAINT: SYS_C00586 VERSION# CHECK "VERSION#" IS NOT NULL --CONSTRAINT: SYS_C00587 METHOD# CHECK "METHOD#" IS NOT NULL --CONSTRAINT: SYS_C00588 RESULT# CHECK "RESULT#" IS NOT NULL --CONSTRAINT: SYS_C00589 RESULT_TOID CHECK "RESULT_TOID" IS NOT NULL --CONSTRAINT: SYS_C00590 RESULT_VERSION# CHECK "RESULT_VERSION#" IS NOT NULL --CONSTRAINT: SYS_C00591 PROPERTIES CHECK "PROPERTIES" IS NOT NULL ***************************************************************** ** table RF1_REACH ** Name Null? Type ------------------------------- -------- ---- STORET_X_CODE NOT NULL NUMBER(12) CATUNIT_CODE NOT NULL VARCHAR2(8) RCHMILE_SEGMENT NUMBER(3) RCHLENGTH FLOAT(126) RCHLEVEL FLOAT(126) RCHTYPE CHAR(1) RCHNAME VARCHAR2(60) --INDEX: PK_RF1_REACH STORET_X_CODE --CONSTRAINT: PK_RF1_REACH STORET_X_CODE PRIMARY KEY --CONSTRAINT: SYS_C00809 STORET_X_CODE CHECK "STORET_X_CODE" IS NOT NULL --CONSTRAINT: SYS_C00810 CATUNIT_CODE CHECK "CATUNIT_CODE" IS NOT NULL ***************************************************************** ** table RMI ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) RMI_MILE_DESC VARCHAR2(112) RMI_INDEX_DESC VARCHAR2(112) FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_RMI CODE_ISN --INDEX: XIF73RMI FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: FK_STATION_RMI FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_RMI RMI FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: PK_RMI CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00880 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00881 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00882 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00883 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00884 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table SAMPLE ** Name Null? Type ------------------------------- -------- ---- SAMPLE_CODE_ISN NOT NULL NUMBER(12) START_DATE DATE START_TIME NUMBER(4) END_DATE DATE END_TIME NUMBER(4) SAMPLE_DEPTH NUMBER(8,2) SPECIES_NAME VARCHAR2(60) REPLICATE_NUMBER NUMBER(12) TISSUE_NAME VARCHAR2(60) UMK CHAR(8) PIPE_ID NUMBER(12) COMPOSITE_GRAB_NUMBER NUMBER(2) USGS_FIELD_LAB_CODE CHAR(1) STORE_DATE DATE FK_PRMY_SCNDY_COMBO2_CODE_ISN NUMBER(12) FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) FK_COMPOSITE_METHOD_CODE CHAR(1) FK_EFFLUENT_MONTRNG_INTNT_CODE CHAR(2) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) RUN_NUMBER NOT NULL NUMBER(3) --INDEX: END_DATE_INDX END_DATE --INDEX: FK_COMPUTER_SEQUENCE_NUMBER FK_COMPUTER_SEQUENCE_NUMBER --INDEX: PK_SAMPLE SAMPLE_CODE_ISN --INDEX: SAMPLE_DEPTH_INDX SAMPLE_DEPTH --INDEX: SAMPLE_RUN_NUMBER_INDX RUN_NUMBER --INDEX: START_DATE_INDX START_DATE --INDEX: XIF104SAMPLE FK_PRMY_SCNDY_COMBO2_CODE_ISN --INDEX: XIF88SAMPLE FK_COMPOSITE_METHOD_CODE --INDEX: XIF89SAMPLE FK_EFFLUENT_MONTRNG_INTNT_CODE --CONSTRAINT: FK_STATION_SAMPLE FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_SAMPLE SAMPLE FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: PK_SAMPLE SAMPLE_CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00795 SAMPLE_CODE_ISN CHECK "SAMPLE_CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00796 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00797 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00798 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00799 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL --CONSTRAINT: SYS_C00800 RUN_NUMBER CHECK "RUN_NUMBER" IS NOT NULL ***************************************************************** ** table SAMPLE_MEDIA_ANALYSIS_TYPE ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) ANALYSIS_TYPE_CODE CHAR(1) ANALYSIS_TYPE_NAME VARCHAR2(80) SAMPLE_MEDIA_CODE NOT NULL CHAR(1) SAMPLE_MEDIA_NAME VARCHAR2(60) --INDEX: PK_SAMP_MEDIA_ANAL_TYPE CODE_ISN --CONSTRAINT: PK_SAMP_MEDIA_ANAL_TYPE CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00885 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00886 SAMPLE_MEDIA_CODE CHECK "SAMPLE_MEDIA_CODE" IS NOT NULL ***************************************************************** ** table SECONDARY_ACTIVITY_CATEGORY ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL NUMBER(4) NAME VARCHAR2(60) OUTPUT_FORMAT VARCHAR2(8) --INDEX: PK_SEC_ACT_CATEGORY CODE --CONSTRAINT: PK_SEC_ACT_CATEGORY CODE PRIMARY KEY --CONSTRAINT: SYS_C00824 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table STATE_COUNTY ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) STATE_CODE CHAR(2) COUNTY_CODE CHAR(3) STATE_NAME CHAR(30) COUNTY_NAME CHAR(30) FIPS_INDICATOR CHAR(1) --INDEX: INDX_COUNTY_NAME COUNTY_NAME --INDEX: INDX_STATE_NAME STATE_NAME --INDEX: PK_STATE_COUNTY CODE_ISN --INDEX: STATE_COUNTY_INDX STATE_NAME --INDEX: STATE_COUNTY_INDX COUNTY_NAME --CONSTRAINT: PK_STATE_COUNTY CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00813 CODE_ISN CHECK "CODE_ISN" IS NOT NULL ***************************************************************** ** table STATION ** Name Null? Type ------------------------------- -------- ---- COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) PRIMARY_STATION_ID NOT NULL CHAR(15) LGCY_STORET_STATION_TYPE_CODE VARCHAR2(65) ELEVATION NUMBER(9) ELEVATION_UNITS CHAR(1) LOCATION_NAME_2 CHAR(60) LOCATION_NAME_3 CHAR(60) EPA_MAJOR_BASIN_CODE CHAR(2) EPA_MINOR_BASIN_CODE CHAR(2) SUB_BASIN_CODE CHAR(2) STATION_DEPTH NUMBER(3) STATION_DEPTH_UNITS VARCHAR2(20) LOCATION_NAME VARCHAR2(48) STORE_DATE DATE BEGIN_DATE DATE END_DATE DATE SURFACE_WATER_INDICATOR CHAR(1) GROUND_WATER_INDICATOR CHAR(1) PIPE_INDICATOR CHAR(1) NUM_SAMPLES NUMBER(10) NUM_OBSERVATIONS NUMBER(10) FK_AGENCY_CODE NOT NULL CHAR(8) FK_STORET_X_STATION_TYPE_CODE NUMBER(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: AGENCY_STATION_INDX FK_AGENCY_CODE --INDEX: AGENCY_STATION_INDX PRIMARY_STATION_ID --INDEX: GW_INDICATOR_INDX GROUND_WATER_INDICATOR --INDEX: INDX_PSID PRIMARY_STATION_ID --INDEX: PIPE_INDICATOR_INDX PIPE_INDICATOR --INDEX: PK_STATION COMPUTER_SEQUENCE_NUMBER --INDEX: SW_INDICATOR_INDX SURFACE_WATER_INDICATOR --INDEX: XIF51STATION FK_AGENCY_CODE --INDEX: XIF57STATION FK_STORET_X_STATION_TYPE_CODE --CONSTRAINT: FK_AGENCY_STATION FK_AGENCY_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_AGENCY_STATION STATION FK_AGENCY_CODE --CONSTRAINT: FK_STORETX_STATION_TYPE_STATN FK_STORET_X_STATION_TYPE_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STORETX_STATION_TYPE_STATN STATION FK_STORET_X_STATION_TYPE_CODE --CONSTRAINT: PK_STATION COMPUTER_SEQUENCE_NUMBER PRIMARY KEY --CONSTRAINT: SYS_C00776 COMPUTER_SEQUENCE_NUMBER CHECK "COMPUTER_SEQUENCE_NUMBER" IS NOT NUL 1* SELECT DATA FROM TBL_METADATA ORDER BY SEQNO --CONSTRAINT: SYS_C00777 PRIMARY_STATION_ID CHECK "PRIMARY_STATION_ID" IS NOT NULL --CONSTRAINT: SYS_C00778 FK_AGENCY_CODE CHECK "FK_AGENCY_CODE" IS NOT NULL --CONSTRAINT: SYS_C00779 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00780 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00781 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table STATION_ALIAS ** Name Null? Type ------------------------------- -------- ---- SECONDARY_STATION_ID NOT NULL CHAR(12) FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) TMSP_ADDED DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_STATION_ALIAS SECONDARY_STATION_ID --INDEX: PK_STATION_ALIAS FK_COMPUTER_SEQUENCE_NUMBER --INDEX: XIF39STATION_ALIAS FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: FK_STATION_STATION_ALIAS FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_STATION_ALIAS STATION_ALIAS FK_COMPUTER_SEQUENCE_NUMBER --CONSTRAINT: PK_STATION_ALIAS SECONDARY_STATION_ID PRIMARY KEY --CONSTRAINT: PK_STATION_ALIAS FK_COMPUTER_SEQUENCE_NUMBER PRIMARY KEY --CONSTRAINT: SYS_C00827 SECONDARY_STATION_ID CHECK "SECONDARY_STATION_ID" IS NOT NULL --CONSTRAINT: SYS_C00828 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00829 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00830 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table STATION_AQUIFER_ASSIGN2 ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) FK_AQUIFER_CODE NOT NULL CHAR(15) FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) TMSP_ADDED DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: PK_STN_AQUIFER_ASSIGN2 CODE_ISN --INDEX: XIF42STATION_AQUIFER_ASSIGN2 FK_COMPUTER_SEQUENCE_NUMBER --INDEX: XIF43STATION_AQUIFER_ASSIGN2 FK_AQUIFER_CODE --CONSTRAINT: FK_AQUIFER_STN_AQUIFER_ASSIGN2 FK_AQUIFER_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_AQUIFER_STN_AQUIFER_ASSIGN2 STATION_AQUIFER_ASSIGN2 FK_AQUIFER_C unknown command "ODE" - rest of line ignored. --CONSTRAINT: FK_STN_STN_AQUIFER_ASSIGN2 FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STN_STN_AQUIFER_ASSIGN2 STATION_AQUIFER_ASSIGN2 FK_COMPUTER_SEQU unknown command beginning "ENCE_NUMBE..." - rest of line ignored. --CONSTRAINT: PK_STN_AQUIFER_ASSIGN2 CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00887 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00888 FK_AQUIFER_CODE CHECK "FK_AQUIFER_CODE" IS NOT NULL --CONSTRAINT: SYS_C00889 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00890 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00891 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table STATION_COUNT ** Name Null? Type ------------------------------- -------- ---- SOURCE_FILE VARCHAR2(10) CSN NOT NULL NUMBER(12) PRIMARY_ID VARCHAR2(15) CODE_ISN NOT NULL NUMBER(6) --INDEX: SYS_C009892 CSN --INDEX: SYS_C009892 CODE_ISN --CONSTRAINT: SYS_C009892 CSN PRIMARY KEY --CONSTRAINT: SYS_C009892 CODE_ISN PRIMARY KEY ***************************************************************** ** table STATION_LOCATION_POINT ** Name Null? Type ------------------------------- -------- ---- CODE_ISN NOT NULL NUMBER(12) LATITUDE NUMBER(8,6) LONGITUDE NUMBER(9,6) FK_PRECISION_CODE NUMBER(2) FK_STATE_COUNTY_CODE_ISN NOT NULL NUMBER(12) FK_FIPS_HYDROLOGICUNIT_STORETX NUMBER(12) FK_RF1_REACH_STORET_X_CODE NUMBER(12) MILES_UP_REACH FLOAT(126) RCHONOFF CHAR(3) FK_ECOREGION_CODE CHAR(2) ECOREGION_TYPE_FLAG CHAR(1) FK_LOCATION_POINT_TYPE_CODE NOT NULL CHAR(1) FK_COMPUTER_SEQUENCE_NUMBER NOT NULL NUMBER(12) TMSP_ADDED NOT NULL DATE USERID_LAST_UPDT NOT NULL CHAR(8) RECORD_MIGRATED NOT NULL CHAR(1) --INDEX: LAT_LONG_INDX LATITUDE --INDEX: LAT_LONG_INDX LONGITUDE --INDEX: PK_STATION_LOC_POINT CODE_ISN --INDEX: XIF44STATION_LOCATION_POINT_TY FK_COMPUTER_SEQUENCE_NUMBER --INDEX: XIF45STATION_LOCATION_POINT_TY FK_LOCATION_POINT_TYPE_CODE --INDEX: XIF48STATION_LOCATION_POINT_TY FK_ECOREGION_CODE --INDEX: XIF49STATION_LOCATION_POINT_TY FK_FIPS_HYDROLOGICUNIT_STORETX --INDEX: XIF50STATION_LOCATION_POINT_TY FK_RF1_REACH_STORET_X_CODE --INDEX: XIF74STATION_LOCATION_POINT FK_STATE_COUNTY_CODE_ISN --INDEX: XIF91STATION_LOCATION_POINT FK_PRECISION_CODE --CONSTRAINT: FK_FIPS_HUC_STN_LOC_POINT FK_FIPS_HYDROLOGICUNIT_STORETX FOREIGN KEY ----REFERENCE CONSTRAINT: FK_FIPS_HUC_STN_LOC_POINT STATION_LOCATION_POINT FK_FIPS_HYDROLOGIC unknown command beginning "UNIT_STORE..." - rest of line ignored. --CONSTRAINT: FK_LAT_LONG_PREC_STN_LOC_POINT FK_PRECISION_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LAT_LONG_PREC_STN_LOC_POINT STATION_LOCATION_POINT FK_PRECISION_ unknown command "CODE" - rest of line ignored. --CONSTRAINT: FK_LOC_POINT_TYPE_STN_LOC_POIN FK_LOCATION_POINT_TYPE_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_LOC_POINT_TYPE_STN_LOC_POIN STATION_LOCATION_POINT FK_LOCATION_P unknown command beginning "OINT_TYPE_..." - rest of line ignored. --CONSTRAINT: FK_OMER_LEV3_ECO_STN_LOC_POINT FK_ECOREGION_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_OMER_LEV3_ECO_STN_LOC_POINT STATION_LOCATION_POINT FK_ECOREGION_ unknown command "CODE" - rest of line ignored. --CONSTRAINT: FK_RF1_REACH_STN_LOC_POINT FK_RF1_REACH_STORET_X_CODE FOREIGN KEY ----REFERENCE CONSTRAINT: FK_RF1_REACH_STN_LOC_POINT STATION_LOCATION_POINT FK_RF1_REACH_STOR unknown command "ET_X_CODE" - rest of line ignored. --CONSTRAINT: FK_STATE_COUNTY_STN_LOC_POINT FK_STATE_COUNTY_CODE_ISN FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATE_COUNTY_STN_LOC_POINT STATION_LOCATION_POINT FK_STATE_COUNT unknown command "Y_CODE_ISN" - rest of line ignored. --CONSTRAINT: FK_STATION_STATION_LOC_POINT FK_COMPUTER_SEQUENCE_NUMBER FOREIGN KEY ----REFERENCE CONSTRAINT: FK_STATION_STATION_LOC_POINT STATION_LOCATION_POINT FK_COMPUTER_SEQ unknown command beginning "UENCE_NUMB..." - rest of line ignored. --CONSTRAINT: PK_STATION_LOC_POINT CODE_ISN PRIMARY KEY --CONSTRAINT: SYS_C00788 CODE_ISN CHECK "CODE_ISN" IS NOT NULL --CONSTRAINT: SYS_C00789 FK_STATE_COUNTY_CODE_ISN CHECK "FK_STATE_COUNTY_CODE_ISN" IS NOT NUL 1* SELECT DATA FROM TBL_METADATA ORDER BY SEQNO --CONSTRAINT: SYS_C00790 FK_LOCATION_POINT_TYPE_CODE CHECK "FK_LOCATION_POINT_TYPE_CODE" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00791 FK_COMPUTER_SEQUENCE_NUMBER CHECK "FK_COMPUTER_SEQUENCE_NUMBER" IS N unknown command "OT NULL" - rest of line ignored. --CONSTRAINT: SYS_C00792 TMSP_ADDED CHECK "TMSP_ADDED" IS NOT NULL --CONSTRAINT: SYS_C00793 USERID_LAST_UPDT CHECK "USERID_LAST_UPDT" IS NOT NULL --CONSTRAINT: SYS_C00794 RECORD_MIGRATED CHECK "RECORD_MIGRATED" IS NOT NULL ***************************************************************** ** table STORET_RESULT_REMARK ** Name Null? Type ------------------------------- -------- ---- CODE NOT NULL CHAR(1) DESCRIPTION VARCHAR2(254) --INDEX: PK_STORET_RES_REMARK CODE --CONSTRAINT: PK_STORET_RES_REMARK CODE PRIMARY KEY --CONSTRAINT: SYS_C00893 CODE CHECK "CODE" IS NOT NULL ***************************************************************** ** table STORET_X_STATION_TYPE ** Name Null? Type ------------------------------- -------- ---- STORET_X_CODE NOT NULL NUMBER(12) PRIMARY_TYPE_CODE VARCHAR2(30) SECONDARY_TYPE_CODE VARCHAR2(30) NATURAL_INDICATOR_CODE CHAR(1) --INDEX: PK_STORETX_STATN_TYPE STORET_X_CODE --CONSTRAINT: PK_STORETX_STATN_TYPE STORET_X_CODE PRIMARY KEY --CONSTRAINT: SYS_C00782 STORET_X_CODE CHECK "STORET_X_CODE" IS NOT NULL *****************************************************************