SET FEEDBACK OFF CREATE TABLE DAE_AUTHOR_A ( DAE_DS_HEADER_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(255) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_BD_ORD_CRIT_A ( DAE_EXCH_PROF_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_DELETE_CRIT_A ( DAE_IMPORT_DSC_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ELEMENTS_A ( DAE_ENUM_TY_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(255) NOT NULL, VALUE_L INTEGER NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_FILL_CRIT_A ( DAE_IMPORT_DSC_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ID_CRIT_A ( DAE_EXCH_PROF_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_INITIAL_CRIT_A ( DAE_EXPORT_DSC_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_MN_CNTN_CRIT_A ( DAE_EXCH_PROF_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ORGANIZATION_A ( DAE_DS_HEADER_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(255) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_QUALITY_RPT_A ( DAE_DS_HEADER_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(255) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_REFRESH_CRIT_A ( DAE_IMPORT_DSC_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_SCOPE_CRIT_A ( DAE_EXCH_PROF_S VARCHAR2(19) NOT NULL, VALUE VARCHAR2(2000) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CLASS ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, CLASSIFICATION_SYS VARCHAR2(40) , CLSN_CLS_NAME VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , START_DATE DATE , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CLSN ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, ACTIVITY_CLSN_S VARCHAR2(19) NOT NULL, ACTIVITY_S VARCHAR2(19) NOT NULL, ACTIVITY_T VARCHAR2(16) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_FULFL ( ACTIVITY_FULFL_S VARCHAR2(19) NOT NULL, FULFILLMENT_S VARCHAR2(19) NOT NULL, FULFILLMENT_T VARCHAR2(16) NOT NULL, FULFILL_S VARCHAR2(19) NOT NULL, FULFILL_T VARCHAR2(16) NOT NULL, RELATIVE_TIME NUMBER , RELATIVE_TIME_U VARCHAR2(15) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_TMPLT ( ACTIVITY_TMPLT_NM VARCHAR2(40) NOT NULL, ACTIVITY_TMPLT_S VARCHAR2(19) NOT NULL, DESCRIBED_ACT VARCHAR2(40) NOT NULL, DESCRIPTION VARCHAR2(2000) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACT_CAUSE_EFF ( ACT_CAUSE_EFF_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) NOT NULL, CAUSED_BY_T VARCHAR2(16) NOT NULL, DESCRIPTION VARCHAR2(2000) , INTENTIONAL CHAR(1) , RESULT_S VARCHAR2(19) NOT NULL, RESULT_T VARCHAR2(16) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACT_CLS_ALIAS ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, ACT_CLS_ALIAS_S VARCHAR2(19) NOT NULL, CLASSIFICATION_SYS VARCHAR2(40) NOT NULL, NAME VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACT_CLS_CLSN ( ACT_CLS_CLSN_S VARCHAR2(19) NOT NULL, BE_CLASSIFIED_AS_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , HAVE_AS_A_MEMBER_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , START_TIME DATE , STATUS VARCHAR2(11) , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACT_TMPLT_CSTR ( ACTIVITY_DURATION INTEGER , ACTIVITY_TMPLT_S VARCHAR2(19) NOT NULL, ACT_TMPLT_CSTR_S VARCHAR2(19) NOT NULL, CONSTRAINED_BY VARCHAR2(40) , CONSTRAINT_FOR VARCHAR2(40) NOT NULL, DESCRIPTION VARCHAR2(2000) , RELATIVE_TIME INTEGER , R_TMPLT_CSTR_KD_NM VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AIRCRAFT ( AIRCRAFT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ALOC_FLW_STRM ( ALOC_FLW_STRM_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , FLUID_COMPONENT_S VARCHAR2(19) NOT NULL, FLUID_COMPONENT_T VARCHAR2(16) NOT NULL, PFNU_PORT_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ALOW_FLW_STRM ( ALOW_FLW_STRM_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , FLUID_COMPONENT_S VARCHAR2(19) NOT NULL, FLUID_COMPONENT_T VARCHAR2(16) NOT NULL, PFNU_PORT_S VARCHAR2(19) NOT NULL, R_ALLOWABLE_KIND VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ANA_RSVR_ANAL ( ACTIVITY_NAME VARCHAR2(40) , ANA_RSVR_ANAL_S VARCHAR2(19) NOT NULL, CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ANCHORING_SYS ( ANCHORING_SYS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ANCHOR_WINCH ( ANCHOR_WINCH_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE APPLICATION_STA ( APPLICATION_STA_S VARCHAR2(19) NOT NULL, APP_FOR_PRMT_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_APP_STA_KIND VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE APP_CORD_TRFM ( APP_CORD_TRFM_S VARCHAR2(19) NOT NULL, COORDINATE_TRFM_ID VARCHAR2(40) NOT NULL, DESCRIPTION VARCHAR2(2000) , EDGE_S VARCHAR2(19) , EDGE_T VARCHAR2(16) , FACE_S VARCHAR2(19) , FACE_T VARCHAR2(16) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_CORD_SYS VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , TARGET_CORD_SYS VARCHAR2(40) NOT NULL, VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE APP_FOR_PRMT ( APPLICANT_S VARCHAR2(19) NOT NULL, APP_FOR_PRMT_S VARCHAR2(19) NOT NULL, CMPS_DOC_SPEC_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, INFORMATION_CNTN_S VARCHAR2(19) , PERMIT_SPEC_S VARCHAR2(19) , PERMIT_SPEC_T VARCHAR2(16) , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AQUIFER ( AQUIFER_NAME VARCHAR2(50) NOT NULL, AQUIFER_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_CELL ( AREA_CELL_ID VARCHAR2(40) NOT NULL, AREA_CELL_S VARCHAR2(19) NOT NULL, CELL_HEIGHT NUMBER NOT NULL, CELL_HEIGHT_U VARCHAR2(15) NOT NULL, CELL_ORNT_ANGL NUMBER NOT NULL, CELL_ORNT_ANGL_U VARCHAR2(15) NOT NULL, CELL_S VARCHAR2(19) NOT NULL, CELL_WIDTH NUMBER NOT NULL, CELL_WIDTH_U VARCHAR2(15) NOT NULL, HORIZONTAL_OFST NUMBER , HORIZONTAL_OFST_U VARCHAR2(15) , HORIZONTAL_SPC NUMBER NOT NULL, HORIZONTAL_SPC_U VARCHAR2(15) NOT NULL, VERTICAL_OFFSET NUMBER , VERTICAL_OFFSET_U VARCHAR2(15) , VERTICAL_SPACING NUMBER NOT NULL, VERTICAL_SPACING_U VARCHAR2(15) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_ELEMENT ( AREA_ELEMENT_S VARCHAR2(19) NOT NULL, CELL_S VARCHAR2(19) , DEPICTED_OBJECT_S VARCHAR2(19) , DEPICTED_OBJECT_T VARCHAR2(16) , DOCUMENT_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_T VARCHAR2(16) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, GRAPHICAL_ELE_ID VARCHAR2(40) NOT NULL, GRAPH_ELE_CMPN_S VARCHAR2(19) , IMAGE_PALET_TY_ID VARCHAR2(40) , PATTERN_FILL_TY_ID VARCHAR2(40) , PAT_ORNT_ANGL NUMBER , PAT_ORNT_ANGL_U VARCHAR2(15) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_PAT_FILL ( AREA_PAT_FILL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , PATTERN_FILL_TY_ID VARCHAR2(40) NOT NULL, R_COLOR_NAME VARCHAR2(40) , SYMBOL_LIBRARY_ID VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BINSET_GRID ( BINSET_GRID_S VARCHAR2(19) NOT NULL, BINSET_NAME VARCHAR2(40) NOT NULL, BINSET_UID INTEGER , BIN_NODE_DSC VARCHAR2(16) , BIN_NODE_NAME VARCHAR2(16) , BIN_SOURCE_EVENT VARCHAR2(16) , BIN_SRC_EVNT_LOG VARCHAR2(16) , BIN_STATION VARCHAR2(16) , BIN_STATION_RTO_D INTEGER , BIN_STATION_RTO_N INTEGER , DESCRIPTION VARCHAR2(2000) , GRID_STRUCTURED_S VARCHAR2(19) NOT NULL, GRID_STRUCTURED_T VARCHAR2(16) NOT NULL, R_BNST_GEOM_CLS_KD VARCHAR2(40) , SEISMIC_GEOM_SET_S VARCHAR2(19) NOT NULL, SEIS_PROC_ACT_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BINSET_GRID_VAR ( BINSET_GRID_S VARCHAR2(19) NOT NULL, BINSET_GRID_VAR_S VARCHAR2(19) NOT NULL, BINSET_NAME VARCHAR2(40) NOT NULL, BINSET_UID INTEGER , DESCRIPTION VARCHAR2(2000) , GRID_STRUCTURED_S VARCHAR2(19) NOT NULL, GRID_STRUCTURED_T VARCHAR2(16) NOT NULL, R_BNST_GEOM_CLS_KD VARCHAR2(40) , R_GRID_VARIANT_NM VARCHAR2(40) , SEIS_PROC_ACT_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BINSET_NTRS ( BINSET_GRID_S VARCHAR2(19) NOT NULL, BINSET_NTRS_NAME VARCHAR2(40) , BINSET_NTRS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INTERSECTED_GEOM_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BOREHOLE_CMPN ( BELONGS_TO_ASSY_L INTEGER , BELONGS_TO_ASSY_S VARCHAR2(19) , BELONGS_TO_ASSY_T VARCHAR2(16) , BOREHOLE_CMPN_S VARCHAR2(19) NOT NULL, BRHL_CMPN_LEN NUMBER , BRHL_CMPN_LEN_U VARCHAR2(15) , CRUSH_DAMAGE_RTO_D NUMBER , CRUSH_DAMAGE_RTO_N NUMBER , DESCRIPTION VARCHAR2(2000) , DIAMETER_CRSH_ZN NUMBER , DIAMETER_CRSH_ZN_U VARCHAR2(15) , DRILL_BOREHOLE_S VARCHAR2(19) , END_DATE DATE , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, OUTER_DIAMETER NUMBER , OUTER_DIAMETER_U VARCHAR2(15) , R_DIAMETER VARCHAR2(15) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_PERFORATION_KIND VARCHAR2(40) , SHOOT_PERF_S VARCHAR2(19) , SHOT_ANGLE NUMBER , SHOT_ANGLE_U VARCHAR2(15) , SHOT_COUNT INTEGER , SHOT_DENSITY NUMBER , SHOT_DENSITY_U VARCHAR2(15) , SHOT_DIAMETER NUMBER , SHOT_DIAMETER_U VARCHAR2(15) , SHOT_LENGTH NUMBER , SHOT_LENGTH_U VARCHAR2(15) , SHOT_PHASE NUMBER , SHOT_PHASE_U VARCHAR2(15) , START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) , WB_CMPN_FCL_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) NOT NULL, WELL_CMPL_1_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BOREHOLE_FL_SYS ( BOREHOLE_FL_SYS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BOUNDARY_CLASS ( BOUNDARY_CLASS_S VARCHAR2(19) NOT NULL, CLASSIFICATION_SYS VARCHAR2(40) , CLSN_CLS_NAME VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , START_DATE DATE , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BOUNDARY_CLSN ( BOUNDARY_CLASS_S VARCHAR2(19) NOT NULL, BOUNDARY_CLSN_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , FEATURE_BND_S VARCHAR2(19) NOT NULL, FEATURE_BND_T VARCHAR2(16) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BRHL_GNR_RUN ( ACTIVITY_NAME VARCHAR2(40) , BRHL_GNR_RUN_S VARCHAR2(19) NOT NULL, CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_ACT_TERM_RSN_NM VARCHAR2(40) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) , WELLBORE_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) , WELL_OPR_FL_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC ( BSASC_ID VARCHAR2(40) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , KIND VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) , START_DATE DATE ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_ACT_RLE ( ACTIVITY_S VARCHAR2(19) NOT NULL, ACTIVITY_T VARCHAR2(16) NOT NULL, BSASC_ACT_RLE_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BSASC_ACT_RLE_KD VARCHAR2(40) , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_ALIAS ( BSASC_ALIAS_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_FCL_ASN ( BSASC_FCL_ASN_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , FACILITY_S VARCHAR2(19) NOT NULL, FACILITY_T VARCHAR2(16) NOT NULL, R_BSASC_FCL_RLE_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_INJURY ( BSASC_INJURY_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INCDT_OF_NCOM_S VARCHAR2(19) , LOST_TIME NUMBER , LOST_TIME_U VARCHAR2(15) , MONETARY_LOSS NUMBER , MONETARY_LOSS_U VARCHAR2(15) , R_BSASC_INJURY_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_JOB_TITLE ( BSASC_JOB_TITLE_S VARCHAR2(19) NOT NULL, BSASN_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BSASC_JOB_TTL_KD VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_LFRLE ( BSASC_LFRLE_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , EARTH_SFTR_S VARCHAR2(19) NOT NULL, EARTH_SFTR_T VARCHAR2(16) NOT NULL, END_TIME DATE , R_BSASC_LFRLE_KIND VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_PRIVILEGE ( BSASC_PRIVILEGE_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, DATA_VALUE NUMBER , DATA_VALUE_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , GDLN_OR_PRIV_ID VARCHAR2(40) NOT NULL, R_BSASC_PRIV_KIND VARCHAR2(40) NOT NULL, TEXT LONG ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_SCTY_STA ( BSASC_S VARCHAR2(19) NOT NULL, BSASC_SCTY_STA_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BSASC_SCTY_KIND VARCHAR2(40) NOT NULL, R_BSASN_ROLE_KIND VARCHAR2(40) , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASC_SERVICE ( BSASC_S VARCHAR2(19) NOT NULL, BSASC_SERVICE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BSASC_SERVICE_KD VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BSASN ( ASSOCIATED_WITH_S VARCHAR2(19) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, BSASN_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BSASN_ROLE_KIND VARCHAR2(40) NOT NULL, R_BSASN_STRU_ID VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUILDING ( BUILDING_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BULK_STOR_SYS ( BULK_STOR_SYS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_CNTC ( BUSINESS_CNTC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , CONTACTEE_S VARCHAR2(19) NOT NULL, CONTACTOR_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_BUS_CNTC_PURP_KD VARCHAR2(40) , R_BUS_CNTC_RSLT_KD VARCHAR2(40) , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAP_PRS_CV ( CAP_PRS_CV_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , NONWETTING_PHASE_S VARCHAR2(19) NOT NULL, NONWETTING_PHASE_T VARCHAR2(16) NOT NULL, ROCK_FLUID_IACT_S VARCHAR2(19) NOT NULL, ROCK_FLUID_IACT_T VARCHAR2(16) NOT NULL, R_CAPILLARY_PRS_KD VARCHAR2(40) NOT NULL, WETTING_PHASE_S VARCHAR2(19) NOT NULL, WETTING_PHASE_T VARCHAR2(16) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAP_PRS_PT ( CAP_PRS_CV_S VARCHAR2(19) , CAP_PRS_PT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , NONWETTING_PHASE_S VARCHAR2(19) NOT NULL, NONWETTING_PHASE_T VARCHAR2(16) NOT NULL, ROCK_FLUID_IACT_S VARCHAR2(19) , ROCK_FLUID_IACT_T VARCHAR2(16) , R_CAPILLARY_PRS_KD VARCHAR2(40) NOT NULL, R_CAP_PRS_USE_KIND VARCHAR2(40) , WETTING_PHASE_S VARCHAR2(19) NOT NULL, WETTING_PHASE_T VARCHAR2(16) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CARTER_LSA ( CARTER_LSA_S VARCHAR2(19) NOT NULL, LSA_ID VARCHAR2(40) , RANGE INTEGER , R_EAST_OR_WEST_NM VARCHAR2(40) , R_NRTH_OR_SOUTH_KD VARCHAR2(40) , SUBDIVISION VARCHAR2(40) , TOWNSHIP INTEGER , TOWNSHIP_RNG_SECT INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CATALOG_EQP ( CATALOG_EQP_ID VARCHAR2(40) , CATALOG_EQP_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) , START_DATE DATE ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CATALOG_EQP_INSL ( CATALOG_EQP_INSL_S VARCHAR2(19) NOT NULL, CATALOG_EQP_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , FACILITY_S VARCHAR2(19) NOT NULL, FACILITY_T VARCHAR2(16) NOT NULL, ITEM_COUNT INTEGER , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CATALOG_IT_ASSY ( CATALOG_IT_ASSY_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , ITEM_COUNT INTEGER , PART_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CATALOG_IT_COLL ( CATALOG_IT_COLL_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , ITEM_COUNT INTEGER , PART_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_ALIAS ( CATALOG_EQP_S VARCHAR2(19) NOT NULL, CAT_EQP_ALIAS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_CLSN ( CAT_EQP_CLSN_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , EQUIPMENT_CLASS_S VARCHAR2(19) NOT NULL, MEMBER_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_CMPS ( CAT_EQP_CMPS_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , PART_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_MTRSPEC ( CATALOG_EQP_S VARCHAR2(19) NOT NULL, CAT_EQP_MTRSPEC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , TYPICAL_MTRL_S VARCHAR2(19) NOT NULL, TYPICAL_MTRL_T VARCHAR2(16) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_SUCC ( CAT_EQP_SUCC_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , SUCCEEDED_S VARCHAR2(19) NOT NULL, SUCCESSOR_S VARCHAR2(19) NOT NULL, TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAT_EQP_VERSION ( CAT_EQP_VERSION_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , ORIGINAL_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , VERSION_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CELL ( CELL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , SYMBOL_LIBRARY_ID VARCHAR2(40) NOT NULL, SYMBOL_TYPE_ID VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CEMENT ( CEMENT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(40) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CEMENT_CSG_STR ( ACTIVITY_NAME VARCHAR2(40) , CASING_STRING_S VARCHAR2(19) NOT NULL, CEMENT_CSG_STR_S VARCHAR2(19) NOT NULL, CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) , WELLBORE_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CEMENT_TYPE ( CEMENT_TYPE_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , TYPICAL_MTRL_NAME VARCHAR2(40) NOT NULL, VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CHEMICAL_ELE_TY ( CHEMICAL_ELE_TY_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , TYPICAL_MTRL_NAME VARCHAR2(40) NOT NULL, VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CHEM_CMPD_TY ( CHEM_CMPD_TY_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , TYPICAL_MTRL_NAME VARCHAR2(40) NOT NULL, VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CHOKE ( CHOKE_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CHOKE_ADJ_EVNT ( ACTIVITY_NAME VARCHAR2(40) , CHOKE_ADJ_EVNT_S VARCHAR2(19) NOT NULL, CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CLSN_SYS ( CLSN_SYS_NAME VARCHAR2(40) NOT NULL, CLSN_SYS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , KIND VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CMGL_PRMT ( APPLICATION_DATE DATE , CMGL_PRMT_S VARCHAR2(19) NOT NULL, CMPS_DOC_SPEC_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , INFORMATION_CNTN_S VARCHAR2(19) , ISSUED_BY_S VARCHAR2(19) , NOTIFICATION_DATE DATE , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CMPS_DOC_SPEC ( ACTIVITY_NAME VARCHAR2(40) , CMPS_DOC_SPEC_S VARCHAR2(19) NOT NULL, CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CMPS_GRAPH_ELE ( CELL_S VARCHAR2(19) , CMPS_GRAPH_ELE_S VARCHAR2(19) NOT NULL, DEPICTED_OBJECT_S VARCHAR2(19) , DEPICTED_OBJECT_T VARCHAR2(16) , DOCUMENT_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_T VARCHAR2(16) NOT NULL, GRAPHICAL_ELE_ID VARCHAR2(40) NOT NULL, GRAPH_ELE_CMPN_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CNGRS_LSA ( CNGRS_LSA_S VARCHAR2(19) NOT NULL, LOT_NUMBER INTEGER , LSA_ID VARCHAR2(40) , POLYGON_DSC VARCHAR2(2000) , PRINCIPAL_MERIDIAN VARCHAR2(40) , RANGE INTEGER , RANGE_FRACTION VARCHAR2(40) , R_EAST_OR_WEST_NM VARCHAR2(40) , R_NRTH_OR_SOUTH_KD VARCHAR2(40) , SECTION_SUFFIX CHAR(1) , SECTION_TYPE VARCHAR2(40) , SUBDIVISION VARCHAR2(2000) , TOWNSHIP INTEGER , TOWNSHIP_FRACTION VARCHAR2(40) , TOWNSHIP_NAME VARCHAR2(40) , TOWNSHIP_RNG_SECT INTEGER , TRACT_NUMBER INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COILED_TBG_REEL ( COILED_TBG_REEL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COILED_TBG_SECT ( COILED_TBG_SECT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COILED_TBG_UNT ( COILED_TBG_UNT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COILED_TUBING ( COILED_TUBING_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COLOR_PALETTE ( COLOR_PALETTE_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , IMAGE_PALET_TY_ID VARCHAR2(40) NOT NULL, SYMBOL_LIBRARY_ID VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACTUAL_OBL ( CONTRACTUAL_OBL_ID VARCHAR2(40) NOT NULL, CONTRACTUAL_OBL_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) NOT NULL, CONTRACT_T VARCHAR2(16) NOT NULL, DESCRIPTION VARCHAR2(2000) , DUE_DATE DATE , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , R_CONTRACT_OBL_KD VARCHAR2(40) , R_OBL_FREQ_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_ACT_TY ( CONTRACTUAL_OBL_S VARCHAR2(19) , CONTRACT_ACT_TY_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) , CONTRACT_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , TYPICAL_ACT_NAME VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_ALIAS ( CONTRACT_ALIAS_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) NOT NULL, CONTRACT_T VARCHAR2(16) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_CLAUSE ( AMENDMENT_DATE DATE , AMEND_CTRT_CLSE_S VARCHAR2(19) , CONTRACT_CLAUSE_NM VARCHAR2(40) , CONTRACT_CLAUSE_S VARCHAR2(19) NOT NULL, CONTRACT_L INTEGER , CONTRACT_S VARCHAR2(19) , CONTRACT_T VARCHAR2(16) , CTRT_CLSE_SET_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, R_CLSE_AMND_RSN_NM VARCHAR2(40) , R_CONTRACT_CLSE_KD VARCHAR2(40) , TEXT LONG , TEXT_LOCATION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_DSGN ( ACCOUNT_NUMBER VARCHAR2(2000) , ADDRESS_S VARCHAR2(19) , ADDRESS_T VARCHAR2(16) , AMOUNT NUMBER , AMOUNT_U VARCHAR2(15) , BSASC_ROLE VARCHAR2(40) NOT NULL, BSASC_S VARCHAR2(19) NOT NULL, CONTRACTUAL_OBL_S VARCHAR2(19) , CONTRACT_DSGN_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) , CONTRACT_T VARCHAR2(16) , DEPOSITORY_DSGN_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, EXPIRY_DATE DATE , KIND VARCHAR2(40) , PERCENT NUMBER , R_HOLD_OR_PAY_KIND VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_REF ( CONTRACT_REF_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , FOR_CONTRACT_S VARCHAR2(19) NOT NULL, FOR_CONTRACT_T VARCHAR2(16) NOT NULL, FROM_CONTRACT_S VARCHAR2(19) NOT NULL, FROM_CONTRACT_T VARCHAR2(16) NOT NULL, R_CTRT_REF_USE_NM VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_REMARK ( BSASC_S VARCHAR2(19) , CONTRACT_L INTEGER , CONTRACT_REMARK_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) , CONTRACT_T VARCHAR2(16) , REMARK LONG NOT NULL, REMARK_DATE DATE ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_STATUS ( CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , CONTRACT_S VARCHAR2(19) NOT NULL, CONTRACT_STATUS_S VARCHAR2(19) NOT NULL, CONTRACT_T VARCHAR2(16) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_CONTRACT_STA_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_SYS ( COORDINATE_SYS_ID VARCHAR2(40) NOT NULL, COORDINATE_SYS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, GEODETIC_DATUM_ID VARCHAR2(80) , PRIME_MERIDIAN_ID VARCHAR2(40) , R_AXIS_ORNT_KIND VARCHAR2(40) , R_CORD_SYS_CSTR_NM VARCHAR2(40) NOT NULL, R_DISPLAY_ORNT VARCHAR2(40) , R_MAP_PROJ_KIND VARCHAR2(40) , R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) , VERTEX_S VARCHAR2(19) , VERTEX_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_TRFM ( COORDINATE_TRFM_ID VARCHAR2(40) NOT NULL, COORDINATE_TRFM_S VARCHAR2(19) NOT NULL, CORD_TRFM_MTH_ID VARCHAR2(40) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_TRFM_CSTR_NAME VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COO_AGREEMENT ( BSASC_S VARCHAR2(19) , CMPS_DOC_SPEC_S VARCHAR2(19) , COO_AGREEMENT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , EFFECTIVE_DATE DATE , EXECUTION_DATE DATE , EXPIRY_DATE DATE , INFORMATION_CNTN_S VARCHAR2(19) , ORIGINAL_EXPIRY_DT DATE , RECORDED_DATE DATE , RECORDED_LINE VARCHAR2(40) , RECORDED_PAGE VARCHAR2(40) , RECORDED_VOLUME VARCHAR2(40) , R_NAMING_SYSTEM_KD VARCHAR2(40) , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_SYS_ALIAS ( COORDINATE_SYS_ID VARCHAR2(40) NOT NULL, CORD_SYS_ALIAS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_SYS_AXIS ( CORD_SYS_AXIS_S VARCHAR2(19) NOT NULL, CORD_SYS_ID VARCHAR2(40) , CORD_SYS_ID_L INTEGER , DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, MEASUREMENT_DTM_S VARCHAR2(19) , MEASUREMENT_DTM_T VARCHAR2(16) , NORMAL_TO_DATUM_S VARCHAR2(19) , NORMAL_TO_DATUM_T VARCHAR2(16) , R_AXIS_ORNT_KIND VARCHAR2(40) , R_PROPERTY_TYPE_NM VARCHAR2(40) NOT NULL, R_VAXIS_ORNT_NAME VARCHAR2(40) , SOURCE VARCHAR2(40) , SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) , VERTICAL_DATUM_S VARCHAR2(19) , VERTICAL_DATUM_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_TRFM_ACT ( ACTIVITY_NAME VARCHAR2(40) , APP_CORD_TRFM_S VARCHAR2(19) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , CORD_TRFM_ACT_S VARCHAR2(19) NOT NULL, COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_TRFM_MTH ( CORD_TRFM_MTH_ID VARCHAR2(40) NOT NULL, CORD_TRFM_MTH_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_CORD_TRFM_KIND VARCHAR2(40) NOT NULL, SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_TRFM_PAR ( CORD_TRFM_MTH_ID VARCHAR2(40) NOT NULL, CORD_TRFM_PAR_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , R_CORD_TRFM_PAR_NM VARCHAR2(40) NOT NULL, SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORD_TRFM_VAL ( COORDINATE_TRFM_ID VARCHAR2(40) NOT NULL, CORD_TRFM_PAR_S VARCHAR2(19) NOT NULL, CORD_TRFM_VAL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INTEGER_VALUE INTEGER , LOCATION_VALUE VARCHAR2(16) , QUANTITY_VALUE NUMBER , QUANTITY_VALUE_U VARCHAR2(15) , REAL_VALUE NUMBER , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , STRING_VALUE VARCHAR2(40) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CORE ( BOTTOM_DEPTH NUMBER , BOTTOM_DEPTH_U VARCHAR2(15) , BRHL_GNR_RUN_S VARCHAR2(19) , CORE_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INVENTORY_OBJ_ID VARCHAR2(40) , K NUMBER , KH_90_DEGREE NUMBER , KH_90_DEGREE_U VARCHAR2(15) , KH_MAX NUMBER , KH_MAX_U VARCHAR2(15) , KIND VARCHAR2(40) , K_U VARCHAR2(15) , PRODUCED_BY_ACT_S VARCHAR2(19) , PRODUCED_BY_ACT_T VARCHAR2(16) , ROCK_MATERIAL_S VARCHAR2(19) , ROCK_MATERIAL_T VARCHAR2(16) , R_DIAMETER_NAME VARCHAR2(15) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE_ACTIVITY_S VARCHAR2(19) , SOURCE_ACTIVITY_T VARCHAR2(16) , TOP_DEPTH NUMBER , TOP_DEPTH_U VARCHAR2(15) , WRLN_LOG_PASS_S VARCHAR2(19) , WTST_RECOVERY_S VARCHAR2(19) , WTST_RECOVERY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CTRT_CLSE_IT ( CONTRACT_CLAUSE_S VARCHAR2(19) NOT NULL, CTRT_CLSE_IT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , ITEM_COUNT INTEGER , ITEM_DATE DATE , ITEM_QUANTITY NUMBER , ITEM_QUANTITY_U VARCHAR2(15) , MONETARY_VALUE NUMBER , MONETARY_VALUE_U VARCHAR2(15) , R_CTRT_CLSE_IT_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CTRT_CLSE_SET ( CMPS_DOC_SPEC_S VARCHAR2(19) , CTRT_CLSE_SET_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, INFORMATION_CNTN_S VARCHAR2(19) , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CTRT_PROC_OPR ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , CTRT_PROC_OPR_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CURVE_FIT_ACT ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , CURVE_FIT_ACT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DIAGRAM_SPEC_S VARCHAR2(19) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_AGGR_TY ( DAE_AGGR_TY_S VARCHAR2(19) NOT NULL, ELEMENT_DOMAIN_S VARCHAR2(19) NOT NULL, ELEMENT_DOMAIN_T VARCHAR2(16) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, LOWER_BOUND INTEGER , SPARSE_FLAG CHAR(1) , SUBSET_FLAG CHAR(1) , UNIQUE_FLAG CHAR(1) , UPPER_BOUND INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_APPLICATION ( DAE_APPLICATION_NM VARCHAR2(40) NOT NULL, DAE_APPLICATION_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) NOT NULL, VENDOR VARCHAR2(40) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_APP_PREFER ( APPLICATION_S VARCHAR2(19) NOT NULL, DAE_APP_PREFER_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, OWNER_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ATR_ATHR ( ATTRIBUTE_DEF_S VARCHAR2(19) NOT NULL, CREATED DATE NOT NULL, DAE_ATR_ATHR_S VARCHAR2(19) NOT NULL, GRANTABLE CHAR(1) NOT NULL, GRANTEE_S VARCHAR2(19) NOT NULL, GRANTOR_S VARCHAR2(19) NOT NULL, PRIVILEGE VARCHAR2(11) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ATR_DEF ( ATTRIBUTE_DOMAIN_S VARCHAR2(19) NOT NULL, ATTRIBUTE_DOMAIN_T VARCHAR2(16) NOT NULL, DAE_ATR_DEF_NAME VARCHAR2(40) NOT NULL, DAE_ATR_DEF_S VARCHAR2(19) NOT NULL, DUPLICATES CHAR(1) , ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, EXTENSION_FLAG CHAR(1) , INVERTED_ATTR_S VARCHAR2(19) , MAX_CARDINALITY INTEGER , MIN_CARDINALITY INTEGER , OPTIONAL_FLAG CHAR(1) , PARENT_ENTITY_S VARCHAR2(19) NOT NULL, SUBSET_FLAG CHAR(1) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_DATA_STORE ( CREATED DATE NOT NULL, DAE_DATA_STORE_NM VARCHAR2(40) NOT NULL, DAE_DATA_STORE_S VARCHAR2(19) NOT NULL, DATA_STORE_TYPE VARCHAR2(17) NOT NULL, EXPRESS_FILENAME VARCHAR2(255) , OWNER_S VARCHAR2(19) NOT NULL, PARENT_S VARCHAR2(19) , SERVER_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_DIMENSION ( COUNT_VAL INTEGER NOT NULL, DAE_DIMENSION_S VARCHAR2(19) NOT NULL, DAE_I_TYPE INTEGER NOT NULL, GRID_1D_S VARCHAR2(19) , LOWER_BOUND INTEGER NOT NULL, ORDINAL INTEGER NOT NULL, PARENT_FRAME_L INTEGER , PARENT_FRAME_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_DSTORE_ROOT ( ALWAYS_TRUE CHAR(1) NOT NULL, DAE_DSTORE_ROOT_S VARCHAR2(19) NOT NULL, DEFINING_DSC_S VARCHAR2(19) NOT NULL, FACILITY_UUID VARCHAR2(255) , NAME VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_DS_HEADER ( AUTHORIZATIONS VARCHAR2(80) NOT NULL, DAE_DS_HEADER_S VARCHAR2(19) NOT NULL, DATA_MODEL_ID VARCHAR2(255) , DATA_MODEL_VERSION VARCHAR2(255) , DESCRIPTION VARCHAR2(2000) , FACILITY_UUID VARCHAR2(255) , IMPORTED_USING_S VARCHAR2(19) , NAME VARCHAR2(40) NOT NULL, ORIGINATING_SYSTEM VARCHAR2(80) , PREPRC_VERSION VARCHAR2(80) , TIME_STAMP VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ENTITY_ATHR ( CREATED DATE NOT NULL, DAE_ENTITY_ATHR_S VARCHAR2(19) NOT NULL, ENTITY_DEF_S VARCHAR2(19) NOT NULL, GRANTABLE CHAR(1) NOT NULL, GRANTEE_S VARCHAR2(19) NOT NULL, GRANTOR_S VARCHAR2(19) NOT NULL, PRIVILEGE VARCHAR2(11) NOT NULL, SEARCH_CONDITION VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ENTITY_DEF ( COMPLEX_FLAG CHAR(1) NOT NULL, DAE_ENTITY_DEF_NM VARCHAR2(40) NOT NULL, DAE_ENTITY_DEF_S VARCHAR2(19) NOT NULL, EXTENSION_FLAG CHAR(1) , INDEPENDENT CHAR(1) NOT NULL, INSTANTIABLE CHAR(1) NOT NULL, OWNING_DATASTORE_S VARCHAR2(19) , SUBSET_FLAG CHAR(1) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ENUM_TY ( DAE_ENUM_TY_NAME VARCHAR2(40) NOT NULL, DAE_ENUM_TY_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_EPCNT_DTYPE ( COORDINATE_SYSTEMS VARCHAR2(40) , COORD_PRECISION INTEGER , CURRENCY VARCHAR2(15) , DAE_EPCNT_DTYPE_NM VARCHAR2(40) NOT NULL, DAE_EPCNT_DTYPE_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, FRACTIONAL_SECONDS INTEGER , GRID_ELEMENT VARCHAR2(17) , PROPERTY_PRECISION INTEGER , PROPERTY_TYPES VARCHAR2(40) , REAL_PRECISION INTEGER , REPRESENTATION_TY VARCHAR2(7) , R_QUANTITY_TYPE_NM VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_EXCH_PROF ( DAE_EXCH_PROF_S VARCHAR2(19) NOT NULL, DATA_MODEL_ID VARCHAR2(255) , DATA_MODEL_VERSION VARCHAR2(255) , DESCRIPTION VARCHAR2(2000) , NAME VARCHAR2(40) NOT NULL, NAMESPACE VARCHAR2(40) NOT NULL, VERSION VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_EXPORT_DSC ( DAE_EXPORT_DSC_NM VARCHAR2(40) NOT NULL, DAE_EXPORT_DSC_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EXCHANGE_SET_S VARCHAR2(19) , EXTRACT_FROM_S VARCHAR2(19) , PROFILE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_FACILITY ( API_NAME VARCHAR2(40) NOT NULL, API_VENDOR VARCHAR2(40) NOT NULL, API_VERSION VARCHAR2(40) NOT NULL, DAE_FACILITY_NAME VARCHAR2(40) NOT NULL, DAE_FACILITY_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_FRAME ( ATTRIBUTE_NAME VARCHAR2(40) NOT NULL, BDAL_NAME VARCHAR2(40) , COORDINATE_SYS_ID VARCHAR2(40) , DAE_FRAME_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, E_TYPE INTEGER NOT NULL, F_TYPE INTEGER NOT NULL, GRID_S VARCHAR2(19) , GRID_T VARCHAR2(16) , INSTANCE_S VARCHAR2(19) NOT NULL, INSTANCE_T VARCHAR2(16) NOT NULL, REC_KEY VARCHAR2(40) , VERTEX_S VARCHAR2(19) , VERTEX_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_IMPORT_DSC ( DAE_IMPORT_DSC_NM VARCHAR2(40) NOT NULL, DAE_IMPORT_DSC_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DESTINATION_S VARCHAR2(19) , PROFILE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_LEAF_FRAME ( BDAL_NAME VARCHAR2(40) , DAE_LEAF_FRAME_S VARCHAR2(19) NOT NULL, FIRST_VALUE NUMBER , INVAL_EVNT_CNT INTEGER , LAST_VALUE NUMBER , MAXIMUM_VALUE NUMBER , MEAN_VALUE NUMBER , MINIMUM_VALUE NUMBER , PARENT_FRAME_L INTEGER , PARENT_FRAME_S VARCHAR2(19) , POPULATION_COUNT INTEGER , PROPERTY_AXIS_S VARCHAR2(19) , PROPERTY_TYPE_S VARCHAR2(19) NOT NULL, REC_KEY VARCHAR2(40) , STANDARD_DEV NUMBER , UNIT_ACRONYM VARCHAR2(15) , VALUE_FORMULA VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_QNT_UNT ( DAE_QNT_UNT_S VARCHAR2(19) NOT NULL, QUANTITY_TYPE VARCHAR2(40) NOT NULL, UNIT VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ROLE ( CREATED DATE NOT NULL, DAE_ROLE_NAME VARCHAR2(40) NOT NULL, DAE_ROLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ROLE_ATHR ( CREATED DATE NOT NULL, DAE_ROLE_ATHR_S VARCHAR2(19) NOT NULL, GRANTABLE CHAR(1) NOT NULL, GRANTEE_S VARCHAR2(19) NOT NULL, GRANTOR_S VARCHAR2(19) NOT NULL, USER_ROLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_ROLE_PRIV ( ATTRIBUTE_DEF_S VARCHAR2(19) , DAE_ROLE_PRIV_S VARCHAR2(19) NOT NULL, DAE_ROLE_S VARCHAR2(19) , ENTITY_DEF_S VARCHAR2(19) , PRIVILEGE VARCHAR2(11) NOT NULL, SEARCH_CONDITION VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_SERVER ( DAE_SERVER_NAME VARCHAR2(40) NOT NULL, DAE_SERVER_S VARCHAR2(19) NOT NULL, VENDOR VARCHAR2(40) NOT NULL, VERSION VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_SIMPLE_TYPE ( DAE_SIMPLE_TYPE_NM VARCHAR2(40) NOT NULL, DAE_SIMPLE_TYPE_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, FIXED_FLAG CHAR(1) , REAL_PRECISION INTEGER , WIDTH INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_SWTCH_RULE ( DAE_SWTCH_RULE_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, FAILURE_ACTION VARCHAR2(5) NOT NULL, FIXUP_NAME VARCHAR2(40) , LABEL VARCHAR2(40) , PARENT_DATASTORE_S VARCHAR2(19) , PARENT_ENTITY_S VARCHAR2(19) , SECONDARY_ID CHAR(1) , SUBSET_FLAG CHAR(1) , TEST_NAME VARCHAR2(40) NOT NULL, TEST_STATUS VARCHAR2(9) NOT NULL, TYPE_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAE_USER ( CREATED DATE NOT NULL, CREATE_DATA_STORE CHAR(1) NOT NULL, DAE_USER_ID VARCHAR2(40) NOT NULL, DAE_USER_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAMAGE_AREA ( DAMAGE_AREA_ID VARCHAR2(40) , DAMAGE_AREA_S VARCHAR2(19) NOT NULL, INCDT_OF_NCOM_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DATA_COLLECTION ( ACTIVITY_S VARCHAR2(19) , ACTIVITY_T VARCHAR2(16) , BSASC_S VARCHAR2(19) , DATA_COLLECTION_NM VARCHAR2(40) , DATA_COLLECTION_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_S VARCHAR2(19) , DOCUMENT_SPEC_T VARCHAR2(16) , POPULATED_BY_S VARCHAR2(19) , POPULATED_BY_T VARCHAR2(16) , PROCESS_PAR_S VARCHAR2(19) , R_DATA_COLL_TY_NM VARCHAR2(40) , UPDATED_BY_S VARCHAR2(19) , UPDATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DECLINE_ANAL ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DECLINE_ANAL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DERV_INT_MKUP ( CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DERV_INT_MKUP_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , FRACTION NUMBER , INTEREST_FOR_S VARCHAR2(19) NOT NULL, INTEREST_FOR_T VARCHAR2(16) NOT NULL, INTEREST_OF_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIAGRAM_SPEC ( CMPS_DOC_SPEC_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DIAGRAM_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, INFORMATION_CNTN_S VARCHAR2(19) , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIGITAL_STOR_FCL ( DESCRIPTION VARCHAR2(2000) , DIGITAL_STOR_FCL_S VARCHAR2(19) NOT NULL, END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIGITIZE_DOC ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DIGITIZE_DOC_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , SOURCE_DOCUMENT_S VARCHAR2(19) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIR_SRVY_ANAL ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DIR_SRVY_ANAL_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DISCOVERY_AREA ( APPLICATION_DATE DATE , DECLARATION_DATE DATE , DESCRIPTION VARCHAR2(2000) , DISCOVERY_AREA_S VARCHAR2(19) NOT NULL, EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, R_DISC_AREA_KIND VARCHAR2(40) , R_NAMING_SYSTEM_KD VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIVESTMENT_PKG ( CLOSING_DATE DATE , DIVESTMENT_PKG_NM VARCHAR2(40) NOT NULL, DIVESTMENT_PKG_S VARCHAR2(19) NOT NULL, PART_OF_S VARCHAR2(19) , RESPONSE_DUE_DATE DATE , R_SALE_KIND VARCHAR2(40) , SALE_DATE DATE , SALE_EFFECTIVE_DT DATE , SALE_OFFER_DATE DATE ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT ( DIGITIZE_DOC_S VARCHAR2(19) , DOCUMENT_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_T VARCHAR2(16) NOT NULL, ENTITY_TYPE_NM VARCHAR2(40) NOT NULL, INVENTORY_OBJ_ID VARCHAR2(40) , RENDER_DOCUMENT_S VARCHAR2(19) , R_DIGITAL_FMT_KIND VARCHAR2(40) , R_HARDCOPY_DOC_NM VARCHAR2(40) , R_NAMING_SYSTEM_KD VARCHAR2(40) , TITLE VARCHAR2(40) , X_SCALE_D INTEGER , X_SCALE_N INTEGER , Y_SCALE_D INTEGER , Y_SCALE_N INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_CIRC ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_CIRC_S VARCHAR2(19) NOT NULL, DOCUMENT_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOC_SPEC_CLCLSN ( BE_CLASSIFIED_AS_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DOC_SPEC_CLCLSN_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , HAVE_AS_A_MEMBER_S VARCHAR2(19) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , START_TIME DATE , STATUS VARCHAR2(11) , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOC_SPEC_CLS ( CLASSIFICATION_SYS VARCHAR2(40) , CLSN_CLS_NAME VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(2000) , DOC_SPEC_CLS_S VARCHAR2(19) NOT NULL, END_DATE DATE , SOURCE VARCHAR2(40) NOT NULL, SOURCE_REFERENCE_S VARCHAR2(19) , START_DATE DATE , STATUS VARCHAR2(11) , VERSION VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOC_SPEC_CLSN ( CAUSED_BY_S VARCHAR2(19) , CAUSED_BY_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_T VARCHAR2(16) NOT NULL, DOC_SPEC_CLSN_S VARCHAR2(19) NOT NULL, DOC_SPEC_CLS_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TERMINATED_BY_S VARCHAR2(19) , TERMINATED_BY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOC_SPEC_PLACE ( AXIS_ROT_ANGL NUMBER , AXIS_ROT_ANGL_U VARCHAR2(15) , DOC_SPEC_PLACE_S VARCHAR2(19) NOT NULL, PLACEMENT_OF_S VARCHAR2(19) NOT NULL, PLACEMENT_OF_T VARCHAR2(16) NOT NULL, PLACE_WITHIN_S VARCHAR2(19) NOT NULL, PLACE_WITHIN_T VARCHAR2(16) NOT NULL, X_OFFSET NUMBER , X_SCALE NUMBER , Y_OFFSET NUMBER , Y_SCALE NUMBER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOMINION_LSA ( DOMINION_LSA_S VARCHAR2(19) NOT NULL, LSA_ID VARCHAR2(40) , MERIDIAN VARCHAR2(40) , RANGE INTEGER , RANGE_MODIFIER CHAR(1) , R_EAST_OR_WEST_NM VARCHAR2(40) , SUBDIVISION INTEGER , TOWNSHIP INTEGER , TOWNSHIP_MODIFIER CHAR(1) , TOWNSHIP_RNG_SECT INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLING_FCL ( DESCRIPTION VARCHAR2(2000) , DRILLING_FCL_S VARCHAR2(19) NOT NULL, END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLING_KICK ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DRILLING_KICK_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) , WELLBORE_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLING_KICK_FL ( DRILLING_KICK_FL_S VARCHAR2(19) NOT NULL, DRILLING_KICK_L INTEGER , DRILLING_KICK_S VARCHAR2(19) , DRILLSTRING_S VARCHAR2(19) , FLUID_PHASE_S VARCHAR2(19) NOT NULL, FLUID_PHASE_T VARCHAR2(16) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLING_PERMIT ( APPLICATION_DATE DATE , CMPS_DOC_SPEC_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPEC_ID VARCHAR2(40) NOT NULL, DRILLING_PERMIT_S VARCHAR2(19) NOT NULL, EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , INFORMATION_CNTN_S VARCHAR2(19) , ISSUED_BY_S VARCHAR2(19) , NOTIFICATION_DATE DATE , TYP_DOC_SPEC_ID VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLING_RIG ( DESCRIPTION VARCHAR2(2000) , DRILLING_RIG_S VARCHAR2(19) NOT NULL, END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILLSTEM_TEST ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DRILLSTEM_TEST_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TEMPORARY_CMPL_S VARCHAR2(19) , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) , WELLBORE_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILL_BOREHOLE ( ACTIVITY_NAME VARCHAR2(40) , CONTAINING_ACT_S VARCHAR2(19) , CONTAINING_ACT_T VARCHAR2(16) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DRILL_BOREHOLE_S VARCHAR2(19) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(40) , START_TIME DATE , TYPICAL_ACT_NAME VARCHAR2(40) , UTILIZE_EQP_S VARCHAR2(19) , WELLBORE_ID VARCHAR2(40) , WELLBORE_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRILL_CUT_SAM ( BRHL_GNR_RUN_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DRILL_CUT_SAM_S VARCHAR2(19) NOT NULL, INVENTORY_OBJ_ID VARCHAR2(40) , PRODUCED_BY_ACT_S VARCHAR2(19) , PRODUCED_BY_ACT_T VARCHAR2(16) , ROCK_MATERIAL_S VARCHAR2(19) , ROCK_MATERIAL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, R_NAMING_SYSTEM_KD VARCHAR2(40) , SOURCE_ACTIVITY_S VARCHAR2(19) , SOURCE_ACTIVITY_T VARCHAR2(16) , WTST_RECOVERY_S VARCHAR2(19) , WTST_RECOVERY_T VARCHAR2(16) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DRL_DRCK_SYS ( DESCRIPTION VARCHAR2(2000) , DESIGN VARCHAR2(2000) , DRL_DRCK_SYS_S VARCHAR2(19) NOT NULL, END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DST_RECOVERY ( DESCRIPTION VARCHAR2(2000) , DRILLSTEM_TEST_S VARCHAR2(19) NOT NULL, DST_RECOVERY_S VARCHAR2(19) NOT NULL, FLUID_COMPONENT_S VARCHAR2(19) , FLUID_COMPONENT_T VARCHAR2(16) , FLUID_PHASE_S VARCHAR2(19) , FLUID_PHASE_T VARCHAR2(16) , IDENTIFIER VARCHAR2(40) NOT NULL, RSVR_FL_SYS_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DYNAMIC_POS_SYS ( DESCRIPTION VARCHAR2(2000) , DYNAMIC_POS_SYS_S VARCHAR2(19) NOT NULL, END_DATE DATE , GENERAL_FCL_NAME VARCHAR2(40) , IDENTIFYING_FCL_S VARCHAR2(19) , IDENTIFYING_FCL_T VARCHAR2(16) , R_EXISTENCE_KD_NM VARCHAR2(40) NOT NULL, START_DATE DATE , TYPICAL_FCL_NAME VARCHAR2(40) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DYN_GRAPH_ELE ( CELL_S VARCHAR2(19) , DEPICTED_OBJECT_S VARCHAR2(19) , DEPICTED_OBJECT_T VARCHAR2(16) , DOCUMENT_SPEC_S VARCHAR2(19) NOT NULL, DOCUMENT_SPEC_T VARCHAR2(16) NOT NULL, DYN_GRAPH_ELE_S VARCHAR2(19) NOT NULL, GRAPHICAL_ELE_ID VARCHAR2(40) NOT NULL, GRAPH_ELE_CMPN_S VARCHAR2(19) , PREDICATE_TYPE_KD VARCHAR2(40) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE EARTH_MODEL ( EARTH_MODEL_ID VARCHAR2(40) NOT NULL, EARTH_MODEL_S VARCHAR2(19) NOT NULL, GEOSCIENCE_NTRP_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE EARTH_POS_CMPS ( BINSET_S VARCHAR2(19) , BINSET_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , EARTH_POS_CMPS_S VARCHAR2(19) NOT NULL, EMODEL_OBJECT_ID VARCHAR2(40) , GEOLOGIC_FTR_S VARCHAR2(19) , GEOLOGIC_FTR_T VARCHAR2(16) , GEOSCIENCE_NTRP_S VARCHAR2(19) , ROCK_FTR_PART_S VARCHAR2(19) , ROCK_FTR_PART_T VARCHAR2(16) , SYN_LOG_TRC_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE EARTH_POS_EDG ( BINSET_S VARCHAR2(19) , BINSET_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , EARTH_POS_EDG_S VARCHAR2(19) NOT NULL, EMODEL_OBJECT_ID VARCHAR2(40) , GEOLOGIC_FTR_S VARCHAR2(19) , GEOLOGIC_FTR_T VARCHAR2(16) , GEOSCIENCE_NTRP_S VARCHAR2(19) , ID_WHOLE_S VARCHAR2(19) , ROCK_FTR_PART_S VARCHAR2(19) , ROCK_FTR_PART_T VARCHAR2(16) , SEIS_GEOM_SET_S VARCHAR2(19) , SYN_LOG_TRC_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE EARTH_POS_FACE ( BINSET_S VARCHAR2(19) , BINSET_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , EARTH_POS_FACE_S VARCHAR2(19) NOT NULL, EMODEL_OBJECT_ID VARCHAR2(40) , GEOLOGIC_FTR_S VARCHAR2(19) , GEOLOGIC_FTR_T VARCHAR2(16) , GEOSCIENCE_NTRP_S VARCHAR2(19) , ID_WHOLE_S VARCHAR2(19) , ROCK_FTR_PART_S VARCHAR2(19) , ROCK_FTR_PART_T VARCHAR2(16) , SEIS_GEOM_SET_S VARCHAR2(19) , SYN_LOG_TRC_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE EARTH_POS_RGN ( BINSET_S VARCHAR2(19) , BINSET_T VARCHAR2(16) , DESCRIPTION VARCHAR2(2000) , EARTH_POS_RGN_S VARCHAR2(19) NOT NULL, EMODEL_OBJECT_ID VARCHAR2(40) , GEOLOGIC_FTR_S VARCHAR2(19) , GEOLOGIC_FTR_T VARCHAR2(16)