Alignments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId Alignments_Projects_ForeignKey C
AlignmentId uniqueidentifier 16 null
AlignmentVertices.AlignmentId AlignmentVertices_Alignments_ForeignKey C
Points.AlignmentId Implied Constraint R
qryAlignments.AlignmentId Implied Constraint R
qryAlignmentVertices.AlignmentId Implied Constraint R
qryPoints.AlignmentId Implied Constraint R
qrySections.AlignmentId Implied Constraint R
Sections.AlignmentId Sections_Alignments_ForeignKey R
Alignment nvarchar 100 null
sAlignmentId uniqueidentifier 16 null
Description nvarchar 510 null
AlignmentType nvarchar 100 null
Projection int 4 null
Station1 float 8 null
Station2 float 8 null
LinkId int identity 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null
FRef nvarchar 510 null
FRefProject nvarchar 100 null
FRefAlign nvarchar 510 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
Alignments_PrimaryKey Primary key Asc AlignmentId
Alignments_AlignmentId_Index Performance Asc AlignmentId
Alignments_AlignmentId_UniqueKey Must be unique Asc AlignmentId
Alignments_FRef_Index Performance Asc FRef
Alignments_FRefAlign_Index Performance Asc FRefAlign
Alignments_FRefProject_Index Performance Asc FRefProject
Alignments_ProjectId_Index Performance Asc ProjectId

Relationships