Collar

2902489 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
CollarAttr.CollarId Implied Constraint R
CollarCoordinate.CollarId FK_CollarCoordinate_Collar R
CollarElevation.CollarID FK_CollarElevation_Collar R
DHAlteration.CollarId FK_DHAlteration_Collar R
DHDrillDetail.CollarId FK_DHDrillDetail_Collar R
DHEvent.CollarId FK_DHEvent_Collar R
DHGeochemistry.CollarId FK_DHGeochemistry_Collar R
DHGeology.CollarId FK_DHGeology_Collar R
DHGeophysics.CollarId FK_DHGeophysics_Collar R
DHGeotech.CollarId FK_DHGeotech_Collar R
DHHyperspectral.CollarId FK_DHHyperspectral_Collar R
DHMagSus.CollarId FK_DHMagSus_Collar R
DHMineralogy.CollarId FK_DHMineralogy_Collar R
DHPXrfReadings.CollarId FK_DHPXrfReadings_Collar R
DHRecovery.CollarId FK_DHRecovery_Collar R
DHRegolith.CollarId FK_DHRegolith_Collar R
DHSpecGrav.CollarId FK_DHSpecGrav_Collar R
DHStructure.CollarId FK_DHStructure_Collar R
DHSurvey.CollarId FK_DHSurvey_Collar R
DHVeining.CollarId FK_DHVeining_Collar R
DHWater.CollarId FK_DHWater_Collar R
DHWeathering.CollarId FK_DHWeathering_Collar R
HoleId nvarchar 1000 null
Anumber int 4 null
CompanyHoleId nvarchar 400 null
Dataset nvarchar 400 √ null
CompanyId int 4 null
CLBODY.CompanyId FK_Collar_CLBODY R
Longitude float 8 √ null
Latitude float 8 √ null
IsTransformed bit 1 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy nvarchar 200 √ null
MRTFileId int 4 null
MRTFile.Id FK_Collar_MRTFile R
HoleType varchar 20 null
LookupHoleType.Code FK_Collar_LookupHoleType R
MaxDepth real 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_Collar_ID Primary key Asc Id

Relationships

Close relationships within degrees of separation