← Consulting

Data Dictionary — npd

Evidence summary: verified=335 candidate=69 not_assessed=181

apaareagros

  • Archetype: entity_store
  • Source anchor: table public.apaareagross

Fields

Field Type Nullable Description Constraints Known values Evidence
apaareageometry_kml_wgs84 String not null not assessed
apaareageometryewkt String not null not assessed
apaareagross_id Integer not null PK not assessed
apamap_no Integer not null not assessed

apaareanet

  • Archetype: entity_store
  • Source anchor: table public.apaareanet

Fields

Field Type Nullable Description Constraints Known values Evidence
apaareanet_id Integer not null PK not assessed
apaareanetgeometrywkt String unspecified not assessed
apaareatype String unspecified not assessed
blkid Integer not null PK not assessed
blklabel String not null not assessed
blkname String not null PK not assessed
prvname String not null PK not assessed
qdrname String not null PK not assessed
urlnpd String not null not assessed

baaarea

  • Archetype: entity_store
  • Source anchor: table public.baaarea

Fields

Field Type Nullable Description Constraints Known values Evidence
baaactive String not null Active profiled
baaareageometrywkt String not null not assessed
baaareapolyactive String not null not assessed
baaareapolydatevalidfrom Date not null Date valid from profiled
baaareapolydatevalidto Date unspecified Date valid to profiled
baadateapproved Date not null Date approved profiled
baadatevalidfrom Date not null Date valid from profiled
baadatevalidto Date unspecified Date valid to profiled
baafactmapurl String unspecified Fact map profiled
baafactpageurl String not null Fact page profiled
baakind String not null Kind profiled
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; FK → bsns_arr_area.baanpdidbsnsarrarea profiled
baanpdidbsnsarrareapoly Integer not null PK not assessed

Relationships

Name Target Type Description Evidence
bsns_arr_area bsns_arr_area belongs_to verified

bsns_arr_area

  • Archetype: entity_store
  • Source anchor: table public.bsns_arr_area

Fields

Field Type Nullable Description Constraints Known values Evidence
baadateapproved Date not null Date approved profiled
baadateupdated Date unspecified Date main level updated profiled
baadateupdatedmax Date unspecified Date all updated profiled
baadatevalidfrom Date not null Date valid from profiled
baadatevalidto Date unspecified Date valid to profiled
baafactmapurl String unspecified Fact map profiled
baafactpageurl String not null Fact page profiled
baakind String not null Kind profiled
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; UNIQUE profiled
datesyncnpd Date not null not assessed

bsns_arr_area_area_poly_hst

  • Archetype: entity_store
  • Source anchor: table public.bsns_arr_area_area_poly_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
baaareapolyarea Decimal not null Polygon area [km2] profiled
baaareapolyblockname String not null Block name PK profiled
baaareapolydateupdated Date unspecified Date updated profiled
baaareapolydatevalidfrom Date not null Date valid from PK profiled
baaareapolydatevalidto Date not null Date valid to PK profiled
baaareapolynationcode2 String not null Nation code profiled
baaareapolyno Integer not null PK not assessed
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; FK → bsns_arr_area.baanpdidbsnsarrarea profiled
datesyncnpd Date not null not assessed

Relationships

Name Target Type Description Evidence
bsns_arr_area bsns_arr_area belongs_to verified

bsns_arr_area_licensee_hst

  • Archetype: entity_store
  • Source anchor: table public.bsns_arr_area_licensee_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
baalicenseedateupdated Date unspecified Date updated profiled
baalicenseedatevalidfrom Date not null Date valid from PK profiled
baalicenseedatevalidto Date not null Date valid to PK profiled
baalicenseeinterest Decimal not null Interest [%] profiled
baalicenseesdfi Decimal unspecified SDFI [%] profiled
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; FK → bsns_arr_area.baanpdidbsnsarrarea profiled
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed

Relationships

Name Target Type Description Evidence
bsns_arr_area bsns_arr_area belongs_to verified
company company belongs_to verified

bsns_arr_area_operator

  • Archetype: entity_store
  • Source anchor: table public.bsns_arr_area_operator

Fields

Field Type Nullable Description Constraints Known values Evidence
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; FK → bsns_arr_area.baanpdidbsnsarrarea profiled
baaoperatordateupdated Date unspecified Date updated profiled
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed

Relationships

Name Target Type Description Evidence
bsns_arr_area bsns_arr_area belongs_to verified
company company belongs_to verified

bsns_arr_area_transfer_hst

  • Archetype: entity_store
  • Source anchor: table public.bsns_arr_area_transfer_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
baaname String not null Name profiled
baanpdidbsnsarrarea Integer not null NPDID Bsns. Arr. Area PK; FK → bsns_arr_area.baanpdidbsnsarrarea profiled
baatransferdateupdated Date unspecified Date updated profiled
baatransferdatevalidfrom Date not null Date valid from PK profiled
baatransferdirection String not null Transfer direction PK profiled
baatransferkind String unspecified Transfer kind profiled
baatransferredinterest Decimal not null Transferred interest [%] profiled
baatransfersdfi Decimal unspecified SDFI [%] profiled
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed

Relationships

Name Target Type Description Evidence
bsns_arr_area bsns_arr_area belongs_to verified
company company belongs_to verified

company

  • Archetype: entity_store
  • Source anchor: table public.company

Fields

Field Type Nullable Description Constraints Known values Evidence
cmpgroup String unspecified Group profiled
cmplicencelicenseecurrent String not null Currently licence licensee profiled
cmplicencelicenseeformer String not null Former licence licensee profiled
cmplicenceopercurrent String not null Currently licence operator profiled
cmplicenceoperformer String not null Former licence operator profiled
cmplongname String not null Company name UNIQUE profiled
cmpnpdidcompany Integer not null NPDID company PK; UNIQUE profiled
cmporgnumberbrreg String unspecified Organisation number profiled
cmpshortname String not null Company shortname UNIQUE profiled
datesyncnpd Date not null not assessed

company_reserve

  • Archetype: entity_store
  • Source anchor: table public.company_reserves

Fields

Field Type Nullable Description Constraints Known values Evidence
cmpdateoffresestdisplay Date not null not assessed
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
cmprecoverablecondensate Decimal not null not assessed
cmprecoverablegas Decimal not null not assessed
cmprecoverablengl Decimal not null not assessed
cmprecoverableoe Decimal not null not assessed
cmprecoverableoil Decimal not null not assessed
cmpremainingcondensate Decimal not null not assessed
cmpremaininggas Decimal not null not assessed
cmpremainingngl Decimal not null not assessed
cmpremainingoe Decimal not null not assessed
cmpremainingoil Decimal not null not assessed
cmpshare Decimal not null not assessed
datesyncnpd Date not null not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
field field belongs_to verified

discovery

  • Archetype: entity_store
  • Source anchor: table public.discovery

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String unspecified Company name profiled
datesyncnpd Date not null not assessed
dsccurrentactivitystatus String not null Current activity status profiled
dscdatefrominclinfield Date unspecified Included in field from date profiled
dscdateupdated Date unspecified Date main level updated profiled
dscdateupdatedmax Date unspecified Date all updated profiled
dscdiscoveryyear Integer not null Discovery year profiled
dscfactmapurl String not null Fact map profiled
dscfactpageurl String not null Fact page profiled
dschctype String unspecified HC type profiled
dscname String not null Discovery name profiled
dscnpdiddiscovery Integer not null NPDID discovery PK; UNIQUE profiled
dscownerkind String unspecified Owner kind profiled
dscownername String unspecified Owner name profiled
dscresinclindiscoveryname String unspecified Resources incl. in profiled
fldname String unspecified Field name profiled
fldnpdidfield Integer unspecified NPDID field FK → field.fldnpdidfield profiled
nmaname String unspecified Main NCS area profiled
wlbname String unspecified Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
field field belongs_to verified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

