Diagrams

Table

Config. Question Area

DynamicsDocs.comConfig. Question Area«Table 8611»Config. Question AreaQuestionnaire Code [PK,NN]Code [PK,NN]DescriptionTable IDTable NameTable CaptionNo. of Questions«Table 8612»Config. QuestionQuestionnaire Code [PK]Question Area Code [PK]No. [PK]QuestionAnswer OptionAnswerTable IDField IDReferenceQuestion OriginField NameField Caption«Table 8610»Config. QuestionnaireCode [PK,NN]Description<Questionnaire Code><Question Area Code><Questionnaire Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Questionnaire Code (Questionnaire Code) Code10 NotBlank: Yes
Editable: No
2 Code (Code) Code10 NotBlank: Yes
3 Description (Description) Text50
4 Table ID (Table ID) Integer
5 Table Name (Table Name) Text250 Editable: No
FlowField
6 Table Caption (Table Caption) Text250 Editable: No
FlowField
7 No. of Questions (No. of Questions) Integer Editable: No
FlowField

Keys

# Fields
0 Questionnaire Code,Code (Questionnaire Code,Code) Clustered: Yes
1 Table ID (Table ID)

Table Relations To Other Tables

Field Related Table Related Field
Table ID (Table ID) AllObjWithCaption Object ID (Object ID) 1..n
Questionnaire Code (Questionnaire Code) Config. Questionnaire Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Config. Question Question Area Code (Question Area Code) 1..n