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 |