discovery_reserve

  • Archetype: entity_store
  • Source anchor: table public.discovery_reserves

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
dscdateoffresestdisplay Date not null Resource updated date profiled
dscname String not null Discovery name profiled
dscnpdiddiscovery Integer not null NPDID discovery PK; FK → discovery.dscnpdiddiscovery profiled
dscrecoverablecondensate Decimal not null Rec. cond. [mill Sm3] profiled
dscrecoverablegas Decimal not null Rec. gas [bill Sm3] profiled
dscrecoverablengl Decimal not null Rec. NGL [mill tonn] profiled
dscrecoverableoil Decimal not null Rec. oil [mill Sm3] profiled
dscreservesdateupdated Date not null not assessed
dscreservesrc String not null Resource class PK profiled

Relationships

Name Target Type Description Evidence
discovery discovery belongs_to verified

dscarea

  • Archetype: entity_store
  • Source anchor: table public.dscarea

Fields

Field Type Nullable Description Constraints Known values Evidence
dsccurrentactivitystatus String not null Current activity status profiled
dscfacturl String not null not assessed
dschctype String not null HC type PK profiled
dscincludedinfld String not null not assessed
dscname String not null Discovery name profiled
dscnpdiddiscovery Integer not null NPDID discovery PK; FK → discovery.dscnpdiddiscovery profiled
dscnpdidresinclindiscovery Integer unspecified FK → discovery.dscnpdiddiscovery not assessed
dscresinclindiscoveryname String unspecified Resources incl. in profiled
fldcurrentactivitystatus String unspecified not assessed
flddscareageometrywkt_ed50 String not null not assessed
flddsclabel String not null not assessed
fldfacturl String unspecified not assessed
fldhctype String unspecified not assessed
fldname String unspecified Field name profiled
fldnpdidfield Integer unspecified NPDID field FK → field.fldnpdidfield profiled

Relationships

Name Target Type Description Evidence
discovery discovery belongs_to verified
field field belongs_to verified

facility_fixed

  • Archetype: entity_store
  • Source anchor: table public.facility_fixed

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
fclbelongstokind String unspecified Belongs to, kind profiled
fclbelongstoname String unspecified Belongs to, name profiled
fclbelongstos Integer unspecified not assessed
fclcurrentoperatorname String unspecified Current operator profiled
fcldateupdated Date unspecified Date updated profiled
fcldesignlifetime Integer unspecified Design lifetime [year] profiled
fclewcode String not null EW code profiled
fclewdeg Integer unspecified EW degrees profiled
fclewmin Integer unspecified EW minutes profiled
fclewsec Decimal unspecified EW seconds profiled
fclfactmapurl String not null Fact map profiled
fclfactpageurl String not null Fact page profiled
fclfunctions String unspecified Functions profiled
fclgeodeticdatum String unspecified Geodetic datum profiled
fclkind String not null Kind profiled
fclname String not null Name profiled
fclnpdidfacility Integer not null NPDID facility PK; UNIQUE profiled
fclnscode String not null NS code profiled
fclnsdeg Integer unspecified NS degrees profiled
fclnsmin Integer unspecified NS minutes profiled
fclnssec Decimal unspecified NS seconds profiled
fclphase String not null Phase profiled
fclstartupdate Date unspecified Startup date profiled
fclsurface String not null Surface facility profiled
fclwaterdepth Decimal not null Water depth [m] profiled

facility_moveable

  • Archetype: entity_store
  • Source anchor: table public.facility_moveable

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
fclcurrentrespcompanyname String unspecified Current responsible company profiled
fcldateupdated Date unspecified Date updated profiled
fclfactpageurl String not null Fact page profiled
fclfunctions String unspecified Functions profiled
fclkind String not null Kind profiled
fclname String not null Name profiled
fclnationname String not null Nation profiled
fclnpdidcurrentrespcompany Integer unspecified NPDID responsible company FK → company.cmpnpdidcompany profiled
fclnpdidfacility Integer not null NPDID facility PK profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified

fclpoint

  • Archetype: entity_store
  • Source anchor: table public.fclpoint

Fields

Field Type Nullable Description Constraints Known values Evidence
fclbelongstokind String unspecified Belongs to, kind profiled
fclbelongstoname String unspecified Belongs to, name profiled
fclbelongstos Integer unspecified FK → tuf_petreg_licence.tufnpdidtuf not assessed
fclcurrentoperatorname String unspecified Current operator profiled
fcldesignlifetime Integer not null Design lifetime [year] profiled
fclfactmapurl String not null Fact map profiled
fclfactpageurl String not null Fact page profiled
fclfunctions String unspecified Functions profiled
fclkind String not null Kind profiled
fclname String not null Name profiled
fclnpdidfacility Integer not null NPDID facility PK; FK → facility_fixed.fclnpdidfacility profiled
fclpointgeometrywkt String not null not assessed
fclstartupdate Date not null Startup date profiled
fclsurface String not null Surface facility profiled
fclwaterdepth Decimal not null Water depth [m] profiled

Relationships

Name Target Type Description Evidence
facility_fixed facility_fixed belongs_to verified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

field

  • Archetype: entity_store
  • Source anchor: table public.field

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String unspecified Company name profiled
cmpnpdidcompany Integer unspecified NPDID company FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
fldcurrentactivitysatus String not null Current activity status profiled
flddateupdated Date unspecified Date main level updated profiled
flddateupdatedmax Date unspecified Date all updated profiled
fldfactmapurl String not null not assessed
fldfactpageurl String not null Field fact page profiled
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; UNIQUE profiled
fldnpdidowner Integer unspecified NPDID owner FK → licence.prlnpdidlicence profiled
fldownerkind String unspecified Owner kind profiled
fldownername String unspecified Owner name profiled
wlbcompletiondate Date unspecified Completion date profiled
wlbname String unspecified Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

field_activity_status_hst

  • Archetype: entity_store
  • Source anchor: table public.field_activity_status_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled
fldstatus String not null Status PK profiled
fldstatusdateupdated Date unspecified not assessed
fldstatusfromdate Date not null Status from PK profiled
fldstatustodate Date not null Status to PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to verified

field_description

  • Archetype: entity_store
  • Source anchor: table public.field_description

Fields

Field Type Nullable Description Constraints Known values Evidence
flddescriptiondateupdated Date not null Date updated profiled
flddescriptionheading String not null Heading PK profiled
flddescriptiontext String not null Text profiled
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled

Relationships

Name Target Type Description Evidence
field field belongs_to verified

field_investment_yearly

  • Archetype: entity_store
  • Source anchor: table public.field_investment_yearly

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prfinformationcarrier String not null Field (Discovery) profiled
prfinvestmentsmillnok Decimal not null Investments [mill NOK norminal values] profiled
prfnpdidinformationcarrier Integer not null NPDID information carrier PK; FK → field.fldnpdidfield profiled
prfyear Integer not null Year PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to verified

field_licensee_hst

  • Archetype: entity_store
  • Source anchor: table public.field_licensee_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
fldcompanyshare Decimal not null Company share [%] profiled
fldlicenseedateupdated Date unspecified Date updated profiled
fldlicenseefrom Date not null PK not assessed
fldlicenseeto Date not null PK not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled
fldownerfrom Date not null not assessed
fldownerkind String not null Owner kind profiled
fldownername String not null Owner name profiled
fldownerto Date unspecified not assessed
fldsdfishare Decimal unspecified SDFI [%] profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
field field belongs_to verified

field_operator_hst

  • Archetype: entity_store
  • Source anchor: table public.field_operator_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled
