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) |