| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | NAME | Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 2 | EXTENSION | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 3 | VERSION | Version | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | ASSOC_KEY | Association | varbinary | 16 | 0 | | | | |
| 5 | BO_KEY | Business Object | varbinary | 16 | 0 | | | | |
| 6 | ASSOC_TYPE | Association Type (Composition or Association) | char | 1 | 0 | | | | Allow NULL? |
| 7 | ASSOC_CAT | Association Category | char | 1 | 0 | | | | Allow NULL? |
| 8 | ASSOC_NAME | Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 9 | ASSOC_ESR_NAME | Proxy Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 10 | ASSOC_GENIL_NAME | GenIL Association Name | nvarchar | 29 | 0 | | | | Allow NULL? |
| 11 | ASSOC_CLASS | Object Type Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 12 | SOURCE_NODE_KEY | Node | varbinary | 16 | 0 | | | | |
| 13 | ATTR_NAME_SOURCE | Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 14 | TARGET_NODE_KEY | Node | varbinary | 16 | 0 | | | | |
| 15 | PARAM_DATA_TYPE | Name of a structure | nvarchar | 30 | 0 | | | | Allow NULL? |
| 16 | CARDINALITY | Association Cardinality | tinyint | 3 | 0 | | | | |
| 17 | QUERY_KEY | Query | varbinary | 16 | 0 | | | | |
| 18 | SECKEYNAME | Name of Secondary Key for Table Type | nvarchar | 30 | 0 | | | | Allow NULL? |
| 19 | CHANGE_RESOLVE | Resolving Location of Association Canges | char | 1 | 0 | | | | Allow NULL? |
| 20 | ALIAS_RETRIEVE | Component name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 21 | ALIAS_RETRIEVE_S | Component name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 22 | ALIAS_DELETE | Component name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 23 | ALIAS_DELETE_S | Component name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 24 | ESR_PARAM_DATA_T | Name of a structure | nvarchar | 30 | 0 | | | | Allow NULL? |
| 25 | ASSOC_RESOLVE | Resolving Node for Association | char | 1 | 0 | | | | Allow NULL? |
| 26 | USE_PROXY_TYPE | Use proxy data types in internal model | char | 1 | 0 | | | | Allow NULL? |
| 27 | SP_MAPPER_CLASS | Object Type Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 28 | ASSOC_MODELED | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 29 | TD_CONTAINER | Test Data Container | nvarchar | 30 | 0 | | | | Allow NULL? |
| 30 | TD_CONTAINER_VAR | Variant name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 31 | CREATE_USER | User that Created the Setting | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | CREATE_TIME | Date on Which the Settings were Created | decimal | 15 | 0 | | | | |
| 33 | CHANGE_USER | User that was Last to Change the Setting | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | CHANGE_TIME | Date on which the Settings Were Changed Last | decimal | 15 | 0 | | | | |