fldoperatordateupdated Date unspecified Date updated profiled
fldoperatorfrom Date not null PK not assessed
fldoperatorto Date not null PK not assessed

Relationships

Name Target Type Description Evidence
company company belongs_to verified
field field belongs_to verified

field_owner_hst

  • Archetype: entity_store
  • Source anchor: table public.field_owner_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled
fldnpdidowner Integer not null NPDID owner PK profiled
fldownerdateupdated Date unspecified Date updated profiled
fldownerkind String not null Owner kind profiled
fldownername String not null Owner name profiled
fldownershipfromdate Date not null PK not assessed
fldownershiptodate Date not null PK not assessed

Relationships

Name Target Type Description Evidence
field field belongs_to verified

field_production_monthly

  • Archetype: entity_store
  • Source anchor: table public.field_production_monthly

Fields

Field Type Nullable Description Constraints Known values Evidence
prfinformationcarrier String not null Field (Discovery) profiled
prfmonth Integer not null Month PK profiled
prfnpdidinformationcarrier Integer not null NPDID information carrier PK profiled
prfprdcondensatenetmillsm3 Decimal not null Net - condensate [mill Sm3] profiled
prfprdgasnetbillsm3 Decimal not null Net - gas [bill Sm3] profiled
prfprdnglnetmillsm3 Decimal not null Net - NGL [mill Sm3] profiled
prfprdoenetmillsm3 Decimal not null Net - oil equivalents [mill Sm3] profiled
prfprdoilnetmillsm3 Decimal not null Net - oil [mill Sm3] profiled
prfprdproducedwaterinfieldmillsm3 Decimal not null Produced water in field [mill Sm3] profiled
prfyear Integer not null Year PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to CANDIDATE — unverified

field_production_totalt_ncs_month

  • Archetype: entity_store
  • Source anchor: table public.field_production_totalt_ncs_month

Fields

Field Type Nullable Description Constraints Known values Evidence
prfmonth Integer not null Month PK profiled
prfprdcondensatenetmillsm3 Decimal not null Net - condensate [mill Sm3] profiled
prfprdgasnetbillsm3 Decimal not null Net - gas [bill Sm3] profiled
prfprdnglnetmillsm3 Decimal not null Net - NGL [mill Sm3] profiled
prfprdoenetmillsm3 Decimal not null Net - oil equivalents [mill Sm3] profiled
prfprdoilnetmillsm3 Decimal not null Net - oil [mill Sm3] profiled
prfprdproducedwaterinfieldmillsm3 Decimal not null Produced water in field [mill Sm3] profiled
prfyear Integer not null Year PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to CANDIDATE — unverified

field_production_totalt_ncs_year

  • Archetype: entity_store
  • Source anchor: table public.field_production_totalt_ncs_year

Fields

Field Type Nullable Description Constraints Known values Evidence
prfprdcondensatenetmillsm3 Decimal not null Net - condensate [mill Sm3] profiled
prfprdgasnetbillsm Decimal not null not assessed
prfprdnglnetmillsm3 Decimal not null Net - NGL [mill Sm3] profiled
prfprdoenetmillsm3 Decimal not null Net - oil equivalents [mill Sm3] profiled
prfprdoilnetmillsm Decimal not null not assessed
prfprdproducedwaterinfieldmillsm3 Decimal not null Produced water in field [mill Sm3] profiled
prfyear Integer not null Year PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to CANDIDATE — unverified

field_production_yearly

  • Archetype: entity_store
  • Source anchor: table public.field_production_yearly

Fields

Field Type Nullable Description Constraints Known values Evidence
prfinformationcarrier String not null Field (Discovery) profiled
prfnpdidinformationcarrier Integer not null NPDID information carrier PK profiled
prfprdcondensatenetmillsm3 Decimal not null Net - condensate [mill Sm3] profiled
prfprdgasnetbillsm3 Decimal not null Net - gas [bill Sm3] profiled
prfprdnglnetmillsm3 Decimal not null Net - NGL [mill Sm3] profiled
prfprdoenetmillsm3 Decimal not null Net - oil equivalents [mill Sm3] profiled
prfprdoilnetmillsm3 Decimal not null Net - oil [mill Sm3] profiled
prfprdproducedwaterinfieldmillsm3 Decimal not null Produced water in field [mill Sm3] profiled
prfyear Integer not null Year PK profiled

Relationships

Name Target Type Description Evidence
field field belongs_to CANDIDATE — unverified

field_reserve

  • Archetype: entity_store
  • Source anchor: table public.field_reserves

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
flddateoffresestdisplay Date not null Reserves updated date profiled
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field PK; FK → field.fldnpdidfield profiled
fldrecoverablecondensate Decimal not null Orig. recoverable cond. [mill Sm3] profiled
fldrecoverablegas Decimal not null Orig. recoverable gas [bill Sm3] profiled
fldrecoverablengl Decimal not null Orig. recoverable NGL [mill tonn] profiled
fldrecoverableoe Decimal not null Orig. recoverable oil eq. [mill Sm3 o.e] profiled
fldrecoverableoil Decimal not null Orig. recoverable oil [mill Sm3] profiled
fldremainingcondensate Decimal not null Remaining cond. [mill Sm3] profiled
fldremaininggas Decimal not null Remaining gas [bill Sm3] profiled
fldremainingngl Decimal not null Remaining NGL [mill tonn] profiled
fldremainingoe Decimal not null Remaining oil eq. [mill Sm3 o.e] profiled
fldremainingoil Decimal not null Remaining oil [mill Sm3] profiled

Relationships

Name Target Type Description Evidence
field field belongs_to verified

fldarea

  • Archetype: entity_store
  • Source anchor: table public.fldarea

Fields

Field Type Nullable Description Constraints Known values Evidence
dsccurrentactivitystatus String not null Current activity status profiled
dscfacturl String not null not assessed
dschctype String not null HC type PK profiled
dscincludedinfld String not null not assessed
dscname String not null Discovery name profiled
dscnpdiddiscovery Integer not null NPDID discovery PK; FK → discovery.dscnpdiddiscovery profiled
dscnpdidresinclindiscovery Integer unspecified FK → discovery.dscnpdiddiscovery not assessed
dscresinclindiscoveryname String unspecified Resources incl. in profiled
fldcurrentactivitystatus String not null not assessed
flddscareageometrywkt_ed50 String not null not assessed
flddsclabel String not null not assessed
fldfacturl String not null not assessed
fldhctype String not null not assessed
fldname String not null Field name profiled
fldnpdidfield Integer not null NPDID field FK → field.fldnpdidfield profiled

Relationships

Name Target Type Description Evidence
discovery discovery belongs_to verified
field field belongs_to verified

licence

  • Archetype: entity_store
  • Source anchor: table public.licence

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prlcurrentarea String not null Current area profiled
prldategranted Date not null Date granted profiled
prldateupdated Date unspecified Date main level updated profiled
prldateupdatedmax Date unspecified Date all updated profiled
prldatevalidto Date not null Date valid to profiled
prlfactmapurl String unspecified Fact map profiled
prlfactpageurl String not null Fact page profiled
prllicensingactivityname String not null Licensing activity profiled
prlmainarea String unspecified Main area profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; UNIQUE profiled
prloriginalarea Decimal not null Original area [km2] profiled
prlphasecurrent String unspecified Phase - current profiled
prlstatus String not null Status profiled

licence_area_poly_hst

  • Archetype: entity_store
  • Source anchor: table public.licence_area_poly_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prlareadateupdated Date unspecified Date updated profiled
