SyntaxDesignations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ElementId uniqueidentifier 16 null
SyntaxElements.ElementId SyntaxDesignations_SyntaxElements_ForeignKey C
LithologyId uniqueidentifier 16 null
qrySyntaxDesignations.LithologyId Implied Constraint R
SyntaxSynonyms.LithologyId SyntaxSynonyms_SyntaxDesignations_ForeignKey C
Designation nvarchar 240 null
Description nvarchar 240 null
Sequence int 4 null
Version.Sequence Implied Constraint R
Group int 4 null
Dominant bit 1 null
Yielding bit 1 null
Interpolate bit 1 null
Format nvarchar 4 null
Font nvarchar 2 null
SymbolNo int 4 null
Image nvarchar 2147483647 null
Level int 4 null
JupiterId nvarchar 100 null
Active bit 1 null
FRef int 4 null

Table contained 507 rows

Indexes

Constraint Name Type Sort Column(s)
SyntaxDesignations_PrimaryKey Primary key Asc LithologyId
SyntaxDesignations_ElementId_Index Performance Asc ElementId
SyntaxDesignations_FRef_Index Performance Asc FRef
SyntaxDesignations_LithologyId_Index Performance Asc LithologyId

Relationships