Table: Custom_Field_Type
Tags: read-only Content:
1 | Text
2 | Date
3 | Number
4 | Check Box
5 | List
6 | Staff List
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 |