prlareapolyblockname String not null Block name PK profiled
prlareapolydatevalidfrom Date not null Date valid from PK profiled
prlareapolydatevalidto Date not null Date valid to PK profiled
prlareapolynationcode String not null not assessed
prlareapolypolyarea Decimal not null Polygon area [km2] profiled
prlareapolypolyno Integer not null PK not assessed
prlareapolystratigraphical String not null Stratigraphcal profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled

Relationships

Name Target Type Description Evidence
licence licence belongs_to verified

licence_licensee_hst

  • Archetype: entity_store
  • Source anchor: table public.licence_licensee_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prllicenseedateupdated Date unspecified Date updated profiled
prllicenseedatevalidfrom Date not null Date valid from PK profiled
prllicenseedatevalidto Date not null Date valid to PK profiled
prllicenseeinterest Decimal not null Interest [%] profiled
prllicenseesdfi Decimal unspecified SDFI [%] profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prloperdatevalidfrom Date unspecified Date valid from profiled
prloperdatevalidto Date unspecified Date valid to profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

licence_oper_hst

  • Archetype: entity_store
  • Source anchor: table public.licence_oper_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prloperdateupdated Date unspecified Date updated profiled
prloperdatevalidfrom Date not null Date valid from PK profiled
prloperdatevalidto Date not null Date valid to PK profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

licence_petreg_licence

  • Archetype: entity_store
  • Source anchor: table public.licence_petreg_licence

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
ptldateawarded Date not null not assessed
ptldateupdated Date unspecified Dato hovednivå oppdatert profiled
ptldateupdatedmax Date not null Dato alle oppdatert profiled
ptldatevalidfrom Date not null Gyldig fra dato profiled
ptldatevalidto Date not null Gyldig til dato profiled
ptlname String not null Tillatelse profiled

Relationships

Name Target Type Description Evidence
licence licence belongs_to verified

licence_petreg_licence_licencee

  • Archetype: entity_store
  • Source anchor: table public.licence_petreg_licence_licencee

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
ptllicenseedateupdated Date unspecified Dato oppdatert profiled
ptllicenseeinterest Decimal not null Andel [%] profiled
ptlname String not null Tillatelse profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified
licence_petreg_licence licence_petreg_licence belongs_to CANDIDATE — unverified

licence_petreg_licence_oper

  • Archetype: entity_store
  • Source anchor: table public.licence_petreg_licence_oper

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
ptlname String not null Tillatelse profiled
ptloperdateupdated Date unspecified Dato oppdatert profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified
licence_petreg_licence licence_petreg_licence belongs_to CANDIDATE — unverified

licence_petreg_message

  • Archetype: entity_store
  • Source anchor: table public.licence_petreg_message

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
ptlmessage String not null Utdrag av dokument profiled
ptlmessagedateupdated Date unspecified Dato oppdatert profiled
ptlmessagedocumentno Integer not null PK not assessed
ptlmessagekinddesc String not null Type profiled
ptlmessageregistereddate Date not null Registreringsdato profiled

Relationships

Name Target Type Description Evidence
licence licence belongs_to verified

licence_phase_hst

  • Archetype: entity_store
  • Source anchor: table public.licence_phase_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
prlactivestatusindicator String not null Active profiled
prldategranted Date not null Date granted profiled
prldateinitialperiodexpires Date not null Expiry date, initial period profiled
prldatephasevalidfrom Date not null Date phase valid from PK profiled
prldatephasevalidto Date not null Date phase valid to PK profiled
prldatevalidto Date not null Date valid to profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prlphase String not null Phase PK profiled
prlphasedateupdated Date unspecified Date updated profiled

Relationships

Name Target Type Description Evidence
licence licence belongs_to verified

licence_task

  • Archetype: entity_store
  • Source anchor: table public.licence_task

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String unspecified Company name profiled
cmpnpdidcompany Integer unspecified NPDID company FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prldatevalidto Date not null Date valid to profiled
prllicensingactivityname String not null Licensing activity profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prltaskdateupdated Date unspecified Date updated profiled
prltaskexpirydate Date not null Expiry date profiled
prltaskid Integer not null Task ID PK; UNIQUE profiled
prltaskname String not null Task name (norwegian) profiled
prltaskrefid Integer unspecified Referred task ID FK → licence_task.prltaskid profiled
prltaskstatusen String not null Task status profiled
prltaskstatusno String not null not assessed
prltasktypeen String not null Type of task profiled
prltasktypeno String not null not assessed
wlbname String unspecified Wellbore name profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

licence_transfer_hst

  • Archetype: entity_store
  • Source anchor: table public.licence_transfer_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prltransferdateupdated Date unspecified Date updated profiled
prltransferdatevalidfrom Date not null Date valid from PK profiled
prltransferdirection String not null Transfer direction PK profiled
prltransferkind String unspecified Transfer kind profiled
prltransferredinterest Decimal not null Transferred interest [%] profiled
prltransfersdfi Decimal unspecified SDFI [%] profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

pipline

  • Archetype: entity_store
  • Source anchor: table public.pipline

Fields

Field Type Nullable Description Constraints Known values Evidence
pipcurrentphase String not null not assessed
pipdimension Decimal not null not assessed
piplinegeometrywkt String unspecified not assessed
pipmaingrouping String not null not assessed
pipmedium String not null not assessed
pipname String not null not assessed
pipnamecurrentoperator String unspecified not assessed
pipnamefromfacility String not null not assessed
pipnametofacility String not null not assessed
pipnpdidfromfacility Integer not null not assessed
pipnpdidoperator Integer unspecified FK → company.cmpnpdidcompany not assessed
pipnpdidpipe Integer not null PK not assessed
pipnpdidtofacility Integer not null not assessed

Relationships

Name Target Type Description Evidence
company company belongs_to verified

prlarea

  • Archetype: entity_store
  • Source anchor: table public.prlarea

Fields

Field Type Nullable Description Constraints Known values Evidence
prlactive String not null Active profiled
prlarea_id Integer not null PK not assessed
prlareageometrywkt String not null not assessed
prlareapolydatevalidfrom Date not null Date valid from PK profiled
prlareapolydatevalidto Date not null Date valid to PK profiled
prlareapolyfromzvalue Integer not null not assessed
prlareapolystratigraphical String not null Stratigraphcal profiled
prlareapolytozvalue Integer not null not assessed
prlareapolyvertlimen String unspecified not assessed
prlareapolyvertlimno String unspecified not assessed
prlcurrentarea String not null Current area profiled
prldategranted Date not null Date granted profiled
prldatevalidto Date not null Date valid to profiled
prlfacturl String not null not assessed
prllastoperatornamelong String not null not assessed
prllastoperatornameshort String not null not assessed
prllastoperatornpdidcompany Integer not null FK → company.cmpnpdidcompany not assessed
prllicensingactivityname String not null Licensing activity profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prlstratigraphical String not null not assessed

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

prlareasplitbyblock

  • Archetype: entity_store
  • Source anchor: table public.prlareasplitbyblock

Fields

Field Type Nullable Description Constraints Known values Evidence
blcname String not null Block name PK profiled
prlactive String not null Active profiled
prlareageometrywkt String not null not assessed
prlareapolydatevalidfrom Date not null Date valid from PK profiled
prlareapolydatevalidto Date not null Date valid to PK profiled
prlareapolyfromzvalue Integer not null not assessed
prlareapolypolyarea Decimal not null Polygon area [km2] profiled
prlareapolypolyno Integer not null PK not assessed
prlareapolystratigraphical String not null Stratigraphcal profiled
prlareapolytozvalue Integer not null not assessed
prlareapolyvertlimen String unspecified not assessed
prlareapolyvertlimno String unspecified not assessed
prlcurrentarea String not null Current area profiled
prldategranted Date not null Date granted profiled
prldatevalidto Date not null Date valid to profiled
prlfacturl String not null not assessed
prllastoperatornamelong String not null not assessed
prllastoperatornameshort String not null not assessed
prllastoperatornpdidcompany Integer not null FK → company.cmpnpdidcompany not assessed
prllicensingactivityname String not null Licensing activity profiled
prlname String not null Production licence profiled
prlnpdidlicence Integer not null NPDID production licence PK; FK → licence.prlnpdidlicence profiled
prlstratigraphical String not null not assessed

