Diagrams


Table

XML Schema Element

Fields

# Name Type
1 XML Schema Code (XML Schema Code) Code20
2 ID (ID) Integer
3 Parent ID (Parent ID) Integer
4 Node Name (Node Name) Text250
5 Node Type (Node Type) Option
6 Data Type (Data Type) Text250
7 MinOccurs (MinOccurs) Integer
8 MaxOccurs (MaxOccurs) Integer
9 Choice (Choice) Boolean
20 Sort Key (Sort Key) Text200
21 Indentation (Indentation) Integer
22 Visible (Visible) Boolean
23 Selected (Selected) Boolean
24 Simple Data Type (Simple Data Type) Text50 Editable: No
25 Defintion XML Schema Code (Defintion XML Schema Code) Code20
26 Definition XML Schema ID (Definition XML Schema ID) Integer

Keys

# Fields
0 XML Schema Code,ID (XML Schema Code,ID) Clustered: Yes
1 Parent ID,XML Schema Code (Parent ID,XML Schema Code)
2 XML Schema Code,Sort Key (XML Schema Code,Sort Key)
3 Node Name,XML Schema Code (Node Name,XML Schema Code)
4 Data Type,XML Schema Code (Data Type,XML Schema Code)

Table Relations To Other Tables

Field Related Table Related Field
XML Schema Code (XML Schema Code) XML Schema Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
XML Schema Restriction Element ID (Element ID) 1..n