Diagrams


Table

Config. Question

Fields

# Name Type
1 Questionnaire Code (Questionnaire Code) Code10 Editable: No
2 Question Area Code (Question Area Code) Code10 Editable: No
3 No. (No.) Integer
4 Question (Question) Text250
5 Answer Option (Answer Option) Text250 Editable: No
6 Answer (Answer) Text250
7 Table ID (Table ID) Integer
8 Field ID (Field ID) Integer
9 Reference (Reference) Text250 [URL]
10 Question Origin (Question Origin) Text30
11 Field Name (Field Name) Text30 Editable: No
FlowField
12 Field Caption (Field Caption) Text250 Editable: No
FlowField

Keys

# Fields
0 Questionnaire Code,Question Area Code,No. (Questionnaire Code,Question Area Code,No.) Clustered: Yes
1 Questionnaire Code,Question Area Code,Field ID (Questionnaire Code,Question Area Code,Field ID)
2 Table ID,Field ID (Table ID,Field ID)

Table Relations To Other Tables

Field Related Table Related Field
Question Area Code (Question Area Code) Config. Question Area Code (Code) 1..n
Questionnaire Code (Questionnaire Code) Config. Questionnaire Code (Code) 1..n

Table Relations From Other Tables

From Table From Field