MRTFile

108874 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
Collar.MRTFileId FK_Collar_MRTFile R
DHAlteration.MRTFileId FK_DHAlteration_MRTFile R
DHDrillDetail.MRTFileId FK_DHDrillDetail_MRTFile R
DHEvent.MRTFileId FK_DHEvent_MRTFile R
DHGeochemistry.MRTFileId FK_DHGeochemistry_MRTFile R
DHGeology.MRTFileId FK_DHGeology_MRTFile R
DHGeophysics.MRTFileId FK_DHGeophysics_MRTFile R
DHGeotech.MRTFileId FK_DHGeotech_MRTFile R
DHHyperspectral.MRTFileId FK_DHHyperspectral_MRTFile R
DHMagSus.MRTFileId FK_DHMagSus_MRTFile R
DHMineralogy.MRTFileId FK_DHMineralogy_MRTFile R
DHPXrfReadings.MRTFileId FK_DHPXrfReadings_MRTFile R
DHRecovery.MRTFileId FK_DHRecovery_MRTFile R
DHRegolith.MRTFileId FK_DHRegolith_MRTFile R
DHSpecGrav.MRTFileId FK_DHSpecGrav_MRTFile R
DHStructure.MRTFileId FK_DHStructure_MRTFile R
DHSurvey.MRTFileId FK_DHSurvey_MRTFile R
DHVeining.MRTFileId FK_DHVeining_MRTFile R
DHWater.MRTFileId FK_DHWater_MRTFile R
DHWeathering.MRTFileId FK_DHWeathering_MRTFile R
MRTDetail.MRTFileId FK_MRTDetail_MRTFile R
MRTHeader.MRTFileId FK_MRTHeader_MRTFile R
SurfaceSample.MRTFileId FK_SurfaceSample_MRTFile R
SurfaceSampleObservationType.MRTFileId FK_SurfaceSampleObservationType_MRTFile R
Anumber int 4 null
CompanyId int 4 null
CLBODY.CompanyId Implied Constraint R
Filename nvarchar 510 null
FileType nvarchar 100 null
IsPublic bit 1 null
SubmissionDate datetime 16,3 √ null
LoadDate datetime 16,3 null
LoadBy int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation