create table dae_author_a ( dae_ds_header_s varchar(19) not null, value varchar(255) not null) go create table dae_bd_ord_crit_a ( dae_exch_prof_s varchar(19) not null, value varchar(255) not null) go create table dae_delete_crit_a ( dae_import_dsc_s varchar(19) not null, value varchar(255) not null) go create table dae_elements_a ( dae_enum_ty_s varchar(19) not null, value varchar(255) not null, value_l int not null) go create table dae_fill_crit_a ( dae_import_dsc_s varchar(19) not null, value varchar(255) not null) go create table dae_id_crit_a ( dae_exch_prof_s varchar(19) not null, value varchar(255) not null) go create table dae_initial_crit_a ( dae_export_dsc_s varchar(19) not null, value varchar(255) not null) go create table dae_mn_cntn_crit_a ( dae_exch_prof_s varchar(19) not null, value varchar(255) not null) go create table dae_organization_a ( dae_ds_header_s varchar(19) not null, value varchar(255) not null) go create table dae_quality_rpt_a ( dae_ds_header_s varchar(19) not null, value varchar(255) not null) go create table dae_refresh_crit_a ( dae_import_dsc_s varchar(19) not null, value varchar(255) not null) go create table dae_scope_crit_a ( dae_exch_prof_s varchar(19) not null, value varchar(255) not null) go create table activity_class ( activity_class_s varchar(19) not null, classification_sys varchar(40) null, clsn_cls_name varchar(80) not null, description varchar(255) null, end_date datetime null, source varchar(40) not null, source_reference_s varchar(19) null, start_date datetime null, status varchar(11) null, version varchar(40) null) go sp_primarykey activity_class, activity_class_s go create table activity_clsn ( activity_class_s varchar(19) not null, activity_clsn_s varchar(19) not null, activity_s varchar(19) not null, activity_t varchar(16) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey activity_clsn, activity_clsn_s go create table activity_fulfl ( activity_fulfl_s varchar(19) not null, fulfillment_s varchar(19) not null, fulfillment_t varchar(16) not null, fulfill_s varchar(19) not null, fulfill_t varchar(16) not null, relative_time float null, relative_time_u varchar(15) null) go sp_primarykey activity_fulfl, activity_fulfl_s go create table activity_tmplt ( activity_tmplt_nm varchar(40) not null, activity_tmplt_s varchar(19) not null, described_act varchar(40) not null, description varchar(255) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey activity_tmplt, activity_tmplt_s go create table act_cause_eff ( act_cause_eff_s varchar(19) not null, caused_by_s varchar(19) not null, caused_by_t varchar(16) not null, description varchar(255) null, intentional char(1) null, result_s varchar(19) not null, result_t varchar(16) not null) go sp_primarykey act_cause_eff, act_cause_eff_s go create table act_cls_alias ( activity_class_s varchar(19) not null, act_cls_alias_s varchar(19) not null, classification_sys varchar(40) not null, name varchar(80) not null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey act_cls_alias, act_cls_alias_s go create table act_cls_clsn ( act_cls_clsn_s varchar(19) not null, be_classified_as_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, have_as_a_member_s varchar(19) not null, r_transient_period varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, start_time datetime null, status varchar(11) null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, version varchar(40) null) go sp_primarykey act_cls_clsn, act_cls_clsn_s go create table act_tmplt_cstr ( activity_duration int null, activity_tmplt_s varchar(19) not null, act_tmplt_cstr_s varchar(19) not null, constrained_by varchar(40) null, constraint_for varchar(40) not null, description varchar(255) null, relative_time int null, r_tmplt_cstr_kd_nm varchar(40) not null) go sp_primarykey act_tmplt_cstr, act_tmplt_cstr_s go create table aircraft ( aircraft_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey aircraft, aircraft_s go create table aloc_flw_strm ( aloc_flw_strm_s varchar(19) not null, description varchar(255) null, fluid_component_s varchar(19) not null, fluid_component_t varchar(16) not null, pfnu_port_s varchar(19) not null) go sp_primarykey aloc_flw_strm, aloc_flw_strm_s go create table alow_flw_strm ( alow_flw_strm_s varchar(19) not null, description varchar(255) null, fluid_component_s varchar(19) not null, fluid_component_t varchar(16) not null, pfnu_port_s varchar(19) not null, r_allowable_kind varchar(40) not null) go sp_primarykey alow_flw_strm, alow_flw_strm_s go create table ana_rsvr_anal ( activity_name varchar(40) null, ana_rsvr_anal_s varchar(19) not null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey ana_rsvr_anal, ana_rsvr_anal_s go create table anchoring_sys ( anchoring_sys_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey anchoring_sys, anchoring_sys_s go create table anchor_winch ( anchor_winch_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey anchor_winch, anchor_winch_s go create table application_sta ( application_sta_s varchar(19) not null, app_for_prmt_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_app_sta_kind varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey application_sta, application_sta_s go create table app_cord_trfm ( app_cord_trfm_s varchar(19) not null, coordinate_trfm_id varchar(40) not null, description varchar(255) null, edge_s varchar(19) null, edge_t varchar(16) null, face_s varchar(19) null, face_t varchar(16) null, source varchar(40) not null, source_cord_sys varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, target_cord_sys varchar(40) not null, version varchar(40) null) go sp_primarykey app_cord_trfm, app_cord_trfm_s go create table app_for_prmt ( applicant_s varchar(19) not null, app_for_prmt_s varchar(19) not null, cmps_doc_spec_s varchar(19) null, description varchar(255) null, document_spec_id varchar(40) not null, information_cntn_s varchar(19) null, permit_spec_s varchar(19) null, permit_spec_t varchar(16) null, typ_doc_spec_id varchar(40) null) go sp_primarykey app_for_prmt, app_for_prmt_s go create table aquifer ( aquifer_name varchar(50) not null, aquifer_s varchar(19) not null) go sp_primarykey aquifer, aquifer_s go create table area_cell ( area_cell_id varchar(40) not null, area_cell_s varchar(19) not null, cell_height float not null, cell_height_u varchar(15) not null, cell_ornt_angl float not null, cell_ornt_angl_u varchar(15) not null, cell_s varchar(19) not null, cell_width float not null, cell_width_u varchar(15) not null, horizontal_ofst float null, horizontal_ofst_u varchar(15) null, horizontal_spc float not null, horizontal_spc_u varchar(15) not null, vertical_offset float null, vertical_offset_u varchar(15) null, vertical_spacing float not null, vertical_spacing_u varchar(15) not null) go sp_primarykey area_cell, area_cell_s go create table area_element ( area_element_s varchar(19) not null, cell_s varchar(19) null, depicted_object_s varchar(19) null, depicted_object_t varchar(16) null, document_spec_s varchar(19) not null, document_spec_t varchar(16) not null, entity_type_nm varchar(40) not null, graphical_ele_id varchar(40) not null, graph_ele_cmpn_s varchar(19) null, image_palet_ty_id varchar(40) null, pattern_fill_ty_id varchar(40) null, pat_ornt_angl float null, pat_ornt_angl_u varchar(15) null) go sp_primarykey area_element, area_element_s go create table area_pat_fill ( area_pat_fill_s varchar(19) not null, description varchar(255) null, pattern_fill_ty_id varchar(40) not null, r_color_name varchar(40) null, symbol_library_id varchar(40) not null) go sp_primarykey area_pat_fill, area_pat_fill_s go create table binset_grid ( binset_grid_s varchar(19) not null, binset_name varchar(40) not null, binset_uid int null, bin_node_dsc varchar(16) null, bin_node_name varchar(16) null, bin_source_event varchar(16) null, bin_src_evnt_log varchar(16) null, bin_station varchar(16) null, bin_station_rto_d int null, bin_station_rto_n int null, description varchar(255) null, grid_structured_s varchar(19) not null, grid_structured_t varchar(16) not null, r_bnst_geom_cls_kd varchar(40) null, seismic_geom_set_s varchar(19) not null, seis_proc_act_s varchar(19) null) go sp_primarykey binset_grid, binset_grid_s go create table binset_grid_var ( binset_grid_s varchar(19) not null, binset_grid_var_s varchar(19) not null, binset_name varchar(40) not null, binset_uid int null, description varchar(255) null, grid_structured_s varchar(19) not null, grid_structured_t varchar(16) not null, r_bnst_geom_cls_kd varchar(40) null, r_grid_variant_nm varchar(40) null, seis_proc_act_s varchar(19) null) go sp_primarykey binset_grid_var, binset_grid_var_s go create table binset_ntrs ( binset_grid_s varchar(19) not null, binset_ntrs_name varchar(40) null, binset_ntrs_s varchar(19) not null, description varchar(255) null, intersected_geom_s varchar(19) null) go sp_primarykey binset_ntrs, binset_ntrs_s go create table borehole_cmpn ( belongs_to_assy_l int null, belongs_to_assy_s varchar(19) null, belongs_to_assy_t varchar(16) null, borehole_cmpn_s varchar(19) not null, brhl_cmpn_len float null, brhl_cmpn_len_u varchar(15) null, crush_damage_rto_d float null, crush_damage_rto_n float null, description varchar(255) null, diameter_crsh_zn float null, diameter_crsh_zn_u varchar(15) null, drill_borehole_s varchar(19) null, end_date datetime null, entity_type_nm varchar(40) not null, outer_diameter float null, outer_diameter_u varchar(15) null, r_diameter varchar(15) null, r_existence_kd_nm varchar(40) not null, r_perforation_kind varchar(40) null, shoot_perf_s varchar(19) null, shot_angle float null, shot_angle_u varchar(15) null, shot_count int null, shot_density float null, shot_density_u varchar(15) null, shot_diameter float null, shot_diameter_u varchar(15) null, shot_length float null, shot_length_u varchar(15) null, shot_phase float null, shot_phase_u varchar(15) null, start_date datetime null, typical_fcl_name varchar(40) null, wb_cmpn_fcl_id varchar(40) null, wellbore_s varchar(19) not null, well_cmpl_1_s varchar(19) null) go sp_primarykey borehole_cmpn, borehole_cmpn_s go create table borehole_fl_sys ( borehole_fl_sys_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey borehole_fl_sys, borehole_fl_sys_s go create table boundary_class ( boundary_class_s varchar(19) not null, classification_sys varchar(40) null, clsn_cls_name varchar(80) not null, description varchar(255) null, end_date datetime null, source varchar(40) not null, source_reference_s varchar(19) null, start_date datetime null, status varchar(11) null, version varchar(40) null) go sp_primarykey boundary_class, boundary_class_s go create table boundary_clsn ( boundary_class_s varchar(19) not null, boundary_clsn_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, feature_bnd_s varchar(19) not null, feature_bnd_t varchar(16) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey boundary_clsn, boundary_clsn_s go create table brhl_gnr_run ( activity_name varchar(40) null, brhl_gnr_run_s varchar(19) not null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_act_term_rsn_nm varchar(40) null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null, wellbore_id varchar(40) null, wellbore_s varchar(19) null, well_opr_fl_s varchar(19) null) go sp_primarykey brhl_gnr_run, brhl_gnr_run_s go create table bsasc ( bsasc_id varchar(40) not null, bsasc_s varchar(19) not null, description varchar(255) null, end_date datetime null, kind varchar(40) not null, r_naming_system_kd varchar(40) null, start_date datetime null) go sp_primarykey bsasc, bsasc_s go create table bsasc_act_rle ( activity_s varchar(19) not null, activity_t varchar(16) not null, bsasc_act_rle_s varchar(19) not null, bsasc_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bsasc_act_rle_kd varchar(40) null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_act_rle, bsasc_act_rle_s go create table bsasc_alias ( bsasc_alias_s varchar(19) not null, bsasc_s varchar(19) not null, description varchar(255) null, effective_date datetime null, expiry_date datetime null, identifier varchar(40) not null, r_naming_system_kd varchar(40) not null) go sp_primarykey bsasc_alias, bsasc_alias_s go create table bsasc_fcl_asn ( bsasc_fcl_asn_s varchar(19) not null, bsasc_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, facility_s varchar(19) not null, facility_t varchar(16) not null, r_bsasc_fcl_rle_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_fcl_asn, bsasc_fcl_asn_s go create table bsasc_injury ( bsasc_injury_s varchar(19) not null, bsasc_s varchar(19) not null, description varchar(255) null, incdt_of_ncom_s varchar(19) null, lost_time float null, lost_time_u varchar(15) null, monetary_loss float null, monetary_loss_u varchar(15) null, r_bsasc_injury_kd varchar(40) not null) go sp_primarykey bsasc_injury, bsasc_injury_s go create table bsasc_job_title ( bsasc_job_title_s varchar(19) not null, bsasn_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bsasc_job_ttl_kd varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_job_title, bsasc_job_title_s go create table bsasc_lfrle ( bsasc_lfrle_s varchar(19) not null, bsasc_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, earth_sftr_s varchar(19) not null, earth_sftr_t varchar(16) not null, end_time datetime null, r_bsasc_lfrle_kind varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_lfrle, bsasc_lfrle_s go create table bsasc_privilege ( bsasc_privilege_s varchar(19) not null, bsasc_s varchar(19) not null, data_value float null, data_value_u varchar(15) null, description varchar(255) null, effective_date datetime null, expiry_date datetime null, gdln_or_priv_id varchar(40) not null, r_bsasc_priv_kind varchar(40) not null, text text null) go sp_primarykey bsasc_privilege, bsasc_privilege_s go create table bsasc_scty_sta ( bsasc_s varchar(19) not null, bsasc_scty_sta_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bsasc_scty_kind varchar(40) not null, r_bsasn_role_kind varchar(40) null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_scty_sta, bsasc_scty_sta_s go create table bsasc_service ( bsasc_s varchar(19) not null, bsasc_service_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bsasc_service_kd varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasc_service, bsasc_service_s go create table bsasn ( associated_with_s varchar(19) not null, bsasc_s varchar(19) not null, bsasn_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bsasn_role_kind varchar(40) not null, r_bsasn_stru_id varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey bsasn, bsasn_s go create table building ( building_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey building, building_s go create table bulk_stor_sys ( bulk_stor_sys_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey bulk_stor_sys, bulk_stor_sys_s go create table business_cntc ( business_cntc_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, contactee_s varchar(19) not null, contactor_s varchar(19) not null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_bus_cntc_purp_kd varchar(40) null, r_bus_cntc_rslt_kd varchar(40) null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey business_cntc, business_cntc_s go create table cap_prs_cv ( cap_prs_cv_s varchar(19) not null, description varchar(255) null, nonwetting_phase_s varchar(19) not null, nonwetting_phase_t varchar(16) not null, rock_fluid_iact_s varchar(19) not null, rock_fluid_iact_t varchar(16) not null, r_capillary_prs_kd varchar(40) not null, wetting_phase_s varchar(19) not null, wetting_phase_t varchar(16) not null) go sp_primarykey cap_prs_cv, cap_prs_cv_s go create table cap_prs_pt ( cap_prs_cv_s varchar(19) null, cap_prs_pt_s varchar(19) not null, description varchar(255) null, nonwetting_phase_s varchar(19) not null, nonwetting_phase_t varchar(16) not null, rock_fluid_iact_s varchar(19) null, rock_fluid_iact_t varchar(16) null, r_capillary_prs_kd varchar(40) not null, r_cap_prs_use_kind varchar(40) null, wetting_phase_s varchar(19) not null, wetting_phase_t varchar(16) not null) go sp_primarykey cap_prs_pt, cap_prs_pt_s go create table carter_lsa ( carter_lsa_s varchar(19) not null, lsa_id varchar(40) null, range int null, r_east_or_west_nm varchar(40) null, r_nrth_or_south_kd varchar(40) null, subdivision varchar(40) null, township int null, township_rng_sect int null) go sp_primarykey carter_lsa, carter_lsa_s go create table catalog_eqp ( catalog_eqp_id varchar(40) null, catalog_eqp_s varchar(19) not null, description varchar(255) null, end_date datetime null, entity_type_nm varchar(40) not null, r_naming_system_kd varchar(40) null, start_date datetime null) go sp_primarykey catalog_eqp, catalog_eqp_s go create table catalog_eqp_insl ( catalog_eqp_insl_s varchar(19) not null, catalog_eqp_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, facility_s varchar(19) not null, facility_t varchar(16) not null, item_count int null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey catalog_eqp_insl, catalog_eqp_insl_s go create table catalog_it_assy ( catalog_it_assy_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, item_count int null, part_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, whole_s varchar(19) not null) go sp_primarykey catalog_it_assy, catalog_it_assy_s go create table catalog_it_coll ( catalog_it_coll_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, item_count int null, part_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, whole_s varchar(19) not null) go sp_primarykey catalog_it_coll, catalog_it_coll_s go create table cat_eqp_alias ( catalog_eqp_s varchar(19) not null, cat_eqp_alias_s varchar(19) not null, description varchar(255) null, effective_date datetime null, expiry_date datetime null, identifier varchar(40) not null, r_naming_system_kd varchar(40) not null) go sp_primarykey cat_eqp_alias, cat_eqp_alias_s go create table cat_eqp_clsn ( cat_eqp_clsn_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, equipment_class_s varchar(19) not null, member_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey cat_eqp_clsn, cat_eqp_clsn_s go create table cat_eqp_cmps ( cat_eqp_cmps_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, part_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, whole_s varchar(19) not null) go sp_primarykey cat_eqp_cmps, cat_eqp_cmps_s go create table cat_eqp_mtrspec ( catalog_eqp_s varchar(19) not null, cat_eqp_mtrspec_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, typical_mtrl_s varchar(19) not null, typical_mtrl_t varchar(16) not null) go sp_primarykey cat_eqp_mtrspec, cat_eqp_mtrspec_s go create table cat_eqp_succ ( cat_eqp_succ_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_transient_period varchar(40) null, start_time datetime null, succeeded_s varchar(19) not null, successor_s varchar(19) not null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey cat_eqp_succ, cat_eqp_succ_s go create table cat_eqp_version ( cat_eqp_version_s varchar(19) not null, caused_by_s varchar(19) null, caused_by_t varchar(16) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, original_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null, version_s varchar(19) not null) go sp_primarykey cat_eqp_version, cat_eqp_version_s go create table cell ( cell_s varchar(19) not null, description varchar(255) null, symbol_library_id varchar(40) not null, symbol_type_id varchar(40) not null) go sp_primarykey cell, cell_s go create table cement ( cement_s varchar(19) not null, description varchar(255) null, identifier varchar(40) null, r_existence_kd_nm varchar(40) not null) go sp_primarykey cement, cement_s go create table cement_csg_str ( activity_name varchar(40) null, casing_string_s varchar(19) not null, cement_csg_str_s varchar(19) not null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null, wellbore_id varchar(40) null, wellbore_s varchar(19) null) go sp_primarykey cement_csg_str, cement_csg_str_s go create table cement_type ( cement_type_s varchar(19) not null, description varchar(255) null, r_naming_system_kd varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, typical_mtrl_name varchar(40) not null, version varchar(40) null) go sp_primarykey cement_type, cement_type_s go create table chemical_ele_ty ( chemical_ele_ty_s varchar(19) not null, description varchar(255) null, r_naming_system_kd varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, typical_mtrl_name varchar(40) not null, version varchar(40) null) go sp_primarykey chemical_ele_ty, chemical_ele_ty_s go create table chem_cmpd_ty ( chem_cmpd_ty_s varchar(19) not null, description varchar(255) null, r_naming_system_kd varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, typical_mtrl_name varchar(40) not null, version varchar(40) null) go sp_primarykey chem_cmpd_ty, chem_cmpd_ty_s go create table choke ( choke_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey choke, choke_s go create table choke_adj_evnt ( activity_name varchar(40) null, choke_adj_evnt_s varchar(19) not null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey choke_adj_evnt, choke_adj_evnt_s go create table clsn_sys ( clsn_sys_name varchar(40) not null, clsn_sys_s varchar(19) not null, description varchar(255) null, kind varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey clsn_sys, clsn_sys_s go create table cmgl_prmt ( application_date datetime null, cmgl_prmt_s varchar(19) not null, cmps_doc_spec_s varchar(19) null, description varchar(255) null, document_spec_id varchar(40) not null, effective_date datetime null, expiry_date datetime null, information_cntn_s varchar(19) null, issued_by_s varchar(19) null, notification_date datetime null, typ_doc_spec_id varchar(40) null) go sp_primarykey cmgl_prmt, cmgl_prmt_s go create table cmps_doc_spec ( activity_name varchar(40) null, cmps_doc_spec_s varchar(19) not null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey cmps_doc_spec, cmps_doc_spec_s go create table cmps_graph_ele ( cell_s varchar(19) null, cmps_graph_ele_s varchar(19) not null, depicted_object_s varchar(19) null, depicted_object_t varchar(16) null, document_spec_s varchar(19) not null, document_spec_t varchar(16) not null, graphical_ele_id varchar(40) not null, graph_ele_cmpn_s varchar(19) null) go sp_primarykey cmps_graph_ele, cmps_graph_ele_s go create table cngrs_lsa ( cngrs_lsa_s varchar(19) not null, lot_number int null, lsa_id varchar(40) null, polygon_dsc varchar(255) null, principal_meridian varchar(40) null, range int null, range_fraction varchar(40) null, r_east_or_west_nm varchar(40) null, r_nrth_or_south_kd varchar(40) null, section_suffix char(1) null, section_type varchar(40) null, subdivision varchar(255) null, township int null, township_fraction varchar(40) null, township_name varchar(40) null, township_rng_sect int null, tract_number int null) go sp_primarykey cngrs_lsa, cngrs_lsa_s go create table coiled_tbg_reel ( coiled_tbg_reel_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey coiled_tbg_reel, coiled_tbg_reel_s go create table coiled_tbg_sect ( coiled_tbg_sect_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey coiled_tbg_sect, coiled_tbg_sect_s go create table coiled_tbg_unt ( coiled_tbg_unt_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey coiled_tbg_unt, coiled_tbg_unt_s go create table coiled_tubing ( coiled_tubing_s varchar(19) not null, description varchar(255) null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey coiled_tubing, coiled_tubing_s go create table color_palette ( color_palette_s varchar(19) not null, description varchar(255) null, image_palet_ty_id varchar(40) not null, symbol_library_id varchar(40) not null) go sp_primarykey color_palette, color_palette_s go create table contractual_obl ( contractual_obl_id varchar(40) not null, contractual_obl_s varchar(19) not null, contract_s varchar(19) not null, contract_t varchar(16) not null, description varchar(255) null, due_date datetime null, effective_date datetime null, expiry_date datetime null, r_contract_obl_kd varchar(40) null, r_obl_freq_name varchar(40) null) go sp_primarykey contractual_obl, contractual_obl_s go create table contract_act_ty ( contractual_obl_s varchar(19) null, contract_act_ty_s varchar(19) not null, contract_s varchar(19) null, contract_t varchar(16) null, description varchar(255) null, typical_act_name varchar(40) not null) go sp_primarykey contract_act_ty, contract_act_ty_s go create table contract_alias ( contract_alias_s varchar(19) not null, contract_s varchar(19) not null, contract_t varchar(16) not null, description varchar(255) null, effective_date datetime null, expiry_date datetime null, identifier varchar(40) not null, r_naming_system_kd varchar(40) not null) go sp_primarykey contract_alias, contract_alias_s go create table contract_clause ( amendment_date datetime null, amend_ctrt_clse_s varchar(19) null, contract_clause_nm varchar(40) null, contract_clause_s varchar(19) not null, contract_l int null, contract_s varchar(19) null, contract_t varchar(16) null, ctrt_clse_set_s varchar(19) null, description varchar(255) null, entity_type_nm varchar(40) not null, r_clse_amnd_rsn_nm varchar(40) null, r_contract_clse_kd varchar(40) null, text text null, text_location varchar(40) null) go sp_primarykey contract_clause, contract_clause_s go create table contract_dsgn ( account_number varchar(255) null, address_s varchar(19) null, address_t varchar(16) null, amount float null, amount_u varchar(15) null, bsasc_role varchar(40) not null, bsasc_s varchar(19) not null, contractual_obl_s varchar(19) null, contract_dsgn_s varchar(19) not null, contract_s varchar(19) null, contract_t varchar(16) null, depository_dsgn_s varchar(19) null, description varchar(255) null, effective_date datetime null, entity_type_nm varchar(40) not null, expiry_date datetime null, kind varchar(40) null, percent float null, r_hold_or_pay_kind varchar(40) null) go sp_primarykey contract_dsgn, contract_dsgn_s go create table contract_ref ( contract_ref_s varchar(19) not null, description varchar(255) null, for_contract_s varchar(19) not null, for_contract_t varchar(16) not null, from_contract_s varchar(19) not null, from_contract_t varchar(16) not null, r_ctrt_ref_use_nm varchar(40) not null) go sp_primarykey contract_ref, contract_ref_s go create table contract_remark ( bsasc_s varchar(19) null, contract_l int null, contract_remark_s varchar(19) not null, contract_s varchar(19) null, contract_t varchar(16) null, remark text not null, remark_date datetime null) go sp_primarykey contract_remark, contract_remark_s go create table contract_status ( caused_by_s varchar(19) null, caused_by_t varchar(16) null, contract_s varchar(19) not null, contract_status_s varchar(19) not null, contract_t varchar(16) not null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_contract_sta_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey contract_status, contract_status_s go create table coordinate_sys ( coordinate_sys_id varchar(40) not null, coordinate_sys_s varchar(19) not null, description varchar(255) null, entity_type_nm varchar(40) not null, geodetic_datum_id varchar(80) null, prime_meridian_id varchar(40) null, r_axis_ornt_kind varchar(40) null, r_cord_sys_cstr_nm varchar(40) not null, r_display_ornt varchar(40) null, r_map_proj_kind varchar(40) null, r_naming_system_kd varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null, vertex_s varchar(19) null, vertex_t varchar(16) null) go sp_primarykey coordinate_sys, coordinate_sys_s go create table coordinate_trfm ( coordinate_trfm_id varchar(40) not null, coordinate_trfm_s varchar(19) not null, cord_trfm_mth_id varchar(40) not null, description varchar(255) null, r_trfm_cstr_name varchar(40) null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey coordinate_trfm, coordinate_trfm_s go create table coo_agreement ( bsasc_s varchar(19) null, cmps_doc_spec_s varchar(19) null, coo_agreement_s varchar(19) not null, description varchar(255) null, document_spec_id varchar(40) not null, duration float null, duration_u varchar(15) null, effective_date datetime null, execution_date datetime null, expiry_date datetime null, information_cntn_s varchar(19) null, original_expiry_dt datetime null, recorded_date datetime null, recorded_line varchar(40) null, recorded_page varchar(40) null, recorded_volume varchar(40) null, r_naming_system_kd varchar(40) null, typ_doc_spec_id varchar(40) null) go sp_primarykey coo_agreement, coo_agreement_s go create table cord_sys_alias ( coordinate_sys_id varchar(40) not null, cord_sys_alias_s varchar(19) not null, description varchar(255) null, effective_date datetime null, expiry_date datetime null, identifier varchar(40) not null, r_naming_system_kd varchar(40) not null) go sp_primarykey cord_sys_alias, cord_sys_alias_s go create table cord_sys_axis ( cord_sys_axis_s varchar(19) not null, cord_sys_id varchar(40) null, cord_sys_id_l int null, description varchar(255) null, entity_type_nm varchar(40) not null, measurement_dtm_s varchar(19) null, measurement_dtm_t varchar(16) null, normal_to_datum_s varchar(19) null, normal_to_datum_t varchar(16) null, r_axis_ornt_kind varchar(40) null, r_property_type_nm varchar(40) not null, r_vaxis_ornt_name varchar(40) null, source varchar(40) null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null, vertical_datum_s varchar(19) null, vertical_datum_t varchar(16) null) go sp_primarykey cord_sys_axis, cord_sys_axis_s go create table cord_trfm_act ( activity_name varchar(40) null, app_cord_trfm_s varchar(19) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cord_trfm_act_s varchar(19) not null, cost float null, cost_u varchar(15) null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey cord_trfm_act, cord_trfm_act_s go create table cord_trfm_mth ( cord_trfm_mth_id varchar(40) not null, cord_trfm_mth_s varchar(19) not null, description varchar(255) null, r_cord_trfm_kind varchar(40) not null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey cord_trfm_mth, cord_trfm_mth_s go create table cord_trfm_par ( cord_trfm_mth_id varchar(40) not null, cord_trfm_par_s varchar(19) not null, description varchar(255) null, r_cord_trfm_par_nm varchar(40) not null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, version varchar(40) null) go sp_primarykey cord_trfm_par, cord_trfm_par_s go create table cord_trfm_val ( coordinate_trfm_id varchar(40) not null, cord_trfm_par_s varchar(19) not null, cord_trfm_val_s varchar(19) not null, description varchar(255) null, integer_value int null, location_value varchar(16) null, quantity_value float null, quantity_value_u varchar(15) null, real_value float null, source varchar(40) not null, source_reference_s varchar(19) null, status varchar(11) null, string_value varchar(40) null, version varchar(40) null) go sp_primarykey cord_trfm_val, cord_trfm_val_s go create table core ( bottom_depth float null, bottom_depth_u varchar(15) null, brhl_gnr_run_s varchar(19) null, core_s varchar(19) not null, description varchar(255) null, inventory_obj_id varchar(40) null, k float null, kh_90_degree float null, kh_90_degree_u varchar(15) null, kh_max float null, kh_max_u varchar(15) null, kind varchar(40) null, k_u varchar(15) null, produced_by_act_s varchar(19) null, produced_by_act_t varchar(16) null, rock_material_s varchar(19) null, rock_material_t varchar(16) null, r_diameter_name varchar(15) null, r_existence_kd_nm varchar(40) not null, r_naming_system_kd varchar(40) null, source_activity_s varchar(19) null, source_activity_t varchar(16) null, top_depth float null, top_depth_u varchar(15) null, wrln_log_pass_s varchar(19) null, wtst_recovery_s varchar(19) null, wtst_recovery_t varchar(16) null) go sp_primarykey core, core_s go create table ctrt_clse_it ( contract_clause_s varchar(19) not null, ctrt_clse_it_s varchar(19) not null, description varchar(255) null, item_count int null, item_date datetime null, item_quantity float null, item_quantity_u varchar(15) null, monetary_value float null, monetary_value_u varchar(15) null, r_ctrt_clse_it_kd varchar(40) not null) go sp_primarykey ctrt_clse_it, ctrt_clse_it_s go create table ctrt_clse_set ( cmps_doc_spec_s varchar(19) null, ctrt_clse_set_s varchar(19) not null, description varchar(255) null, document_spec_id varchar(40) not null, information_cntn_s varchar(19) null, typ_doc_spec_id varchar(40) null) go sp_primarykey ctrt_clse_set, ctrt_clse_set_s go create table ctrt_proc_opr ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, ctrt_proc_opr_s varchar(19) not null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey ctrt_proc_opr, ctrt_proc_opr_s go create table curve_fit_act ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, curve_fit_act_s varchar(19) not null, description varchar(255) null, diagram_spec_s varchar(19) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey curve_fit_act, curve_fit_act_s go create table dae_aggr_ty ( dae_aggr_ty_s varchar(19) not null, element_domain_s varchar(19) not null, element_domain_t varchar(16) not null, entity_type_nm varchar(40) not null, lower_bound int null, sparse_flag char(1) null, subset_flag char(1) null, unique_flag char(1) null, upper_bound int null) go sp_primarykey dae_aggr_ty, dae_aggr_ty_s go create table dae_application ( dae_application_nm varchar(40) not null, dae_application_s varchar(19) not null, description varchar(255) not null, vendor varchar(40) null, version varchar(40) null) go sp_primarykey dae_application, dae_application_s go create table dae_app_prefer ( application_s varchar(19) not null, dae_app_prefer_s varchar(19) not null, entity_type_nm varchar(40) not null, owner_s varchar(19) not null) go sp_primarykey dae_app_prefer, dae_app_prefer_s go create table dae_atr_athr ( attribute_def_s varchar(19) not null, created datetime not null, dae_atr_athr_s varchar(19) not null, grantable char(1) not null, grantee_s varchar(19) not null, grantor_s varchar(19) not null, privilege varchar(11) not null) go sp_primarykey dae_atr_athr, dae_atr_athr_s go create table dae_atr_def ( attribute_domain_s varchar(19) not null, attribute_domain_t varchar(16) not null, dae_atr_def_name varchar(40) not null, dae_atr_def_s varchar(19) not null, duplicates char(1) null, entity_type_nm varchar(40) not null, extension_flag char(1) null, inverted_attr_s varchar(19) null, max_cardinality int null, min_cardinality int null, optional_flag char(1) null, parent_entity_s varchar(19) not null, subset_flag char(1) null) go sp_primarykey dae_atr_def, dae_atr_def_s go create table dae_data_store ( created datetime not null, dae_data_store_nm varchar(40) not null, dae_data_store_s varchar(19) not null, data_store_type varchar(17) not null, express_filename varchar(255) null, owner_s varchar(19) not null, parent_s varchar(19) null, server_s varchar(19) null) go sp_primarykey dae_data_store, dae_data_store_s go create table dae_dimension ( count_val int not null, dae_dimension_s varchar(19) not null, dae_i_type int not null, grid_1d_s varchar(19) null, lower_bound int not null, ordinal int not null, parent_frame_l int null, parent_frame_s varchar(19) null) go sp_primarykey dae_dimension, dae_dimension_s go create table dae_dstore_root ( always_true char(1) not null, dae_dstore_root_s varchar(19) not null, defining_dsc_s varchar(19) not null, facility_uuid varchar(255) null, name varchar(40) not null) go sp_primarykey dae_dstore_root, dae_dstore_root_s go create table dae_ds_header ( authorizations varchar(80) not null, dae_ds_header_s varchar(19) not null, data_model_id varchar(255) null, data_model_version varchar(255) null, description varchar(255) null, facility_uuid varchar(255) null, imported_using_s varchar(19) null, name varchar(40) not null, originating_system varchar(80) null, preprc_version varchar(80) null, time_stamp varchar(255) null) go sp_primarykey dae_ds_header, dae_ds_header_s go create table dae_entity_athr ( created datetime not null, dae_entity_athr_s varchar(19) not null, entity_def_s varchar(19) not null, grantable char(1) not null, grantee_s varchar(19) not null, grantor_s varchar(19) not null, privilege varchar(11) not null, search_condition varchar(255) null) go sp_primarykey dae_entity_athr, dae_entity_athr_s go create table dae_entity_def ( complex_flag char(1) not null, dae_entity_def_nm varchar(40) not null, dae_entity_def_s varchar(19) not null, extension_flag char(1) null, independent char(1) not null, instantiable char(1) not null, owning_datastore_s varchar(19) null, subset_flag char(1) null) go sp_primarykey dae_entity_def, dae_entity_def_s go create table dae_enum_ty ( dae_enum_ty_name varchar(40) not null, dae_enum_ty_s varchar(19) not null) go sp_primarykey dae_enum_ty, dae_enum_ty_s go create table dae_epcnt_dtype ( coordinate_systems varchar(40) null, coord_precision int null, currency varchar(15) null, dae_epcnt_dtype_nm varchar(40) not null, dae_epcnt_dtype_s varchar(19) not null, entity_type_nm varchar(40) not null, fractional_seconds int null, grid_element varchar(17) null, property_precision int null, property_types varchar(40) null, real_precision int null, representation_ty varchar(7) null, r_quantity_type_nm varchar(40) null) go sp_primarykey dae_epcnt_dtype, dae_epcnt_dtype_s go create table dae_exch_prof ( dae_exch_prof_s varchar(19) not null, data_model_id varchar(255) null, data_model_version varchar(255) null, description varchar(255) null, name varchar(40) not null, namespace varchar(40) not null, version varchar(255) null) go sp_primarykey dae_exch_prof, dae_exch_prof_s go create table dae_export_dsc ( dae_export_dsc_nm varchar(40) not null, dae_export_dsc_s varchar(19) not null, description varchar(255) null, exchange_set_s varchar(19) null, extract_from_s varchar(19) null, profile_s varchar(19) null) go sp_primarykey dae_export_dsc, dae_export_dsc_s go create table dae_facility ( api_name varchar(40) not null, api_vendor varchar(40) not null, api_version varchar(40) not null, dae_facility_name varchar(40) not null, dae_facility_s varchar(19) not null) go sp_primarykey dae_facility, dae_facility_s go create table dae_frame ( attribute_name varchar(40) not null, bdal_name varchar(40) null, coordinate_sys_id varchar(40) null, dae_frame_s varchar(19) not null, entity_type_nm varchar(40) not null, e_type int not null, f_type int not null, grid_s varchar(19) null, grid_t varchar(16) null, instance_s varchar(19) not null, instance_t varchar(16) not null, rec_key varchar(40) null, vertex_s varchar(19) null, vertex_t varchar(16) null) go sp_primarykey dae_frame, dae_frame_s go create table dae_import_dsc ( dae_import_dsc_nm varchar(40) not null, dae_import_dsc_s varchar(19) not null, description varchar(255) null, destination_s varchar(19) null, profile_s varchar(19) null) go sp_primarykey dae_import_dsc, dae_import_dsc_s go create table dae_leaf_frame ( bdal_name varchar(40) null, dae_leaf_frame_s varchar(19) not null, first_value float null, inval_evnt_cnt int null, last_value float null, maximum_value float null, mean_value float null, minimum_value float null, parent_frame_l int null, parent_frame_s varchar(19) null, population_count int null, property_axis_s varchar(19) null, property_type_s varchar(19) not null, rec_key varchar(40) null, standard_dev float null, unit_acronym varchar(15) null, value_formula varchar(255) null) go sp_primarykey dae_leaf_frame, dae_leaf_frame_s go create table dae_qnt_unt ( dae_qnt_unt_s varchar(19) not null, quantity_type varchar(40) not null, unit varchar(40) not null) go sp_primarykey dae_qnt_unt, dae_qnt_unt_s go create table dae_role ( created datetime not null, dae_role_name varchar(40) not null, dae_role_s varchar(19) not null) go sp_primarykey dae_role, dae_role_s go create table dae_role_athr ( created datetime not null, dae_role_athr_s varchar(19) not null, grantable char(1) not null, grantee_s varchar(19) not null, grantor_s varchar(19) not null, user_role_s varchar(19) not null) go sp_primarykey dae_role_athr, dae_role_athr_s go create table dae_role_priv ( attribute_def_s varchar(19) null, dae_role_priv_s varchar(19) not null, dae_role_s varchar(19) null, entity_def_s varchar(19) null, privilege varchar(11) not null, search_condition varchar(255) null) go sp_primarykey dae_role_priv, dae_role_priv_s go create table dae_server ( dae_server_name varchar(40) not null, dae_server_s varchar(19) not null, vendor varchar(40) not null, version varchar(40) not null) go sp_primarykey dae_server, dae_server_s go create table dae_simple_type ( dae_simple_type_nm varchar(40) not null, dae_simple_type_s varchar(19) not null, entity_type_nm varchar(40) not null, fixed_flag char(1) null, real_precision int null, width int null) go sp_primarykey dae_simple_type, dae_simple_type_s go create table dae_swtch_rule ( dae_swtch_rule_s varchar(19) not null, entity_type_nm varchar(40) not null, failure_action varchar(5) not null, fixup_name varchar(40) null, label varchar(40) null, parent_datastore_s varchar(19) null, parent_entity_s varchar(19) null, secondary_id char(1) null, subset_flag char(1) null, test_name varchar(40) not null, test_status varchar(9) not null, type_name varchar(40) null) go sp_primarykey dae_swtch_rule, dae_swtch_rule_s go create table dae_user ( created datetime not null, create_data_store char(1) not null, dae_user_id varchar(40) not null, dae_user_s varchar(19) not null) go sp_primarykey dae_user, dae_user_s go create table damage_area ( damage_area_id varchar(40) null, damage_area_s varchar(19) not null, incdt_of_ncom_s varchar(19) null) go sp_primarykey damage_area, damage_area_s go create table data_collection ( activity_s varchar(19) null, activity_t varchar(16) null, bsasc_s varchar(19) null, data_collection_nm varchar(40) null, data_collection_s varchar(19) not null, document_spec_s varchar(19) null, document_spec_t varchar(16) null, populated_by_s varchar(19) null, populated_by_t varchar(16) null, process_par_s varchar(19) null, r_data_coll_ty_nm varchar(40) null, updated_by_s varchar(19) null, updated_by_t varchar(16) null) go sp_primarykey data_collection, data_collection_s go create table decline_anal ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, decline_anal_s varchar(19) not null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey decline_anal, decline_anal_s go create table derv_int_mkup ( caused_by_s varchar(19) null, caused_by_t varchar(16) null, derv_int_mkup_s varchar(19) not null, description varchar(255) null, duration float null, duration_u varchar(15) null, end_time datetime null, fraction float null, interest_for_s varchar(19) not null, interest_for_t varchar(16) not null, interest_of_s varchar(19) not null, r_transient_period varchar(40) null, start_time datetime null, terminated_by_s varchar(19) null, terminated_by_t varchar(16) null) go sp_primarykey derv_int_mkup, derv_int_mkup_s go create table diagram_spec ( cmps_doc_spec_s varchar(19) null, description varchar(255) null, diagram_spec_s varchar(19) not null, document_spec_id varchar(40) not null, information_cntn_s varchar(19) null, typ_doc_spec_id varchar(40) null) go sp_primarykey diagram_spec, diagram_spec_s go create table digital_stor_fcl ( description varchar(255) null, digital_stor_fcl_s varchar(19) not null, end_date datetime null, general_fcl_name varchar(40) null, identifying_fcl_s varchar(19) null, identifying_fcl_t varchar(16) null, r_existence_kd_nm varchar(40) not null, start_date datetime null, typical_fcl_name varchar(40) null) go sp_primarykey digital_stor_fcl, digital_stor_fcl_s go create table digitize_doc ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, digitize_doc_s varchar(19) not null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, source_document_s varchar(19) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey digitize_doc, digitize_doc_s go create table dir_srvy_anal ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float null, cost_u varchar(15) null, description varchar(255) null, dir_srvy_anal_s varchar(19) not null, duration float null, duration_u varchar(15) null, end_time datetime null, r_existence_kd_nm varchar(40) not null, r_transient_period varchar(40) null, start_time datetime null, typical_act_name varchar(40) null, utilize_eqp_s varchar(19) null) go sp_primarykey dir_srvy_anal, dir_srvy_anal_s go create table discovery_area ( application_date datetime null, declaration_date datetime null, description varchar(255) null, discovery_area_s varchar(19) not null, effective_date datetime null, expiry_date datetime null, identifier varchar(80) not null, r_disc_area_kind varchar(40) null, r_naming_system_kd varchar(40) null) go sp_primarykey discovery_area, discovery_area_s go create table divestment_pkg ( closing_date datetime null, divestment_pkg_nm varchar(40) not null, divestment_pkg_s varchar(19) not null, part_of_s varchar(19) null, response_due_date datetime null, r_sale_kind varchar(40) null, sale_date datetime null, sale_effective_dt datetime null, sale_offer_date datetime null) go sp_primarykey divestment_pkg, divestment_pkg_s go create table document ( digitize_doc_s varchar(19) null, document_s varchar(19) not null, document_spec_s varchar(19) not null, document_spec_t varchar(16) not null, entity_type_nm varchar(40) not null, inventory_obj_id varchar(40) null, render_document_s varchar(19) null, r_digital_fmt_kind varchar(40) null, r_hardcopy_doc_nm varchar(40) null, r_naming_system_kd varchar(40) null, title varchar(40) null, x_scale_d int null, x_scale_n int null, y_scale_d int null, y_scale_n int null) go sp_primarykey document, document_s go create table document_circ ( activity_name varchar(40) null, containing_act_s varchar(19) null, containing_act_t varchar(16) null, cost float