| Table: dbo.Import_Template | |||
| Parent record for user-defined Import Templates. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| import_template_KEY | int (4) | NOT NULL | Primary key. |
| import_template_type_KEY | int (4) | NOT NULL | Link to the template type; defines the type of data that can be imported. |
| description | nvarchar (100) | NOT NULL | User-defined description for this template. |
| client_KEY | int (4) | NOT NULL | Client that this template can be used with. |
| staff_KEY | int (4) | NOT NULL | Staff that can use this template. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Import_Template | import_template_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Import_Template$description$client_KEY | description, client_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Import_Template_Column__Import_Template__import_template_KEY | import_template_KEY | Import_Template_Column | |