SQL> desc activity_media Name Null? Type ----------------------------------------- -------- ---------------------------- ACMED_UID NOT NULL NUMBER(6) ACMED_NAME NOT NULL VARCHAR2(20) ACMED_LAST_CHANGE_DATE NOT NULL DATE SQL> desc activity_media_subdivision Name Null? Type ----------------------------------------- -------- ---------------------------- AMSUB_UID NOT NULL NUMBER(6) AMSUB_NAME NOT NULL VARCHAR2(45) AMSUB_LAST_CHANGE_DATE NOT NULL DATE SQL> desc activity_type Name Null? Type ----------------------------------------- -------- ---------------------------- ACTYP_UID NOT NULL NUMBER(6) ACTYP_CD NOT NULL VARCHAR2(70) ACTYP_DESC VARCHAR2(400) ACTYP_ANL_MTH_REQ_YN NOT NULL VARCHAR2(1) ACTYP_MON_LOC_REQ_YN NOT NULL VARCHAR2(1) ACTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc address_type Name Null? Type ----------------------------------------- -------- ---------------------------- ADDTYP_UID NOT NULL NUMBER(6) ADDTYP_NAME NOT NULL VARCHAR2(8) ADDTYP_DESC VARCHAR2(200) ADDTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc analytical_method Name Null? Type ----------------------------------------- -------- ---------------------------- ANLMTH_UID NOT NULL NUMBER(6) AMCTX_UID NOT NULL NUMBER(6) ORG_UID NUMBER(6) ANLMTH_ID NOT NULL VARCHAR2(20) ANLMTH_NAME NOT NULL VARCHAR2(120) ANLMTH_DESC VARCHAR2(4000) ANLMTH_QUAL_TYPE VARCHAR2(25) ANLMTH_LAST_CHANGE_DATE NOT NULL DATE ANLMTH_URL VARCHAR2(256) SQL> desc analytical_method_context Name Null? Type ----------------------------------------- -------- ---------------------------- AMCTX_UID NOT NULL NUMBER(6) ORG_UID NUMBER(6) AMCTX_CD NOT NULL VARCHAR2(30) AMCTX_NAME NOT NULL VARCHAR2(120) AMCTX_LAST_CHANGE_DATE NOT NULL DATE SQL> desc assemblage Name Null? Type ----------------------------------------- -------- ---------------------------- ASMBLG_UID NOT NULL NUMBER(6) ASMBLG_NAME NOT NULL VARCHAR2(50) ASMBLG_DESC VARCHAR2(200) ASMBLG_LAST_CHANGE_DATE NOT NULL DATE SQL> desc biological_intent Name Null? Type ----------------------------------------- -------- ---------------------------- BIOINT_UID NOT NULL NUMBER(6) BIOINT_NAME NOT NULL VARCHAR2(35) BIOINT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc cell_form Name Null? Type ----------------------------------------- -------- ---------------------------- CELFRM_UID NOT NULL NUMBER(6) CELFRM_NAME NOT NULL VARCHAR2(11) CELFRM_DESC VARCHAR2(200) CELFRM_LAST_CHANGE_DATE NOT NULL DATE SQL> desc cell_shape Name Null? Type ----------------------------------------- -------- ---------------------------- CELSHP_UID NOT NULL NUMBER(6) CELSHP_NAME NOT NULL VARCHAR2(18) CELSHP_DESC VARCHAR2(200) CELSHP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc characteristic Name Null? Type ----------------------------------------- -------- ---------------------------- CHR_UID NOT NULL NUMBER(6) CHR_NAME NOT NULL VARCHAR2(120) CHR_SRS_ID NUMBER(12) CHR_STORET_ID NUMBER(12) CHR_SAMPLE_FRACTION_REQ_YN NOT NULL VARCHAR2(1) CHR_PICK_LIST_YN NOT NULL VARCHAR2(1) CHR_LAST_CHANGE_DATE NOT NULL DATE CHR_CAS_NUMBER VARCHAR2(12) SQL> desc characteristic_pick_list_value Name Null? Type ----------------------------------------- -------- ---------------------------- CPLVAL_UID NOT NULL NUMBER(6) CHR_UID NOT NULL NUMBER(6) CPLVAL_CD NOT NULL VARCHAR2(12) CPLVAL_DESC VARCHAR2(60) CPLVAL_LAST_CHANGE_DATE NOT NULL DATE SQL> desc container_color Name Null? Type ----------------------------------------- -------- ---------------------------- CONCOL_UID NOT NULL NUMBER(6) CONCOL_NAME NOT NULL VARCHAR2(15) CONCOL_DESC VARCHAR2(200) CONCOL_LAST_CHANGE_DATE NOT NULL DATE SQL> desc container_type Name Null? Type ----------------------------------------- -------- ---------------------------- CONTYP_UID NOT NULL NUMBER(6) CONTYP_NAME NOT NULL VARCHAR2(35) CONTYP_DESC VARCHAR2(200) CONTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc country Name Null? Type ----------------------------------------- -------- ---------------------------- CNTRY_UID NOT NULL NUMBER(6) CNTRY_CD NOT NULL VARCHAR2(2) CNTRY_NAME NOT NULL VARCHAR2(35) CNTRY_LAST_CHANGE_DATE NOT NULL DATE SQL> desc county Name Null? Type ----------------------------------------- -------- ---------------------------- CNTY_UID NOT NULL NUMBER(6) ST_UID NOT NULL NUMBER(6) CNTY_NAME NOT NULL VARCHAR2(50) CNTY_FIPS_CD NOT NULL VARCHAR2(3) CNTY_LAST_CHANGE_DATE NOT NULL DATE SQL> desc detection_quant_limit_type Name Null? Type ----------------------------------------- -------- ---------------------------- DQLTYP_UID NOT NULL NUMBER(6) DQLTYP_NAME NOT NULL VARCHAR2(35) DQLTYP_DESC VARCHAR2(200) DQLTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc electronic_address_type Name Null? Type ----------------------------------------- -------- ---------------------------- EATYP_UID NOT NULL NUMBER(6) EATYP_NAME NOT NULL VARCHAR2(20) EATYP_DESC VARCHAR2(500) EATYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc frequency_class_descriptor Name Null? Type ----------------------------------------- -------- ---------------------------- FCDSC_UID NOT NULL NUMBER(6) FCTYP_UID NOT NULL NUMBER(6) FCDSC_NAME NOT NULL VARCHAR2(50) FCDSC_DESC VARCHAR2(200) FCDSC_LAST_CHANGE_DATE NOT NULL DATE SQL> desc frequency_class_type Name Null? Type ----------------------------------------- -------- ---------------------------- FCTYP_UID NOT NULL NUMBER(6) FCTYP_NAME NOT NULL VARCHAR2(35) FCTYP_UNIT_REQUIRED_YN NOT NULL VARCHAR2(1) FCTYP_BOUNDS_REQUIRED_YN NOT NULL VARCHAR2(1) FCTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc habit Name Null? Type ----------------------------------------- -------- ---------------------------- HABIT_UID NOT NULL NUMBER(6) HABIT_NAME NOT NULL VARCHAR2(15) HABIT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc horizontal_collection_method Name Null? Type ----------------------------------------- -------- ---------------------------- HCMTH_UID NOT NULL NUMBER(6) HCMTH_NAME NOT NULL VARCHAR2(70) HCMTH_DESC VARCHAR2(150) HCMTH_LAST_CHANGE_DATE NOT NULL DATE SQL> desc horizontal_reference_datum Name Null? Type ----------------------------------------- -------- ---------------------------- HRDAT_UID NOT NULL NUMBER(6) HRDAT_NAME NOT NULL VARCHAR2(6) HRDAT_DESC NOT NULL VARCHAR2(45) HRDAT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc measurement_unit Name Null? Type ----------------------------------------- -------- ---------------------------- MSUNT_UID NOT NULL NUMBER(6) MSUNT_CD NOT NULL VARCHAR2(12) MSUNT_DESC VARCHAR2(200) MSUNT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc monitoring_location_type Name Null? Type ----------------------------------------- -------- ---------------------------- MLTYP_UID NOT NULL NUMBER(6) MLTYP_NAME NOT NULL VARCHAR2(45) MLTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc net_type Name Null? Type ----------------------------------------- -------- ---------------------------- NETTYP_UID NOT NULL NUMBER(6) SCETYP_UID NOT NULL NUMBER(6) NETTYP_NAME NOT NULL VARCHAR2(30) NETTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc organization_type Name Null? Type ----------------------------------------- -------- ---------------------------- ORG_TYPE NOT NULL VARCHAR2(30) SQL> desc phone_type Name Null? Type ----------------------------------------- -------- ---------------------------- PHTYP_UID NOT NULL NUMBER(6) PHTYP_NAME NOT NULL VARCHAR2(6) PHTYP_DESC VARCHAR2(200) PHTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc reference_location_type Name Null? Type ----------------------------------------- -------- ---------------------------- RLTYP_UID NOT NULL NUMBER(6) RLTYP_CD VARCHAR2(20) RLTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc relative_depth Name Null? Type ----------------------------------------- -------- ---------------------------- RELDPTH_UID NOT NULL NUMBER(6) RELDPTH_NAME NOT NULL VARCHAR2(15) RELDPTH_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_detection_condition Name Null? Type ----------------------------------------- -------- ---------------------------- RDCND_UID NOT NULL NUMBER(6) RDCND_NAME NOT NULL VARCHAR2(50) RDCND_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_measure_qualifier Name Null? Type ----------------------------------------- -------- ---------------------------- RMQLF_UID NOT NULL NUMBER(6) RMQLF_CD NOT NULL VARCHAR2(5) RMQLF_DESC VARCHAR2(300) RMQLF_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_statistical_base Name Null? Type ----------------------------------------- -------- ---------------------------- RSBAS_UID NOT NULL NUMBER(6) RSBAS_CD NOT NULL VARCHAR2(25) RSBAS_DESC VARCHAR2(200) RSBAS_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_status Name Null? Type ----------------------------------------- -------- ---------------------------- RESSTA_UID NOT NULL NUMBER(6) RESSTA_NAME NOT NULL VARCHAR2(12) RESSTA_DESC VARCHAR2(200) RESSTA_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_temperature_basis Name Null? Type ----------------------------------------- -------- ---------------------------- RTMPB_UID NOT NULL NUMBER(6) RTMPB_NAME NOT NULL VARCHAR2(12) RTMPB_DESC VARCHAR2(200) RTMPB_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_time_basis Name Null? Type ----------------------------------------- -------- ---------------------------- RTIMB_UID NOT NULL NUMBER(6) RTIMB_NAME NOT NULL VARCHAR2(12) RTIMB_DESC VARCHAR2(200) RTIMB_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_value_type Name Null? Type ----------------------------------------- -------- ---------------------------- RVTYP_UID NOT NULL NUMBER(6) RVTYP_NAME NOT NULL VARCHAR2(20) RVTYP_DESC VARCHAR2(200) RVTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc result_weight_basis Name Null? Type ----------------------------------------- -------- ---------------------------- RWBAS_UID NOT NULL NUMBER(6) RWBAS_NAME NOT NULL VARCHAR2(15) RWBAS_DESC VARCHAR2(200) RWBAS_LAST_CHANGE_DATE NOT NULL DATE SQL> desc sample_collection_equip Name Null? Type ----------------------------------------- -------- ---------------------------- SCEQP_UID NOT NULL NUMBER(6) SCETYP_UID NOT NULL NUMBER(6) SCEQP_NAME NOT NULL VARCHAR2(40) SCEQP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc sample_collection_equip_type Name Null? Type ----------------------------------------- -------- ---------------------------- SCETYP_UID NOT NULL NUMBER(6) SCETYP_NAME NOT NULL VARCHAR2(30) SCETYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc sample_fraction Name Null? Type ----------------------------------------- -------- ---------------------------- SMFRC_UID NOT NULL NUMBER(6) SMFRC_NAME NOT NULL VARCHAR2(25) SMFRC_DESC VARCHAR2(200) SMFRC_LAST_CHANGE_DATE NOT NULL DATE SQL> desc sample_tissue_anatomy Name Null? Type ----------------------------------------- -------- ---------------------------- STANT_UID NOT NULL NUMBER(6) STANT_NAME NOT NULL VARCHAR2(30) STANT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc sample_design_type ERROR: ORA-04043: object wqx.sample_design_type does not exist SQL> desc state Name Null? Type ----------------------------------------- -------- ---------------------------- ST_UID NOT NULL NUMBER(6) CNTRY_UID NOT NULL NUMBER(6) ST_CD NOT NULL VARCHAR2(2) ST_NAME NOT NULL VARCHAR2(35) ST_FIPS_CD NUMBER(4) ST_LAST_CHANGE_DATE NOT NULL DATE SQL> desc taxon Name Null? Type ----------------------------------------- -------- ---------------------------- TAX_UID NOT NULL NUMBER(6) TXRNK_UID NOT NULL NUMBER(6) TAX_NAME NOT NULL VARCHAR2(120) TAX_EXTRNL_ID NUMBER(12) TAX_STORET_ID NUMBER(12) TAX_SRS_ID NUMBER(12) TAX_RETIRED_NAME VARCHAR2(120) TAX_RETIRED_EXTRNL_ID NUMBER(12) TAX_LAST_CHANGE_DATE NOT NULL DATE TAX_DESCRIPTION VARCHAR2(1000) TAX_EXTRNL_ID_PARENT NUMBER(12) TAX_UID_KINGDOM NUMBER(6) SQL> desc taxon_rank Name Null? Type ----------------------------------------- -------- ---------------------------- TXRNK_UID NOT NULL NUMBER(6) TXRNK_NAME NOT NULL VARCHAR2(20) TXRNK_LAST_CHANGE_DATE NOT NULL DATE SQL> desc thermal_preservative Name Null? Type ----------------------------------------- -------- ---------------------------- THPRSV_UID NOT NULL NUMBER(6) THPRSV_NAME NOT NULL VARCHAR2(25) THPRSV_DESC VARCHAR2(200) THPRSV_LAST_CHANGE_DATE NOT NULL DATE SQL> desc time_zone Name Null? Type ----------------------------------------- -------- ---------------------------- TMZONE_UID NOT NULL NUMBER(6) TMZONE_CD NOT NULL VARCHAR2(5) TMZONE_NAME NOT NULL VARCHAR2(80) TMZONE_OFFSET NOT NULL NUMBER(4,2) TMZONE_LAST_CHANGE_DATE NOT NULL DATE SQL> desc toxicity_test_type Name Null? Type ----------------------------------------- -------- ---------------------------- TTTYP_UID NOT NULL NUMBER(6) TTTYP_NAME NOT NULL VARCHAR2(15) TTTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc tribe Name Null? Type ----------------------------------------- -------- ---------------------------- TRB_UID NOT NULL NUMBER(6) TRB_CD NOT NULL VARCHAR2(3) TRB_NAME NOT NULL VARCHAR2(120) TRB_LAST_CHANGE_DATE NOT NULL DATE SQL> desc vertical_collection_method Name Null? Type ----------------------------------------- -------- ---------------------------- VCMTH_UID NOT NULL NUMBER(6) VCMTH_NAME NOT NULL VARCHAR2(50) VCMTH_LAST_CHANGE_DATE NOT NULL DATE SQL> desc vertical_reference_datum Name Null? Type ----------------------------------------- -------- ---------------------------- VRDAT_UID NOT NULL NUMBER(6) VRDAT_NAME NOT NULL VARCHAR2(10) VRDAT_DESC NOT NULL VARCHAR2(45) VRDAT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc voltinism Name Null? Type ----------------------------------------- -------- ---------------------------- VOLT_UID NOT NULL NUMBER(6) VOLT_NAME NOT NULL VARCHAR2(25) VOLT_DESC VARCHAR2(200) VOLT_LAST_CHANGE_DATE NOT NULL DATE SQL> desc well_formation_type Name Null? Type ----------------------------------------- -------- ---------------------------- WFTYP_UID NOT NULL NUMBER(6) WFTYP_NAME NOT NULL VARCHAR2(50) WFTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> desc well_type Name Null? Type ----------------------------------------- -------- ---------------------------- WELTYP_UID NOT NULL NUMBER(6) WELTYP_NAME NOT NULL VARCHAR2(255) WELTYP_LAST_CHANGE_DATE NOT NULL DATE SQL> spool off