Relationships

Name Target Type Description Evidence
company company belongs_to verified
licence licence belongs_to verified

seaarea

  • Archetype: entity_store
  • Source anchor: table public.seaarea

Fields

Field Type Nullable Description Constraints Known values Evidence
sea3dkm2 Decimal unspecified Total net area - planned 3D/4D [km2] profiled
seaarea_id Integer not null PK not assessed
seaboattotalkm Integer unspecified Total length - actual [boat km] profiled
seacdptotalkm Integer unspecified Total length - actual [cdp km] profiled
seacompanyreported String not null Company - responsible profiled
seadatefinalized Date unspecified Completed date - actual profiled
seadatestarting Date unspecified Start date - actual profiled
seafactmapurl String unspecified Fact Map profiled
seafactpageurl String unspecified not assessed
seageographicalarea String not null not assessed
seamarketavailable String not null Marked available profiled
seanpdidsurvey Integer not null NPDID for survey FK → seis_acquisition.seanpdidsurvey profiled
seaplanboatkm Integer unspecified Total length - planned [boat km] profiled
seaplancdpkm Integer unspecified Total length - planned [cdp km] profiled
seaplanfromdate Date not null Start date - planned profiled
seaplantodate Date not null Completed date - planned profiled
seapolygeometrywkt String unspecified not assessed
seapolygonkind String not null Kind of polygon profiled
seasensorlength String unspecified Sensor length [m] profiled
seasensornumbers String unspecified Numbers of sensors profiled
seasensortype String unspecified Sensor type profiled
seasourcenumber String unspecified Number of sources profiled
seasourcepressure String unspecified Source pressure profiled
seasourcesize String unspecified Source size profiled
seasourcetype String unspecified Source type profiled
seastatus String not null Status profiled
seasurveyname String not null Survey name PK profiled
seasurveytypemain String not null Main type profiled
seasurveytypepart String unspecified Sub type profiled

Relationships

Name Target Type Description Evidence
seis_acquisition seis_acquisition belongs_to verified

seamultiline

  • Archetype: entity_store
  • Source anchor: table public.seamultiline

Fields

Field Type Nullable Description Constraints Known values Evidence
seaboattotalkm Integer unspecified Total length - actual [boat km] profiled
seacdptotalkm Integer unspecified Total length - actual [cdp km] profiled
seacompanyreported String not null Company - responsible profiled
seadatefinalized Date unspecified Completed date - actual profiled
seadatestarting Date unspecified Start date - actual profiled
seafactmapurl String unspecified Fact Map profiled
seafactpageurl String unspecified not assessed
seamarketavailable String not null Marked available profiled
seamultilinegeometrywkt String not null not assessed
seaplanboatkm Integer not null Total length - planned [boat km] profiled
seaplancdpkm Integer not null Total length - planned [cdp km] profiled
seaplanfromdate Date not null Start date - planned profiled
seaplantodate Date not null Completed date - planned profiled
seasensorlength String not null Sensor length [m] profiled
seasensornumbers String not null Numbers of sensors profiled
seasensortype String not null Sensor type profiled
seasourcenumber String unspecified Number of sources profiled
seasourcepressure String unspecified Source pressure profiled
seasourcesize String unspecified Source size profiled
seasourcetype String not null Source type profiled
seastatus String not null Status profiled
seasurveyname String not null Survey name PK; FK → seis_acquisition.seaname profiled
seasurveytypemain String not null Main type profiled
seasurveytypepart String not null Sub type profiled

Relationships

Name Target Type Description Evidence
seis_acquisition seis_acquisition belongs_to verified

seis_acquisition

  • Archetype: entity_store
  • Source anchor: table public.seis_acquisition

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
sea3dkm2 Decimal unspecified Total net area - planned 3D/4D [km2] profiled
seaboattotalkm Integer unspecified Total length - actual [boat km] profiled
seacdptotalkm Integer unspecified Total length - actual [cdp km] profiled
seacompanyreported String not null Company - responsible FK → company.cmplongname profiled
seadatefinalized Date unspecified Completed date - actual profiled
seadatestarting Date unspecified Start date - actual profiled
seageographicalarea String not null not assessed
seageotechnical String unspecified Geotechnical measurement profiled
seaname String not null Survey name PK; UNIQUE profiled
seanpdidsurvey Integer not null NPDID for survey PK; UNIQUE profiled
seaplanfromdate Date not null Start date - planned profiled
seaplantodate Date not null Completed date - planned profiled
seasampling String unspecified Sampling profiled
seashallowdrilling String unspecified Shallow drilling profiled
seastatus String not null Status profiled
seasurveytypemain String not null Main type profiled
seasurveytypepart String unspecified Sub type profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified

seis_acquisition_coordinates_inc_turnarea

  • Archetype: entity_store
  • Source anchor: table public.seis_acquisition_coordinates_inc_turnarea

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
seanpdidsurvey Integer not null NPDID for survey FK → seis_acquisition.seanpdidsurvey profiled
seapolygonewdeg Integer not null EW degrees profiled
seapolygonewmin Integer not null EW minutes profiled
seapolygonewsec Decimal not null EW seconds profiled
seapolygonnsdeg Integer not null NS degrees profiled
seapolygonnsmin Integer not null NS minutes profiled
seapolygonnssec Decimal not null NS seconds profiled
seapolygonpointnumber Integer not null Point number PK profiled
seasurveyname String not null Survey name PK profiled

Relationships

Name Target Type Description Evidence
seis_acquisition seis_acquisition belongs_to verified

seis_acquisition_progress

  • Archetype: entity_store
  • Source anchor: table public.seis_acquisition_progress

Fields

Field Type Nullable Description Constraints Known values Evidence
seanpdidsurvey Integer not null NPDID for survey FK → seis_acquisition.seanpdidsurvey profiled
seaprogressdate Date not null not assessed
seaprogressdescription String unspecified not assessed
seaprogresstext String not null not assessed
seaprogresstext2 String not null PK not assessed
seis_acquisition_progress_id Integer not null PK not assessed

Relationships

Name Target Type Description Evidence
seis_acquisition seis_acquisition belongs_to verified

strat_litho_wellbore

  • Archetype: entity_store
  • Source anchor: table public.strat_litho_wellbore

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
lsubottomdepth Decimal not null Bottom depth [m] PK profiled
lsulevel String not null Level profiled
lsuname String not null Lithostrat. unit profiled
lsunpdidlithostrat Integer not null NPDID lithostrat. unit PK profiled
lsutopdepth Decimal not null Top depth [m] PK profiled
lsuwellboreupdateddate Date unspecified Date updated profiled
wlbcompletiondate Date not null Completion date profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

strat_litho_wellbore_core

  • Archetype: entity_store
  • Source anchor: table public.strat_litho_wellbore_core

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
lsucorelenght Decimal not null Core length [m] profiled
lsulevel String not null Level profiled
lsuname String not null Lithostrat. unit profiled
lsunpdidlithostrat Integer not null NPDID lithostrat. unit PK profiled
wlbcompletiondate Date not null Completion date profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
strat_litho_wellbore strat_litho_wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

tuf

  • Archetype: entity_store
  • Source anchor: table public.tuf

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled

Relationships

Name Target Type Description Evidence
tuf_petreg_licence tuf_petreg_licence belongs_to verified

