SET FEEDBACK OFF CREATE TABLE DATA_VALUE_A ( P_GEOMETRY_2D_GIS_S VARCHAR2(19) NOT NULL, VALUE NUMBER NOT NULL, VALUE_L INTEGER NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY ( ACTIVITY_CONTEXT_S VARCHAR2(19) , ACTIVITY_CONTEXT_T VARCHAR2(30) , CONTAINING_ACTIVITY_S VARCHAR2(19) , COST NUMBER , COST_U VARCHAR2(15) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , R_EXISTENCE_KIND VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ( CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INVOLVED_ACTIVITY_S VARCHAR2(19) NOT NULL, INVOLVEMENT_ROLE VARCHAR2(80) NOT NULL, INVOLVING_ACTIVITY_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_ALIAS ( ALIASED_OBJECT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CAUSE_AND_EFFECT ( CAUSED_BY_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INTENTIONAL CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , RESULT_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CLASS ( ARCHETYPE_TYPICAL_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , END_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , PARENT_CLASS_S VARCHAR2(19) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , START_DATE DATE , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CLASSIFICATION ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, ACTIVITY_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_CLASS_CLASSIFICATION ( BE_CLASSIFIED_AS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , HAVE_AS_A_MEMBER_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_FULFILLMENT ( DESCRIPTION VARCHAR2(2000) , FULFILLMENT_S VARCHAR2(19) NOT NULL, FULFILL_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , RELATIVE_TIME NUMBER , RELATIVE_TIME_U VARCHAR2(15) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_SUBJECT_TO_GUIDELINE ( ACTIVITY_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , GUIDELINE_OR_PRIVILEGE_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_TEMPLATE ( DESCRIBED_ACTIVITY_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_TEMPLATE_COMPOSITION ( ACTIVITY_TEMPLATE_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , TYPICAL_ACTIVITY_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ACTIVITY_TEMPLATE_CONSTRAINT ( ACTIVITY_DURATION INTEGER , ACTIVITY_TEMPLATE_S VARCHAR2(19) NOT NULL, CONSTRAINED_BY_S VARCHAR2(19) , CONSTRAINT_FOR_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , RELATIVE_TIME INTEGER , R_TEMPLATE_CONSTRAINT_KIND VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ADDRESS ( AREA_CODE VARCHAR2(10) , BUSINESS_ASSOCIATE_S VARCHAR2(19) , COUNTRY_CODE VARCHAR2(10) , DATA_VALUE VARCHAR2(80) , DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, EXPIRY_DATE DATE , EXTENSION_CODE VARCHAR2(10) , FACILITY_S VARCHAR2(19) , FACILITY_T VARCHAR2(30) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , LINE_1 VARCHAR2(40) , LINE_2 VARCHAR2(40) , LINE_3 VARCHAR2(40) , LOCAL_PHONE_NUMBER VARCHAR2(10) , PHYSICAL_ADDRESS_S VARCHAR2(19) , POSTAL_CODE_S VARCHAR2(19) , ROOM_NUMBER VARCHAR2(40) , R_ADDRESS_QUALIFIER VARCHAR2(80) , SOURCE VARCHAR2(80) , STREET_NAME VARCHAR2(40) , STREET_NUMBER VARCHAR2(40) , STREET_SUFFIX VARCHAR2(40) , URL VARCHAR2(255) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ALLOCATED_FLOW_STREAM ( DESCRIPTION VARCHAR2(2000) , FLUID_COMPONENT_S VARCHAR2(19) NOT NULL, FLUID_COMPONENT_T VARCHAR2(30) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PFNU_PORT_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE ALLOWABLE_FLOW_STREAM ( DESCRIPTION VARCHAR2(2000) , FLUID_COMPONENT_S VARCHAR2(19) NOT NULL, FLUID_COMPONENT_T VARCHAR2(30) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PFNU_PORT_S VARCHAR2(19) NOT NULL, R_ALLOWABLE VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE APPLICATION_FOR_PERMIT ( DESCRIPTION VARCHAR2(2000) , DOCUMENT_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_CELL ( CELL_HEIGHT NUMBER NOT NULL, CELL_HEIGHT_U VARCHAR2(15) NOT NULL, CELL_ORIENTATION_ANGLE NUMBER NOT NULL, CELL_ORIENTATION_ANGLE_U VARCHAR2(15) NOT NULL, CELL_S VARCHAR2(19) NOT NULL, CELL_WIDTH NUMBER NOT NULL, CELL_WIDTH_U VARCHAR2(15) NOT NULL, DESCRIPTION VARCHAR2(2000) , HORIZONTAL_OFFSET NUMBER , HORIZONTAL_OFFSET_U VARCHAR2(15) , HORIZONTAL_SPACING NUMBER NOT NULL, HORIZONTAL_SPACING_U VARCHAR2(15) NOT NULL, IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , 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 ( CELL_S VARCHAR2(19) , DEPICTED_OBJECT_S VARCHAR2(19) , DEPICTED_OBJECT_T VARCHAR2(30) , DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, GRAPHICAL_ELEMENT_COMPONENT_S VARCHAR2(19) , IDENTIFIER VARCHAR2(80) NOT NULL, IMAGE_PALETTE_TYPE VARCHAR2(80) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PATTERN_FILL_TYPE VARCHAR2(80) , PATTERN_ORIENTATION_ANGLE NUMBER , PATTERN_ORIENTATION_ANGLE_U VARCHAR2(15) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_PATTERN_CELL_INCLUSION ( AREA_CELL_S VARCHAR2(19) NOT NULL, AREA_PATTERN_FILL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_PATTERN_FILL ( DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PATTERN_FILL_TYPE VARCHAR2(80) NOT NULL, R_COLOR VARCHAR2(80) , SOURCE VARCHAR2(80) , SYMBOL_LIBRARY_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AREA_PATTERN_FILL_COMPOSITION ( AREA_PATTERN_FILL_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , HATCH_LINE_PATTERN_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE AXIS_TYPE_ALTERNATIVE ( AXIS_TYPE VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PROPERTY_KIND_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BINSET_GRID_UID_USAGE ( BINSET_GRID_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SEISMIC_GEOMETRY_SET_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BOREHOLE_COMPONENT ( BELONGS_TO_ASSEMBLY_S VARCHAR2(19) , BELONGS_TO_ASSEMBLY_T VARCHAR2(30) , BOREHOLE_COMPONENT_LENGTH NUMBER , BOREHOLE_COMPONENT_LENGTH_U VARCHAR2(15) , COMPONENT_ORDER INTEGER , CRUSH_DAMAGE_RATIO_D NUMBER , CRUSH_DAMAGE_RATIO_N NUMBER , DESCRIPTION VARCHAR2(2000) , DIAMETER_CRUSH_ZONE NUMBER , DIAMETER_CRUSH_ZONE_U VARCHAR2(15) , END_DATE DATE , END_DATE_CD CHAR(1) , END_DATE_DY INTEGER , END_DATE_HR INTEGER , END_DATE_MT INTEGER , END_DATE_OF NUMBER , END_DATE_ST NUMBER , END_DATE_YP INTEGER , END_DATE_YR NUMBER , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , OUTER_DIAMETER NUMBER , OUTER_DIAMETER_U VARCHAR2(15) , R_DIAMETER VARCHAR2(80) , R_EXISTENCE_KIND VARCHAR2(80) NOT NULL, R_PERFORATION VARCHAR2(80) , 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) , SOURCE VARCHAR2(80) , START_DATE DATE , START_DATE_CD CHAR(1) , START_DATE_DY INTEGER , START_DATE_HR INTEGER , START_DATE_MT INTEGER , START_DATE_OF NUMBER , START_DATE_ST NUMBER , START_DATE_YP INTEGER , START_DATE_YR NUMBER , WELLBORE_S VARCHAR2(19) NOT NULL, WELL_COMPLETION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BULK_MATERIAL ( BASE_MISSING_SECTION NUMBER , BASE_MISSING_SECTION_U VARCHAR2(15) , COMBINED_TO_CREATE_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DRILLSTRING_S VARCHAR2(19) , EARTH_FEATURE_S VARCHAR2(19) , EARTH_FEATURE_T VARCHAR2(30) , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, FLUID_COMPONENT_S VARCHAR2(19) , FLUID_COMPONENT_T VARCHAR2(30) , FLUID_SYSTEM_S VARCHAR2(19) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , OCCURRENCE_NUMBER INTEGER , OUTCROP_S VARCHAR2(19) , QUALITY VARCHAR2(2000) , ROCK_MATERIAL_S VARCHAR2(19) , R_DIAMETER VARCHAR2(80) , R_EXISTENCE_KIND VARCHAR2(80) NOT NULL, SAMPLE_THICKNESS NUMBER , SAMPLE_THICKNESS_U VARCHAR2(15) , SOURCE VARCHAR2(80) , TIME_TO_SURFACE NUMBER , TIME_TO_SURFACE_U VARCHAR2(15) , TOP_MISSING_SECTION NUMBER , TOP_MISSING_SECTION_U VARCHAR2(15) , WELLBORE_S VARCHAR2(19) , WELL_TEST_RECOVERY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATE ( DESCRIPTION VARCHAR2(2000) , END_DATE DATE , END_DATE_CD CHAR(1) , END_DATE_DY INTEGER , END_DATE_HR INTEGER , END_DATE_MT INTEGER , END_DATE_OF NUMBER , END_DATE_ST NUMBER , END_DATE_YP INTEGER , END_DATE_YR NUMBER , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND VARCHAR2(80) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , START_DATE DATE , START_DATE_CD CHAR(1) , START_DATE_DY INTEGER , START_DATE_HR INTEGER , START_DATE_MT INTEGER , START_DATE_OF NUMBER , START_DATE_ST NUMBER , START_DATE_YP INTEGER , START_DATE_YR NUMBER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATE_ALIAS ( ALIASED_OBJECT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATE_INJURY ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , LOST_TIME NUMBER , LOST_TIME_U VARCHAR2(15) , MONETARY_LOSS NUMBER , MONETARY_LOSS_U VARCHAR2(15) , R_BUSINESS_ASSOCIATE_INJURY VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATE_JOB_TITLE ( BUSINESS_ASSOCIATION_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_ASSOC_JOB_TITLE VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATE_SERVICE ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_ASSOCIATE_SERVICE VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOCIATION ( ASSOCIATED_WITH_S VARCHAR2(19) NOT NULL, BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_ASSOCIATION_ROLE VARCHAR2(80) NOT NULL, R_BUS_ASSN_STRUCTURE VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , EARTH_FEATURE_S VARCHAR2(19) NOT NULL, EARTH_FEATURE_T VARCHAR2(30) NOT NULL, END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_ASSOC_EARTH_FTR VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOC_FACILITY_INVOLV ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , FACILITY_S VARCHAR2(19) NOT NULL, FACILITY_T VARCHAR2(30) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INVOLVEMENT_ROLE VARCHAR2(80) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_ASSOC_SECURITY_STATUS ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_ASSOCIATION_ROLE VARCHAR2(80) , R_BUS_ASSOC_SECURITY_CLASS VARCHAR2(80) NOT NULL, R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE BUSINESS_CONTACT ( CAUSED_BY_S VARCHAR2(19) , CONTACTEE_S VARCHAR2(19) NOT NULL, CONTACTOR_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_BUSINESS_CONTACT_PURPOSE VARCHAR2(80) , R_BUSINESS_CONTACT_RESULT VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAPILLARY_PRESSURE_CURVE ( DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NONWETTING_PHASE_S VARCHAR2(19) NOT NULL, NONWETTING_PHASE_T VARCHAR2(30) NOT NULL, ROCK_FLUID_INTERACTION_S VARCHAR2(19) NOT NULL, ROCK_FLUID_INTERACTION_T VARCHAR2(30) NOT NULL, R_CAPILLARY_PRESSURE VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , WETTING_PHASE_S VARCHAR2(19) NOT NULL, WETTING_PHASE_T VARCHAR2(30) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CAPILLARY_PRESSURE_POINT ( CAPILLARY_PRESSURE_CURVE_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NONWETTING_PHASE_S VARCHAR2(19) NOT NULL, NONWETTING_PHASE_T VARCHAR2(30) NOT NULL, ROCK_FLUID_INTERACTION_S VARCHAR2(19) , ROCK_FLUID_INTERACTION_T VARCHAR2(30) , R_CAPILLARY_PRESSURE VARCHAR2(80) NOT NULL, R_CAPILLARY_PRESSURE_USAGE VARCHAR2(80) , SOURCE VARCHAR2(80) , WETTING_PHASE_S VARCHAR2(19) NOT NULL, WETTING_PHASE_T VARCHAR2(30) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CARTER_LEGAL_SURVEY_AREA ( DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , RANGE INTEGER , R_EAST_OR_WEST VARCHAR2(80) , R_NORTH_OR_SOUTH VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , SUBDIVISION VARCHAR2(40) , SURFACE_ONLY CHAR(1) , TOWNSHIP INTEGER , TOWNSHIP_RANGE_SECTION INTEGER , UNIQUE_WITHIN_S VARCHAR2(19) , UNIQUE_WITHIN_T VARCHAR2(30) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CELL ( DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SYMBOL_LIBRARY_S VARCHAR2(19) NOT NULL, SYMBOL_TYPE VARCHAR2(80) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CODE_ALIAS ( ALIASED_OBJECT_S VARCHAR2(19) NOT NULL, ALIASED_OBJECT_T VARCHAR2(30) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_ACTIVITY_COMPOSITION ( COMPOSITION_TYPE VARCHAR2(80) , COUNT INTEGER , DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PART_S VARCHAR2(19) NOT NULL, REQUIRED_COMPONENT CHAR(1) , SEQUENCE INTEGER , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_ACTIVITY_INVOLVEMENT ( DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INVOLVED_CLASS_S VARCHAR2(19) , INVOLVED_CLASS_T VARCHAR2(30) , INVOLVED_ENTITY VARCHAR2(80) , INVOLVEMENT_ROLE VARCHAR2(80) NOT NULL, INVOLVING_CLASS_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_ACTIVITY_PROPERTY ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PROPERTY_KIND_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_FACILITY_COMPOSITION ( COMPOSITION_TYPE VARCHAR2(80) , COUNT INTEGER , DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PART_S VARCHAR2(19) NOT NULL, REQUIRED_COMPONENT CHAR(1) , SEQUENCE INTEGER , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_FACILITY_PROPERTY ( DESCRIPTION VARCHAR2(2000) , FACILITY_CLASS_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PROPERTY_KIND_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_GEOLOGIC_PROCESS_COMP ( COMPONENT_OF_PROCESS_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PROCESS_COMPONENT_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_GUIDELINE_OR_PRIVILEGE ( CLASSIFICATION_CLASS_S VARCHAR2(19) NOT NULL, CLASSIFICATION_CLASS_T VARCHAR2(30) NOT NULL, DESCRIPTION VARCHAR2(2000) , GUIDELINE_OR_PRIVILEGE_TYPE_S VARCHAR2(19) NOT NULL, GUIDELINE_OR_PRIVILEGE_TYPE_T VARCHAR2(30) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_MATERIAL_COMPOSITION ( AMOUNT NUMBER , AMOUNT_Q VARCHAR2(80) , AMOUNT_U VARCHAR2(15) , COMPOSITION_TYPE VARCHAR2(80) , COUNT INTEGER , DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PART_S VARCHAR2(19) NOT NULL, REQUIRED_COMPONENT CHAR(1) , SEQUENCE INTEGER , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , WHOLE_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMMON_MATERIAL_PROPERTY ( DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , MATERIAL_CLASS_S VARCHAR2(19) NOT NULL, PROPERTY_KIND_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMPOSITE_GRAPHICAL_ELEMENT ( CELL_S VARCHAR2(19) , DEPICTED_OBJECT_S VARCHAR2(19) , DEPICTED_OBJECT_T VARCHAR2(30) , DESCRIPTION VARCHAR2(2000) , GRAPHICAL_ELEMENT_COMPONENT_S VARCHAR2(19) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COMPOSITE_SPATIAL_OBJECT_COMP ( COMPOSITE_SPATIAL_OBJECT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SPATIAL_OBJECT_S VARCHAR2(19) NOT NULL) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ( DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , LOT_NUMBER INTEGER , NAMING_SYSTEM VARCHAR2(80) , POLYGON_DESCRIPTION VARCHAR2(2000) , PRINCIPAL_MERIDIAN VARCHAR2(40) , RANGE INTEGER , RANGE_FRACTION VARCHAR2(40) , R_EAST_OR_WEST VARCHAR2(80) , R_NORTH_OR_SOUTH VARCHAR2(80) , SECTION_SUFFIX CHAR(1) , SECTION_TYPE VARCHAR2(40) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , SUBDIVISION VARCHAR2(2000) , SURFACE_ONLY CHAR(1) , TOWNSHIP INTEGER , TOWNSHIP_FRACTION VARCHAR2(40) , TOWNSHIP_NAME VARCHAR2(40) , TOWNSHIP_RANGE_SECTION INTEGER , TRACT_NUMBER INTEGER , UNIQUE_WITHIN_S VARCHAR2(19) , UNIQUE_WITHIN_T VARCHAR2(30) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT ( DESCRIPTION VARCHAR2(2000) , DOCUMENT_DATE DATE , DURATION NUMBER , DURATION_U VARCHAR2(15) , EFFECTIVE_DATE DATE , EFFECTIVE_DATE_CD CHAR(1) , EFFECTIVE_DATE_DY INTEGER , EFFECTIVE_DATE_HR INTEGER , EFFECTIVE_DATE_MT INTEGER , EFFECTIVE_DATE_OF NUMBER , EFFECTIVE_DATE_ST NUMBER , EFFECTIVE_DATE_YP INTEGER , EFFECTIVE_DATE_YR NUMBER , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, EXECUTION_DATE DATE , EXECUTION_DATE_CD CHAR(1) , EXECUTION_DATE_DY INTEGER , EXECUTION_DATE_HR INTEGER , EXECUTION_DATE_MT INTEGER , EXECUTION_DATE_OF NUMBER , EXECUTION_DATE_ST NUMBER , EXECUTION_DATE_YP INTEGER , EXECUTION_DATE_YR NUMBER , EXPIRY_DATE DATE , EXPIRY_DATE_CD CHAR(1) , EXPIRY_DATE_DY INTEGER , EXPIRY_DATE_HR INTEGER , EXPIRY_DATE_MT INTEGER , EXPIRY_DATE_OF NUMBER , EXPIRY_DATE_ST NUMBER , EXPIRY_DATE_YP INTEGER , EXPIRY_DATE_YR NUMBER , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , ORIGINAL_EXPIRY_DATE DATE , ORIGINAL_EXPIRY_DATE_CD CHAR(1) , ORIGINAL_EXPIRY_DATE_DY INTEGER , ORIGINAL_EXPIRY_DATE_HR INTEGER , ORIGINAL_EXPIRY_DATE_MT INTEGER , ORIGINAL_EXPIRY_DATE_OF NUMBER , ORIGINAL_EXPIRY_DATE_ST NUMBER , ORIGINAL_EXPIRY_DATE_YP INTEGER , ORIGINAL_EXPIRY_DATE_YR NUMBER , RECORDED_DATE DATE , RECORDED_DATE_CD CHAR(1) , RECORDED_DATE_DY INTEGER , RECORDED_DATE_HR INTEGER , RECORDED_DATE_MT INTEGER , RECORDED_DATE_OF NUMBER , RECORDED_DATE_ST NUMBER , RECORDED_DATE_YP INTEGER , RECORDED_DATE_YR NUMBER , RECORDED_LINE VARCHAR2(40) , RECORDED_PAGE VARCHAR2(40) , RECORDED_VOLUME VARCHAR2(40) , SOURCE VARCHAR2(80) , TOTAL_COST NUMBER , TOTAL_COST_U VARCHAR2(15) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACTUAL_OBLIGATION ( CONTRACT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , DUE_DATE DATE , DUE_DATE_CD CHAR(1) , DUE_DATE_DY INTEGER , DUE_DATE_HR INTEGER , DUE_DATE_MT INTEGER , DUE_DATE_OF NUMBER , DUE_DATE_ST NUMBER , DUE_DATE_YP INTEGER , DUE_DATE_YR NUMBER , EFFECTIVE_DATE DATE , EFFECTIVE_DATE_CD CHAR(1) , EFFECTIVE_DATE_DY INTEGER , EFFECTIVE_DATE_HR INTEGER , EFFECTIVE_DATE_MT INTEGER , EFFECTIVE_DATE_OF NUMBER , EFFECTIVE_DATE_ST NUMBER , EFFECTIVE_DATE_YP INTEGER , EFFECTIVE_DATE_YR NUMBER , EXPIRY_DATE DATE , EXPIRY_DATE_CD CHAR(1) , EXPIRY_DATE_DY INTEGER , EXPIRY_DATE_HR INTEGER , EXPIRY_DATE_MT INTEGER , EXPIRY_DATE_OF NUMBER , EXPIRY_DATE_ST NUMBER , EXPIRY_DATE_YP INTEGER , EXPIRY_DATE_YR NUMBER , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_CONTRACT_OBLIGATION VARCHAR2(80) , R_OBLIGATION_FREQUENCY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_ACTIVITY ( ACTIVITY_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_ACTIVITY_TYPE ( ACTIVITY_CLASS_S VARCHAR2(19) NOT NULL, CONTRACTUAL_OBLIGATION_S VARCHAR2(19) , CONTRACT_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_ASSOC_FACILITY_ASSN ( BUSINESS_ASSOC_FACILITY_ASSN_S VARCHAR2(19) NOT NULL, CONTRACT_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_DESIGNATION ( ACCOUNT_NUMBER VARCHAR2(2000) , ADDRESS_S VARCHAR2(19) , AMOUNT NUMBER , AMOUNT_U VARCHAR2(15) , BUSINESS_ASSOCIATE_ROLE VARCHAR2(80) NOT NULL, BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CONTRACTUAL_OBLIGATION_S VARCHAR2(19) , CONTRACT_S VARCHAR2(19) , DEPOSITORY_DESIGNATION_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EFFECTIVE_DATE_CD CHAR(1) , EFFECTIVE_DATE_DY INTEGER , EFFECTIVE_DATE_HR INTEGER , EFFECTIVE_DATE_MT INTEGER , EFFECTIVE_DATE_OF NUMBER , EFFECTIVE_DATE_ST NUMBER , EFFECTIVE_DATE_YP INTEGER , EFFECTIVE_DATE_YR NUMBER , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, EXPIRY_DATE DATE , EXPIRY_DATE_CD CHAR(1) , EXPIRY_DATE_DY INTEGER , EXPIRY_DATE_HR INTEGER , EXPIRY_DATE_MT INTEGER , EXPIRY_DATE_OF NUMBER , EXPIRY_DATE_ST NUMBER , EXPIRY_DATE_YP INTEGER , EXPIRY_DATE_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INTEREST_KIND VARCHAR2(80) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , OWNERSHIP_KIND VARCHAR2(80) , PERCENT NUMBER , R_HOLD_OR_PAY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_OBJECT_DESIGNATION ( BUSINESS_OBJECT_S VARCHAR2(19) NOT NULL, BUSINESS_OBJECT_T VARCHAR2(30) NOT NULL, CONTRACT_DESIGNATION_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , STATUS VARCHAR2(11) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_OBLIG_ACTIVITY_FULFIL ( ACTIVITY_S VARCHAR2(19) NOT NULL, CONTRACTUAL_OBLIGATION_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE CONTRACT_OBLIG_OBJECT_FULFIL ( BUSINESS_OBJECT_S VARCHAR2(19) NOT NULL, BUSINESS_OBJECT_T VARCHAR2(30) NOT NULL, CONTRACTUAL_OBLIGATION_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_AXIS_CONSTRAINT ( AXIS_ORDER INTEGER NOT NULL, AXIS_TYPE VARCHAR2(80) NOT NULL, COORDINATE_SYSTEM_CONSTRAINT VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_SYSTEM ( DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, FIRST_SYSTEM_S VARCHAR2(19) , GEODETIC_DATUM_S VARCHAR2(19) , GEOGRAPHIC_2D_COORD_SYSTEM_S VARCHAR2(19) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , LOCAL_CONTEXT_S VARCHAR2(19) , LOCAL_CONTEXT_T VARCHAR2(30) , MAP_PROJECTION_S VARCHAR2(19) , NAMING_SYSTEM VARCHAR2(80) , ORIGIN_LOCATION_1 NUMBER NOT NULL, ORIGIN_LOCATION_1_MA INTEGER , ORIGIN_LOCATION_1_SA NUMBER , ORIGIN_LOCATION_1_U VARCHAR2(15) NOT NULL, ORIGIN_LOCATION_2 NUMBER , ORIGIN_LOCATION_2_MA INTEGER , ORIGIN_LOCATION_2_SA NUMBER , ORIGIN_LOCATION_2_U VARCHAR2(15) , ORIGIN_LOCATION_3 NUMBER , ORIGIN_LOCATION_3_MA INTEGER , ORIGIN_LOCATION_3_SA NUMBER , ORIGIN_LOCATION_3_U VARCHAR2(15) , ORIGIN_LOCATION_4 NUMBER , ORIGIN_LOCATION_4_MA INTEGER , ORIGIN_LOCATION_4_SA NUMBER , ORIGIN_LOCATION_4_U VARCHAR2(15) , ORIGIN_LOCATION_5 NUMBER , ORIGIN_LOCATION_5_MA INTEGER , ORIGIN_LOCATION_5_SA NUMBER , ORIGIN_LOCATION_5_U VARCHAR2(15) , ORIGIN_LOCATION_CS_S VARCHAR2(19) NOT NULL, ORIGIN_LOCATION_O_S VARCHAR2(19) , R_COORDINATE_SYS_CONSTRAINT VARCHAR2(80) NOT NULL, R_DISPLAY_ORIENTATION VARCHAR2(80) , SECOND_SYSTEM_S VARCHAR2(19) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_GEODETIC_SYSTEM_S VARCHAR2(19) , SOURCE_REFERENCE VARCHAR2(2000) , SPATIAL_REFERENCE_S VARCHAR2(19) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , VERTICAL_DATUM_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_SYSTEM_AXIS ( ABBREVIATION VARCHAR2(15) NOT NULL, AXIS_ORDER INTEGER NOT NULL, CONSTRAINED_TO_UNIT VARCHAR2(15) , COORDINATE_SYSTEM_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PROPERTY_KIND_S VARCHAR2(19) NOT NULL, R_AXIS_ORIENTATION VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_SYSTEM_EARTH_USAGE ( COORDINATE_SYSTEM_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , EARTH_FEATURE_S VARCHAR2(19) NOT NULL, EARTH_FEATURE_T VARCHAR2(30) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE COORDINATE_TRANSFORMATION ( DESCRIPTION VARCHAR2(2000) , ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_COORDINATE_SYSTEM_S VARCHAR2(19) , SOURCE_OFFSET_UNIT VARCHAR2(15) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , TARGET_COORDINATE_SYSTEM_S VARCHAR2(19) , TARGET_OFFSET_UNIT VARCHAR2(15) , TRANSFORMATION_METHOD_S VARCHAR2(19) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DAMAGE_AREA ( DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , SURFACE_ONLY CHAR(1) , UNIQUE_WITHIN_S VARCHAR2(19) , UNIQUE_WITHIN_T VARCHAR2(30) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DATA_COLLECTION ( ACTIVITY_S VARCHAR2(19) , BUSINESS_ASSOCIATE_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPECIFICATION_S VARCHAR2(19) , DOCUMENT_SPECIFICATION_T VARCHAR2(30) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , POPULATED_BY_S VARCHAR2(19) , PROCESS_PARAMETER_S VARCHAR2(19) , R_DATA_COLLECTION_TYPE VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , UPDATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DATA_COLLECTION_CONTENT ( COLLECTION_PART_S VARCHAR2(19) NOT NULL, COLLECTION_PART_T VARCHAR2(30) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PART_OF_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DATA_TRACE_ALIAS ( ALIASED_OBJECT_S VARCHAR2(19) NOT NULL, ALIASED_OBJECT_T VARCHAR2(30) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DERIVED_INTEREST_BASIS ( CONTRACT_DESIGNATION_S VARCHAR2(19) NOT NULL, DERIVED_INTEREST_MAKEUP_S VARCHAR2(19) NOT NULL, DESCRIPTION VARCHAR2(2000) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DERIVED_INTEREST_MAKEUP ( CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , FRACTION NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, INTEREST_FOR_S VARCHAR2(19) NOT NULL, INTEREST_FOR_T VARCHAR2(30) NOT NULL, INTEREST_OF_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIAGRAM_SPECIFICATION ( DESCRIPTION VARCHAR2(2000) , DOCUMENT_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DISCOVERY_AREA ( APPLICATION_DATE DATE , DECLARATION_DATE DATE , DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , SURFACE_ONLY CHAR(1) , UNIQUE_WITHIN_S VARCHAR2(19) , UNIQUE_WITHIN_T VARCHAR2(30) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIVESTMENT_EQUIPMENT_INCLUSION ( DESCRIPTION VARCHAR2(2000) , DIVESTMENT_PACKAGE_S VARCHAR2(19) NOT NULL, EQUIPMENT_ITEM_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIVESTMENT_PACKAGE ( CLOSING_DATE DATE , DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , PART_OF_S VARCHAR2(19) , RESPONSE_DUE_DATE DATE , R_SALE VARCHAR2(80) , SALE_DATE DATE , SALE_EFFECTIVE_DATE DATE , SALE_OFFER_DATE DATE , SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DIVESTMENT_RIGHT_INCLUSION ( DESCRIPTION VARCHAR2(2000) , DIVESTMENT_PACKAGE_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , LICENSE_RIGHT_S VARCHAR2(19) NOT NULL, SOURCE VARCHAR2(80) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT ( DESCRIPTION VARCHAR2(2000) , DIGITAL_FILE LONG RAW , DOCUMENT_SPECIFICATION_S VARCHAR2(19) NOT NULL, DOCUMENT_SPECIFICATION_T VARCHAR2(30) NOT NULL, ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND_S VARCHAR2(19) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , R_DIGITAL_FILE_FORMAT VARCHAR2(80) , R_EXISTENCE_KIND VARCHAR2(80) NOT NULL, R_HARDCOPY_DOCUMENT VARCHAR2(80) , SOURCE VARCHAR2(80) , X_SCALE_D INTEGER , X_SCALE_N INTEGER , Y_SCALE_D INTEGER , Y_SCALE_N INTEGER ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SCHEMA ( DESCRIPTION VARCHAR2(2000) , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , XMLSCHEMA_REF VARCHAR2(132) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SCHEMA_ENTITY_CONTENT ( DESCRIPTION VARCHAR2(2000) , DOCUMENT_CONTENT_S VARCHAR2(19) , DOCUMENT_SCHEMA_ENTITY_S VARCHAR2(19) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , SEQUENCE INTEGER , SOURCE VARCHAR2(80) , TEXT LONG ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SCHEMA_PART ( CARDINALITY INTEGER , COMPONENT_SEQUENCE INTEGER , COMPOSITOR VARCHAR2(27) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SCHEMA_ELEMENT_S VARCHAR2(19) , DOCUMENT_SCHEMA_S VARCHAR2(19) NOT NULL, ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, KIND VARCHAR2(132) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , OPTIONALITY CHAR(1) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) , WHOLE_ATTRIBUTE_S VARCHAR2(19) , WHOLE_ELEMENT_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SPECIFICATION_ALIAS ( ALIASED_OBJECT_S VARCHAR2(19) NOT NULL, ALIASED_OBJECT_T VARCHAR2(30) NOT NULL, DESCRIPTION VARCHAR2(2000) , EFFECTIVE_DATE DATE , EXPIRY_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) NOT NULL, SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SPECIFICATION_CLASS ( DESCRIPTION VARCHAR2(2000) , DOCUMENT_SCHEMA_S VARCHAR2(19) , END_DATE DATE , IDENTIFIER VARCHAR2(80) NOT NULL, INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , NAMING_SYSTEM VARCHAR2(80) , PARENT_CLASS_S VARCHAR2(19) , SOURCE VARCHAR2(80) , SOURCE_CONTENT VARCHAR2(80) , SOURCE_REFERENCE VARCHAR2(2000) , START_DATE DATE , STATUS VARCHAR2(11) , VERSION_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SPECIFICATION_CLSN ( CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPECIFICATION_CLASS_S VARCHAR2(19) NOT NULL, DOCUMENT_SPECIFICATION_S VARCHAR2(19) NOT NULL, DOCUMENT_SPECIFICATION_T VARCHAR2(30) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, IS_CURRENT CHAR(1) , LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , R_TRANSIENT_PERIOD VARCHAR2(80) , SOURCE VARCHAR2(80) , START_TIME DATE , START_TIME_CD CHAR(1) , START_TIME_DY INTEGER , START_TIME_HR INTEGER , START_TIME_MT INTEGER , START_TIME_OF NUMBER , START_TIME_ST NUMBER , START_TIME_YP INTEGER , START_TIME_YR NUMBER , TERMINATED_BY_S VARCHAR2(19) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SPECIFICATION_PART ( ANNOTATION VARCHAR2(132) , AXIS_ROTATION_ANGLE NUMBER , AXIS_ROTATION_ANGLE_U VARCHAR2(15) , CITATION VARCHAR2(2000) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_REFERENCED_S VARCHAR2(19) , DOCUMENT_REFERENCED_T VARCHAR2(30) , DOCUMENT_SCHEMA_PART_S VARCHAR2(19) , DOCUMENT_SPECIFICATION_S VARCHAR2(19) NOT NULL, DOCUMENT_SPECIFICATION_T VARCHAR2(30) NOT NULL, ENTITY_TYPE_NM VARCHAR2(30) NOT NULL, E_AND_P_DATA_S VARCHAR2(19) , E_AND_P_DATA_T VARCHAR2(30) , GRAPHICAL_REPRESENTATION_S VARCHAR2(19) , GRAPHICAL_REPRESENTATION_T VARCHAR2(30) , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCHAR2(19) NOT NULL, LAST_UPDATED DATE , LAST_UPDATED_BY VARCHAR2(80) , MAXIMUM_SCALE NUMBER , MAXIMUM_SCALE_Q VARCHAR2(80) , MAXIMUM_SCALE_U VARCHAR2(15) , MINIMUM_SCALE NUMBER , MINIMUM_SCALE_Q VARCHAR2(80) , MINIMUM_SCALE_U VARCHAR2(15) , REFERENCE_CONTENT_S VARCHAR2(19) , ROLE VARCHAR2(80) , SEQUENCE INTEGER , SOURCE VARCHAR2(80) , TEXT LONG , X_OFFSET NUMBER , X_OFFSET_Q VARCHAR2(80) , X_OFFSET_U VARCHAR2(15) , X_SCALE NUMBER , X_SCALE_Q VARCHAR2(80) , X_SCALE_U VARCHAR2(15) , Y_OFFSET NUMBER , Y_OFFSET_Q VARCHAR2(80) , Y_OFFSET_U VARCHAR2(15) , Y_SCALE NUMBER , Y_SCALE_Q VARCHAR2(80) , Y_SCALE_U VARCHAR2(15) ) TABLESPACE POSC_MODEL_TAB; CREATE TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ( BUSINESS_ASSOCIATE_S VARCHAR2(19) NOT NULL, CAUSED_BY_S VARCHAR2(19) , DESCRIPTION VARCHAR2(2000) , DOCUMENT_SPECIFICATION_S VARCHAR2(19) NOT NULL, DOCUMENT_SPECIFICATION_T VARCHAR2(30) NOT NULL, DURATION NUMBER , DURATION_U VARCHAR2(15) , END_TIME DATE , END_TIME_CD CHAR(1) , END_TIME_DY INTEGER , END_TIME_HR INTEGER , END_TIME_MT INTEGER , END_TIME_OF NUMBER , END_TIME_ST NUMBER , END_TIME_YP INTEGER , END_TIME_YR NUMBER , INSTANCE_CREATE_DATE DATE , INSTANCE_CREATOR VARCHAR2(80) , INSTANCE_S VARCH