Represents the relationship between a system item type and an interface
Data model
Fields
| Field | Type | Description |
|---|---|---|
| interface_id* | INT | Unique interface identifier, reference table ASMS_INTERFACE.id |
| interface_type* | INT | Identify the type of interface that applies, (1 = form, 2 = search, 3 = replacements, 4 = lists) |
| item_type_id* | INT | Item type identifier, reference the ASMS_TYPES.id table |
Primary Key
| PK_ASMS_INTERFACE_TYPE |
|---|
| interface_id, item_type_id, interface_type |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| interface_id* | dbo.ASMS_INTERFACE_BUILTIN | id | FK01_ASMS_INTERFACE_TYPE |
| item_type_id* | dbo.ASMS_TYPES | id | FK02_ASMS_INTERFACE_TYPE |