Table: Custom_Field_Type | |||||||||||||||
Tags: read-only Content:
| |||||||||||||||
Columns | |||||||||||||||
Name | Type | Constraints | Description | ||||||||||||
custom_field_type_KEY | int | NOT NULL | 1=Text 2=Date 3=Number 4=Check Box 5=List 6=Staff List | ||||||||||||
description | nvarchar (30) | NOT NULL | Description. |
Primary key | |||
Name | Columns | Description | |
PK_Custom_Field_Type$custom_field_type_KEY | custom_field_type_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Custom_Field_Type__description | description | Each description must be unique. |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Custom_Field__Custom_Field_Type__custom_field_type_KEY | custom_field_type_KEY | Custom_Field |