tuf_operator_hst

  • Archetype: entity_store
  • Source anchor: table public.tuf_operator_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled
tufoperdatevalidfrom Date not null Date valid from PK profiled
tufoperdatevalidto Date not null Date valid to PK profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
tuf tuf belongs_to CANDIDATE — unverified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

tuf_owner_hst

  • Archetype: entity_store
  • Source anchor: table public.tuf_owner_hst

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled
tufownerdatevalidfrom Date not null Date valid from PK profiled
tufownerdatevalidto Date not null Date valid to PK profiled
tufownershare Decimal not null Share [%] profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
tuf tuf belongs_to CANDIDATE — unverified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

tuf_petreg_licence

  • Archetype: entity_store
  • Source anchor: table public.tuf_petreg_licence

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
ptldateupdated Date unspecified Dato hovednivå oppdatert profiled
ptldateupdatedmax Date not null Dato alle oppdatert profiled
ptldatevalidfrom Date not null Gyldig fra dato profiled
ptldatevalidto Date not null Gyldig til dato profiled
ptlname String not null Tillatelse profiled
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; UNIQUE profiled

tuf_petreg_licence_licencee

  • Archetype: entity_store
  • Source anchor: table public.tuf_petreg_licence_licencee

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company PK; FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
ptllicenseedateupdated Date unspecified Dato oppdatert profiled
ptllicenseeinterest Decimal not null Andel [%] profiled
ptlname String not null Tillatelse profiled
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

tuf_petreg_licence_oper

  • Archetype: entity_store
  • Source anchor: table public.tuf_petreg_licence_oper

Fields

Field Type Nullable Description Constraints Known values Evidence
cmplongname String not null Company name profiled
cmpnpdidcompany Integer not null NPDID company FK → company.cmpnpdidcompany profiled
datesyncnpd Date not null not assessed
ptlname String not null Tillatelse profiled
ptloperdateupdated Date unspecified Dato oppdatert profiled
textbox2 String not null not assessed
textbox42 String not null not assessed
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

tuf_petreg_message

  • Archetype: entity_store
  • Source anchor: table public.tuf_petreg_message

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
ptlmessage String not null Utdrag av dokument profiled
ptlmessagedateupdated Date unspecified Dato oppdatert profiled
ptlmessagedocumentno Integer not null PK not assessed
ptlmessagekinddesc String not null Type profiled
ptlmessageregistereddate Date not null Registreringsdato profiled
ptlname String not null Tillatelse profiled
tufname String not null TUF profiled
tufnpdidtuf Integer not null NPDID tuf PK; FK → tuf_petreg_licence.tufnpdidtuf profiled

Relationships

Name Target Type Description Evidence
tuf tuf belongs_to CANDIDATE — unverified
tuf_petreg_licence tuf_petreg_licence belongs_to verified

wellbore

  • Archetype: entity_store
  • Source anchor: table public.wellbore

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_casing_and_lot

  • Archetype: entity_store
  • Source anchor: table public.wellbore_casing_and_lot

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wellbore_casing_and_lot_id Integer not null PK not assessed
wlbcasingdateupdated Date unspecified Date updated profiled
wlbcasingdepth Decimal not null Casing depth [m] profiled
wlbcasingdiameter String unspecified Casing diam. [inch] profiled
wlbcasingtype String unspecified Casing type profiled
wlbholedepth Decimal not null Hole depth[m] profiled
wlbholediameter String unspecified Hole diam. [inch] profiled
wlblotmuddencity Decimal not null LOT mud eqv. [g/cm3] profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_coordinate

  • Archetype: entity_store
  • Source anchor: table public.wellbore_coordinates

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wlbcompletiondate Date unspecified Completion date profiled
wlbcontent String unspecified Content profiled
wlbdrillingoperator String not null Drilling operator profiled
wlbentrydate Date unspecified Entry date profiled
wlbewcode String unspecified EW code profiled
wlbewdeg Integer not null EW degrees profiled
wlbewdesdeg Decimal not null EW decimal degrees profiled
wlbewmin Integer not null EW minutes profiled
wlbewsec Decimal not null EW seconds profiled
wlbewutm Decimal not null EW UTM [m] profiled
wlbfield String unspecified Field profiled
wlbgeodeticdatum String unspecified Geodetic datum profiled
wlbmainarea String not null Main area profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnscode String unspecified NS code profiled
wlbnsdecdeg Decimal not null NS decimal degrees profiled
wlbnsdeg Integer not null NS degrees profiled
wlbnsmin Integer not null NS minutes profiled
wlbnssec Decimal not null NS seconds profiled
wlbnsutm Decimal not null NS UTM [m] profiled
wlbproductionlicence String unspecified Drilled in production licence profiled
wlbpurposeplanned String unspecified Purpose - planned profiled
wlbutmzone Integer not null UTM zone profiled
wlbwellborename String not null Wellbore name profiled
wlbwelltype String unspecified Type profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_core

  • Archetype: entity_store
  • Source anchor: table public.wellbore_core

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wellbore_core_id Integer not null PK not assessed
wlbcoredateupdated Date unspecified Date updated profiled
wlbcoreintervalbottom Decimal unspecified Core sample - bottom depth profiled
wlbcoreintervaltop Decimal unspecified Core sample - top depth profiled
wlbcoreintervaluom String unspecified Core sample depth - uom profiled
wlbcorenumber Integer not null Core sample number PK profiled
wlbcoresampleavailable String not null Core samples available profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnumberofcores Integer not null Number of cores samples profiled
wlbtotalcorelength Decimal not null Total core sample length [m] profiled

Relationships

Name Target Type Description Evidence
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_core_photo

  • Archetype: entity_store
  • Source anchor: table public.wellbore_core_photo

Fields

