run_hist

11947 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
year int4 10 √ null
qtr int4 10 √ null
month int4 10 √ null
below_rotary date 13 √ null
above_rotary date 13 √ null
region varchar 64 √ null
area varchar 32 √ null
country varchar 32 √ null
district varchar 64 √ null
sperry_dist varchar 32 √ null
state varchar 32 √ null
county varchar 32 √ null
field varchar 32 √ null
block varchar 32 √ null
customer_grp varchar 32 √ null
customer varchar 64 √ null
well_name varchar 32 √ null
well_type varchar 32 √ null
rig_name varchar 32 √ null
sap_zspo int4 10 √ null
job_run_no varchar 24 √ null
job_no varchar 24 √ null
run_no varchar 16 √ null
opr_hrs float8 17,17 √ null
cir_hrs float8 17,17 √ null
brt_hrs float8 17,17 √ null
drl_hrs float8 17,17 √ null
rm_hrs float8 17,17 √ null
si bool 1 √ null
tf bool 1 √ null
npt_exc_spec float8 17,17 √ null
exc_spec bool 1 √ null
exc_spec_npt float8 17,17 √ null
md_in_ft float8 17,17 √ null
md_out_ft float8 17,17 √ null
tvd_in_ft float8 17,17 √ null
tvd_out_ft float8 17,17 √ null
wtrdpth_ft float8 17,17 √ null
dist_drl_ft float8 17,17 √ null
hole_sz_in float8 17,17 √ null
hole_grp float8 17,17 √ null
tool_od_in float8 17,17 √ null
tool_od_grp float8 17,17 √ null
max_temp_c float8 17,17 √ null
mud_type varchar 32 √ null
mudwtavg_ppg float8 17,17 √ null
flowavg_gpm float8 17,17 √ null
wob_avg_klb float8 17,17 √ null
spp_avg_psi float8 17,17 √ null
hydpres_psi float8 17,17 √ null
bitpres_psi float8 17,17 √ null
rpm_avg float8 17,17 √ null
rpm_rot float8 17,17 √ null
rop_avg float8 17,17 √ null
trq_avg float8 17,17 √ null
inc_min float8 17,17 √ null
inc_max float8 17,17 √ null
az_min float8 17,17 √ null
az_max float8 17,17 √ null
dls_steering float8 17,17 √ null
dls_rotatng float8 17,17 √ null
dls_min float8 17,17 √ null
dls_max float8 17,17 √ null
bit_model varchar 64 √ null
bit_type varchar 32 √ null
bit_manuf varchar 32 √ null
dd bool 1 √ null
mwd bool 1 √ null
gp bool 1 √ null
gp_type varchar 64 √ null
bha_comp1 varchar 64 √ null
bha_comp2 varchar 64 √ null
bha_comp3 varchar 64 √ null
bha_comp4 varchar 64 √ null
bha_comp5 varchar 64 √ null
bha_comp6 varchar 64 √ null
bha_comp7 varchar 64 √ null
bha_comp8 varchar 64 √ null
bha_comp9 varchar 64 √ null
bha_comp10 varchar 64 √ null
bha_comp11 varchar 64 √ null
bha_comp12 varchar 64 √ null
bha_comp13 varchar 64 √ null
bha_comp14 varchar 64 √ null
bha_comp15 varchar 64 √ null
bha_comp16 varchar 64 √ null
bha_comp17 varchar 64 √ null
bha_comp18 varchar 64 √ null
bha_comp19 varchar 64 √ null
bha_comp20 varchar 64 √ null
bha_comp21 varchar 64 √ null
bha_comp22 varchar 64 √ null
bha_comp23 varchar 64 √ null
bha_comp24 varchar 64 √ null
bha_comp25 varchar 64 √ null
bha_comp26 varchar 64 √ null
bha_comp27 varchar 64 √ null
bha_comp28 varchar 64 √ null
bha_comp29 varchar 64 √ null
bha_comp30 varchar 64 √ null
bha_comp31 varchar 64 √ null
bha_comp32 varchar 64 √ null
bha_comp33 varchar 64 √ null
bha_comp34 varchar 64 √ null
bha_comp35 varchar 64 √ null
rss bool 1 √ null
icruise bool 1 √ null

Relationships

Close relationships within degrees of separation