SurfaceSample

9972404 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
SurfaceSampleAttr.SurfaceSampleId Implied Constraint R
SurfaceSampleCoordinate.SurfaceSampleId FK_SurfaceSampleCoordinate_SurfaceSample R
SampleId nvarchar 1000 null
Anumber int 4 null
CompanySampleId nvarchar 400 null
Dataset nvarchar 400 √ null
CompanyId int 4 null
CLBODY.CompanyId FK_SurfaceSample_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_SurfaceSample_MRTFile R
SurfaceSampleType varchar 20 null
LookupSurfaceSampleType.Code FK_SurfaceSample_LookupSurfaceSampleType R

Indexes

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

Relationships

Close relationships within degrees of separation