Field Type Nullable Description Constraints Known values Evidence
wellbore_core_photo_id Integer not null PK not assessed
wlbcorenumber Integer not null Core sample number PK profiled
wlbcorephotodateupdated Date unspecified Date updated profiled
wlbcorephotoimgurl String not null Core photo URL profiled
wlbcorephototitle String not null Core photo title PK profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore_core wellbore_core belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_development_all

  • Archetype: entity_store
  • Source anchor: table public.wellbore_development_all

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
dscnpdiddiscovery Integer not null NPDID discovery FK → discovery.dscnpdiddiscovery profiled
fclnpdidfacilitydrilling Integer unspecified NPDID drilling facility profiled
fclnpdidfacilityproducing Integer unspecified NPDID production facility profiled
fldnpdidfield Integer not null NPDID field FK → field.fldnpdidfield profiled
prlnpdidproductionlicence Integer not null NPDID production licence drilled in FK → licence.prlnpdidlicence profiled
wlbcompletiondate Date unspecified Completion date profiled
wlbcompletionyear Integer not null Completion year profiled
wlbcontent String unspecified Content profiled
wlbcontentplanned String unspecified Content - planned profiled
wlbdateupdated Date not null Date main level updated profiled
wlbdateupdatedmax Date not null Date all updated profiled
wlbdiscovery String not null Discovery profiled
wlbdiscoverywellbore String not null Discovery wellbore profiled
wlbdiskoswellboreparent String unspecified DISKOS Wellbore Parent profiled
wlbdiskoswellboretype String not null DISKOS Well Type profiled
wlbdiskoswelloperator String not null DISKOS well operator FK → company.cmpshortname profiled
wlbdrillingfacility String unspecified Drilling facility profiled
wlbdrillingoperator String not null Drilling operator FK → company.cmplongname profiled
wlbdrillingoperatorgroup String not null Drilling operator group profiled
wlbdrillpermit String not null Drill permit profiled
wlbentrydate Date unspecified Entry date profiled
wlbentryyear Integer not null Entry year profiled
wlbewcode String unspecified EW code profiled
wlbewdeg Integer not null EW degrees profiled
wlbewdesdeg Decimal not null EW decimal degrees profiled
wlbewmin Integer not null EW minutes profiled
wlbewsec Decimal not null EW seconds profiled
wlbewutm Decimal not null EW UTM [m] profiled
wlbfacilitytypedrilling String unspecified Facility type, drilling profiled
wlbfactmapurl String not null FactMap url profiled
wlbfactpageurl String not null FactPage url profiled
wlbfield String not null Field profiled
wlbfinalverticaldepth Decimal unspecified Final vertical depth (TVD) [m RKB] profiled
wlbgeodeticdatum String unspecified Geodetic datum profiled
wlbkellybushelevation Decimal not null Kelly bushing elevation [m] profiled
wlblicensingactivity String not null Licensing activity awarded in profiled
wlbmainarea String not null Main area profiled
wlbmultilateral String not null Multilateral profiled
wlbnamepart1 Integer not null Wellbore name, part 1 profiled
wlbnamepart2 Integer not null Wellbore name, part 2 profiled
wlbnamepart3 String not null Wellbore name, part 3 profiled
wlbnamepart4 Integer not null Wellbore name, part 4 profiled
wlbnamepart5 String unspecified Wellbore name, part 5 profiled
wlbnamepart6 String unspecified Wellbore name, part 6 profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnpdidwellborereclass Integer not null NPDID wellbore reclassified from FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnscode String not null NS code profiled
wlbnsdecdeg Decimal not null NS decimal degrees profiled
wlbnsdeg Integer not null NS degrees profiled
wlbnsmin Integer not null NS minutes profiled
wlbnssec Decimal not null NS seconds profiled
wlbnsutm Decimal not null NS UTM [m] profiled
wlbplotsymbol Integer not null Plot symbol profiled
wlbproductionfacility String unspecified Production facility profiled
wlbproductionlicence String not null Drilled in production licence profiled
wlbpurposeplanned String unspecified Purpose - planned profiled
wlbreclassfromwellbore String unspecified Reclassified from wellbore profiled
wlbtotaldepth Decimal not null Total depth (MD) [m RKB] profiled
wlbutmzone Integer not null UTM zone profiled
wlbwaterdepth Decimal not null Water depth [m] profiled
wlbwdssqcdate Date unspecified not assessed
wlbwell String not null Well name profiled
wlbwellborename String not null Wellbore name profiled
wlbwelltype String not null Type profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
discovery discovery belongs_to verified
field field belongs_to verified
licence licence belongs_to verified
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_document

  • Archetype: entity_store
  • Source anchor: table public.wellbore_document

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wellbore_document_id Integer not null PK not assessed
wlbdocumentdateupdated Date unspecified Date updated profiled
wlbdocumentformat String not null Document format profiled
wlbdocumentname String not null Document name PK profiled
wlbdocumentsize Decimal not null Document size [MB] profiled
wlbdocumenttype String not null Document type profiled
wlbdocumenturl String not null Document URL profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_dst

  • Archetype: entity_store
  • Source anchor: table public.wellbore_dst

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wlbdstbottomholepress Decimal not null Bottom hole pressure [MPa] profiled
wlbdstchokesize Decimal not null Choke size [mm] profiled
wlbdstdateupdated Date unspecified Date updated profiled
wlbdstfinflowpress Decimal not null Final flow pressure [MPa] profiled
wlbdstfinshutinpress Decimal not null Final shut-in pressure [MPa] profiled
wlbdstfromdepth Decimal not null From depth MD [m] profiled
wlbdstgasdensity Decimal not null Gas grav. rel.air profiled
wlbdstgasoilrelation Integer not null GOR [m3/m3] profiled
wlbdstgasprod Integer not null Gas [Sm3/day] profiled
wlbdstoildensity Decimal not null Oil density [g/cm3] profiled
wlbdstoilprod Integer not null Oil [Sm3/day] profiled
wlbdsttestnumber Decimal not null Test number PK profiled
wlbdsttodepth Decimal not null To depth MD [m] profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_exploration_all

  • Archetype: entity_store
  • Source anchor: table public.wellbore_exploration_all

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
dscnpdiddiscovery Integer unspecified NPDID discovery FK → discovery.dscnpdiddiscovery profiled
fclnpdidfacilitydrilling Integer not null NPDID drilling facility profiled
fldnpdidfield Integer unspecified NPDID field FK → field.fldnpdidfield profiled
prlnpdidproductionlicence Integer not null NPDID production licence drilled in FK → licence.prlnpdidlicence profiled
wlbageattd String unspecified Oldest penetrated age profiled
wlbagewithhc1 String unspecified 1st level with HC, age profiled
wlbagewithhc2 String unspecified 2nd level with HC, age profiled
wlbagewithhc3 String unspecified 3rd level with HC, age profiled
wlbbottomholetemperature Integer unspecified Bottom hole temperature [°C] profiled
wlbcompletiondate Date unspecified Completion date profiled
wlbcompletionyear Integer not null Completion year profiled
wlbcontent String unspecified Content profiled
wlbdateupdated Date not null Date main level updated profiled
wlbdateupdatedmax Date not null Date all updated profiled
wlbdiscovery String unspecified Discovery profiled
wlbdiscoverywellbore String not null Discovery wellbore profiled
wlbdiskoswellboreparent String unspecified DISKOS Wellbore Parent profiled
wlbdiskoswellboretype String not null DISKOS Well Type profiled
wlbdiskoswelloperator String not null DISKOS well operator profiled
wlbdrillingdays Integer not null Drilling days profiled
wlbdrillingfacility String not null Drilling facility profiled
wlbdrillingoperator String not null Drilling operator FK → company.cmplongname profiled
wlbdrillingoperatorgroup String not null Drilling operator group profiled
wlbdrillpermit String not null Drill permit profiled
wlbentrydate Date unspecified Entry date profiled
wlbentryyear Integer not null Entry year profiled
wlbewcode String not null EW code profiled
wlbewdeg Integer not null EW degrees profiled
wlbewdesdeg Decimal not null EW decimal degrees profiled
wlbewmin Integer not null EW minutes profiled
wlbewsec Decimal not null EW seconds profiled
wlbewutm Decimal not null EW UTM [m] profiled
wlbfacilitytypedrilling String not null Facility type, drilling profiled
wlbfactmapurl String not null FactMap url profiled
wlbfactpageurl String not null FactPage url profiled
wlbfield String unspecified Field profiled
wlbfinalverticaldepth Decimal unspecified Final vertical depth (TVD) [m RKB] profiled
wlbformationattd String unspecified Oldest penetrated formation profiled
wlbformationwithhc1 String unspecified 1st level with HC, formation profiled
wlbformationwithhc2 String unspecified 2nd level with HC, formation profiled
wlbformationwithhc3 String unspecified 3rd level with HC, formation profiled
wlbgeodeticdatum String unspecified Geodetic datum profiled
wlbkellybushelevation Decimal not null Kelly bushing elevation [m] profiled
wlblicensingactivity String not null Licensing activity awarded in profiled
wlbmainarea String not null Main area profiled
wlbmaxinclation Decimal unspecified Maximum inclination [°] profiled
wlbmultilateral String not null Multilateral profiled
wlbnamepart1 Integer not null Wellbore name, part 1 profiled
wlbnamepart2 Integer not null Wellbore name, part 2 profiled
wlbnamepart3 String unspecified Wellbore name, part 3 profiled
wlbnamepart4 Integer not null Wellbore name, part 4 profiled
wlbnamepart5 String unspecified Wellbore name, part 5 profiled
wlbnamepart6 String unspecified Wellbore name, part 6 profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnpdidwellborereclass Integer not null NPDID wellbore reclassified from FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnscode String not null NS code profiled
wlbnsdecdeg Decimal not null NS decimal degrees profiled
wlbnsdeg Integer not null NS degrees profiled
wlbnsmin Integer not null NS minutes profiled
wlbnssec Decimal not null NS seconds profiled
wlbnsutm Decimal not null NS UTM [m] profiled
wlbplotsymbol Integer not null Plot symbol profiled
wlbpressreleaseurl String unspecified not assessed
wlbproductionlicence String not null Drilled in production licence profiled
wlbpurpose String not null Purpose profiled
wlbpurposeplanned String not null Purpose - planned profiled
wlbreclassfromwellbore String unspecified Reclassified from wellbore profiled
wlbreentry String not null Reentry profiled
wlbreentryexplorationactivity String unspecified Reentry activity profiled
wlbseismiclocation String unspecified Seismic location profiled
wlbstatus String unspecified Status profiled
wlbtotaldepth Decimal not null Total depth (MD) [m RKB] profiled
wlbutmzone Integer not null UTM zone profiled
wlbwaterdepth Decimal not null Water depth [m] profiled
wlbwdssqcdate Date unspecified WDSS QC date profiled
wlbwell String not null Well name profiled
wlbwellborename String not null Wellbore name profiled
wlbwelltype String not null Type profiled

