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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Import_Template__Import_Template_Type__import_template_type_KEY | import_template_type_KEY | Import_Template_Type (import_template_type_KEY) |
FK_Import_Template__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Import_Template_Column__Import_Template__import_template_KEY | import_template_KEY | Import_Template_Column |