Sections


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId Sections_Projects_ForeignKey C
SectionId uniqueidentifier 16 null
qrySectionPoints.SectionId Implied Constraint R
qrySections.SectionId Implied Constraint R
SectionPoints.SectionId SectionPoints_Sections_ForeignKey C
SectionStrings.SectionId SectionStrings_Sections_ForeignKey C
Section nvarchar 100 null
sSectionId uniqueidentifier 16 null
Description1 nvarchar 510 null
Description2 nvarchar 510 null
Description3 nvarchar 510 null
Station1 float 8 null
Station2 float 8 null
Level1 real 4 null
Level2 real 4 null
SearchMode int 4 null
AlignmentId uniqueidentifier 16 null
Alignments.AlignmentId Sections_Alignments_ForeignKey R
Distance real 4 null
SubSectionType int 4 null
Distance2 real 4 null
Overlap real 4 null
Station float 8 null
Primary bit 1 null
Projection int 4 null
x1 float 8 null
y1 float 8 null
x2 float 8 null
y2 float 8 null
ProjectPointsOnly bit 1 null
Overwrite bit 1 null
DBId2 uniqueidentifier 16 null
DrawingId uniqueidentifier 16 null
MultiPageView bit 1 null
HorzScale real 4 null
HorzMajorGridInterval real 4 null
HorzMinorGridInterval real 4 null
VertScale real 4 null
VertMajorGridInterval real 4 null
VertMinorGridInterval real 4 null
Report nvarchar 100 null
Enclosure nvarchar 100 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null
FRef int 4 null
FRefSCom nvarchar 100 null
FRefSJob nvarchar 510 null

Table contained 5 rows

Indexes

Constraint Name Type Sort Column(s)
Sections_PrimaryKey Primary key Asc SectionId
Sections_AlignmentId_Index Performance Asc AlignmentId
Sections_FRef_Index Performance Asc FRef
Sections_FRefSCom_Index Performance Asc FRefSCom
Sections_FRefSJob_Index Performance Asc FRefSJob
Sections_ProjectId_Index Performance Asc ProjectId
Sections_Projection_Index Performance Asc Projection
Sections_SectionId_Index Performance Asc SectionId

Relationships