Table ROCK_FEATURE

POSC Specifications Version 2.2

Epicentre Relational Implementation

ROCK_FEATURE (ROCK_FEATURE)

A quantity of rock material composing a portion of the earth subsurface. The rock feature is used to name and specify rock bodies. These rock bodies are meant to contain the total possible extend of the feature.

rock_feature_s (PK, M: CHAR VARYING(19)): Surrogate key of the table.
r_existence_kd_nm (FNK, M: CHAR VARYING(40)): material.ref_existence_kind
The existence kind of the material e.g. actual, planned, required, or predicted.
Defines a foreign key to table r_existence_kd.
description (O: CHAR VARYING(2000)): material.description
A textual description of the material.
rock_feature_id (O: CHAR VARYING(40)): rock_feature.identifier
The label used to distinguish a rock feature.
r_naming_system_kd (FNK, O: CHAR VARYING(40)): rock_feature.ref_naming_system
The naming system in which the identifier is defined.
Defines a foreign key to table r_naming_system.

Table is related to: material_cmps, dae_frame, geol_age_clsn, geologic_obj_asn, @graphical_element, @hole, ntrp_ftr_asn, material_class, material_clsn, material_fulfl, material_insl, material_typf, object_ranking, parameter_value, pool, @position_in_earth_model, @position_in_wellbore, @position_on_earth_surface, p_absolute_abdc, p_acoustic_impd, p_acoustic_vel, p_acst_vel_cv, p_area, p_moment_per_len, p_biot_coef, p_bulk_density, p_bulk_modulus, p_capacitance, p_cation_exchcap, p_cmt_fct, p_cmpr_cv, p_mass_per_mass, p_mass_per_vol, p_mole_per_vol, p_volume_per_mol, p_volume_per_vol, p_conductance, p_density_solid, p_effective_perm, p_effective_por, p_electrical_res, p_electric_pot, p_electric_resvy, p_element_value, p_fm_fct_cv, p_fm_resvy_fct, p_geologic_age, p_geol_age_rng, p_grain_size, p_heat_flux, p_heat_rls_rt, p_heat_xfer_coef, p_in_surf_area, p_intv_trnst_tm, p_ln_thrm_xpn, p_lith_color, p_mass, p_mass_spct_abdc, p_matrix_cmpr, p_matrix_density, p_mineral_hrd, p_overburden_prs, p_permeability, p_perm_cmpct_cv, p_perm_cmpct_pt, p_perm_hor, p_perm_vert, p_poissons_ratio, p_pore_pressure, p_pore_thrt_dia, p_pore_vol_cmpr, p_porosity, p_por_cmpct_cv, p_por_cmpct_pt, p_pyrl_h_idx, p_pyrl_o2_idx, p_pyrolysis_s0, p_pyrolysis_s1, p_pyrolysis_s2, p_pyrolysis_s3, p_pyrl_t_max, p_radioactivity, p_refractive_idx, p_resvy_idx, p_resvy_idx_cv, p_shear_modulus, p_sptl_gr_intn, p_sp_heat_mass, p_sp_in_area, p_spectral_fluor, p_spct_gr_intn, p_area_per_vol, p_temperature, p_thrm_alt_idx, p_torque, p_tortuosity, p_total_cmpr, p_total_orgc_c, p_tot_orgc_mttr, p_transient_temp, p_vh_perm_rto, @pty_volume, p_weight, p_wet_idx, p_youngs_modulus, rock_ftr_alias, @rock_feature_part, seis_ftr_clsn, wb_geol_targ

Intersection Tables: utilize_material_x, rock_feature_x, coll_cntn_x, geol_ftr_proc_x, geol_ftr_prov_x, rock_material_x, processed_mtrl_x, rock_anal_mtrl_x, fluid_ftr_rck_x, fl_iact_mtrl_x, source_mtrl_x

Primary Key Constraint on: ROCK_FEATURE_S