CheckListChoiceValues


Description

Checklist choice value definitions defining predefined choice values for checklist items with selection options. This lookup table manages standardized choice values such as Yes/No, Pass/Fail, or custom options that can be used in checklist items requiring selection from predefined options.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ChoiceText Unknown 0 null

Choice text - Display text for the choice option

ChoiceValue Unknown 0 null

Choice value - Underlying value associated with the choice

pkCheckListChoiceValueID int identity 4 null

Primary key - Unique identifier for each choice value

Name varchar 100 null

Choice value name - Name or label of the choice value option

pkChoiceValueID Unknown 0 null

Primary key - Unique identifier for each choice value

Indexes

Constraint Name Type Sort Column(s)
PK__CheckLis__777ABD79242D21BE Primary key Asc pkCheckListChoiceValueID

Relationships