Table: dbo.User_Interface_Grid_Column
This table holds the description of the columns and whether it is required and the link to the grid it belongs to.
Columns
Name | Type | Constraints | Description
user_interface_grid_column_KEY | int (4) | NOT NULL | Primary key.
user_interface_grid_KEY | int (4) | NOT NULL | A link to the grid this column belongs to.
description | nvarchar (100) | NOT NULL | The name of the column.
is_required | bit (1) | NOT NULL |

Primary key
Name | Columns | Description
PK_User_Interface_Grid_Column | user_interface_grid_column_KEY |
Unique constraints
Name | Columns | Description
UK_User_Interface_Grid_Column$user_interface_grid_column_KEY$description | user_interface_grid_column_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Interface_Grid_Column__User_Interface_Grid__user_interface_grid_KEY | user_interface_grid_KEY | User_Interface_Grid (user_interface_grid_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Tracking_Portlet_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEY | user_interface_grid_column_KEY | Payroll_Tracking_Portlet_Column_Screen_Option |
FK_User_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEY | user_interface_grid_column_KEY | User_Preference_Grid_Column_Screen_Option |
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEY | user_interface_grid_column_KEY | User_Client_Preference_Grid_Column_Screen_Option |