CodeValues


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CodeId uniqueidentifier 16 null
Codes.CodeId CodeValues_Codes_ForeignKey C
ValueId uniqueidentifier 16 null
Setup nvarchar 40 null
Setups.Setup Implied Constraint R
Sequence int 4 null
Version.Sequence Implied Constraint R
FieldCode nvarchar 60 null
GenericCode nvarchar 60 null
Short nvarchar 240 null
Description nvarchar 510 null
Active bit 1 null
XTname nvarchar 40 null
XFname nvarchar 40 null

Table contained 284 rows

Indexes

Constraint Name Type Sort Column(s)
CodeValues_PrimaryKey Primary key Asc ValueId
CodeValues_CodeId_Index Performance Asc CodeId
CodeValues_ValueId_Index Performance Asc ValueId

Relationships