Relationships

Name Target Type Description Evidence
company company belongs_to verified
discovery discovery belongs_to verified
field field belongs_to verified
licence licence belongs_to verified
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_formation_top

  • Archetype: entity_store
  • Source anchor: table public.wellbore_formation_top

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
lsubottomdepth Decimal not null Bottom depth [m] PK profiled
lsulevel String not null Level profiled
lsuname String not null Lithostrat. unit profiled
lsunameparent String unspecified Lithostrat. unit, parent profiled
lsunpdidlithostrat Integer not null NPDID lithostrat. unit PK profiled
lsunpdidlithostratparent Integer unspecified NPDID parent lithostrat. unit profiled
lsutopdepth Decimal not null Top depth [m] PK profiled
lsuwellboreupdateddate Date unspecified Date updated profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_mud

  • Archetype: entity_store
  • Source anchor: table public.wellbore_mud

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wellbore_mud_id Integer not null PK not assessed
wlbmd Decimal not null Depth MD [m] profiled
wlbmuddatemeasured Date unspecified Date measured profiled
wlbmuddateupdated Date unspecified Date updated profiled
wlbmudtype String unspecified Mud type profiled
wlbmudviscosityatmd Decimal not null Visc. [mPa.s] profiled
wlbmudweightatmd Decimal not null Mud weight [g/cm3] profiled
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbyieldpointatmd Decimal not null Yield point [Pa] profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_npdid_overview

  • Archetype: entity_store
  • Source anchor: table public.wellbore_npdid_overview

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wlbnpdidwellbore Integer not null NPDID wellbore PK; UNIQUE profiled
wlbwell String not null Well name profiled
wlbwellborename String not null Wellbore name profiled
wlbwelltype String unspecified Type profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified

wellbore_oil_sample

  • Archetype: entity_store
  • Source anchor: table public.wellbore_oil_sample

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wellbore_oil_sample_id Integer not null PK not assessed
wlbname String not null Wellbore name profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlboilsamplebottomdepth Decimal not null Bottom depth MD [m] profiled
wlboilsampledatereceiveddate Date unspecified Received date profiled
wlboilsampledateupdated Date unspecified Date updated profiled
wlboilsamplefluidtype String unspecified Fluid type profiled
wlboilsampletestdate Date unspecified Test date and time of day profiled
wlboilsampletestnumber String unspecified Bottle test number profiled
wlboilsampletesttype String unspecified Test type profiled
wlboilsampletopdepth Decimal not null Top depth MD [m] profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wellbore_shallow_all

  • Archetype: entity_store
  • Source anchor: table public.wellbore_shallow_all

Fields

Field Type Nullable Description Constraints Known values Evidence
datesyncnpd Date not null not assessed
wlbcompletiondate Date unspecified Completion date profiled
wlbcompletionyear Integer not null Completion year profiled
wlbdateupdated Date not null Date main level updated profiled
wlbdateupdatedmax Date not null Date all updated profiled
wlbdrillingfacility String unspecified Drilling facility profiled
wlbdrillingoperator String not null Drilling operator profiled
wlbdrillpermit String not null Drill permit profiled
wlbentrydate Date unspecified Entry date profiled
wlbentryyear Integer not null Entry year profiled
wlbewcode String unspecified EW code profiled
wlbewdeg Integer not null EW degrees profiled
wlbewdesdeg Decimal not null EW decimal degrees profiled
wlbewmin Integer not null EW minutes profiled
wlbewsec Decimal not null EW seconds profiled
wlbewutm Decimal not null EW UTM [m] profiled
wlbgeodeticdatum String unspecified Geodetic datum profiled
wlbmainarea String not null Main area profiled
wlbnamepart1 Integer not null Wellbore name, part 1 profiled
wlbnamepart2 Integer not null Wellbore name, part 2 profiled
wlbnamepart3 String not null Wellbore name, part 3 profiled
wlbnamepart4 Integer not null Wellbore name, part 4 profiled
wlbnamepart5 String unspecified Wellbore name, part 5 profiled
wlbnamepart6 String unspecified Wellbore name, part 6 profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbnscode String unspecified NS code profiled
wlbnsdecdeg Decimal not null NS decimal degrees profiled
wlbnsdeg Integer not null NS degrees profiled
wlbnsmin Integer not null NS minutes profiled
wlbnssec Decimal not null NS seconds profiled
wlbnsutm Decimal not null NS UTM [m] profiled
wlbproductionlicence String unspecified Drilled in production licence profiled
wlbseismiclocation String unspecified Seismic location profiled
wlbtotaldepth Decimal not null Total depth (MD) [m RKB] profiled
wlbutmzone Integer not null UTM zone profiled
wlbwaterdepth Decimal not null Water depth [m] profiled
wlbwell String not null Well name profiled
wlbwellborename String not null Wellbore name profiled

Relationships

Name Target Type Description Evidence
wellbore wellbore belongs_to CANDIDATE — unverified
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified

wlbpoint

  • Archetype: entity_store
  • Source anchor: table public.wlbpoint

Fields

Field Type Nullable Description Constraints Known values Evidence
wlbcompletiondate Date unspecified Completion date profiled
wlbcontent String unspecified Content profiled
wlbdiscoverywellbore String not null Discovery wellbore profiled
wlbdrillingfacility String unspecified Drilling facility profiled
wlbdrillingoperator String not null Drilling operator profiled
wlbentrydate Date unspecified Entry date profiled
wlbfactmapurl String unspecified FactMap url profiled
wlbfactpageurl String unspecified FactPage url profiled
wlbfield String unspecified Field profiled
wlbmultilateral String not null Multilateral profiled
wlbnpdidwellbore Integer not null NPDID wellbore PK; FK → wellbore_npdid_overview.wlbnpdidwellbore profiled
wlbpointgeometrywkt String not null not assessed
wlbproductionfacility String unspecified Production facility profiled
wlbproductionlicence String unspecified Drilled in production licence profiled
wlbpurpose String unspecified Purpose profiled
wlbstatus String unspecified Status profiled
wlbsymbol Integer not null not assessed
wlbwaterdepth Decimal not null Water depth [m] profiled
wlbwellborename String not null Wellbore name profiled
wlbwellname String not null not assessed
wlbwelltype String unspecified Type profiled

Relationships

Name Target Type Description Evidence
wellbore_npdid_overview wellbore_npdid_overview belongs_to verified