Table: dbo.User_Interface_Grid
This table holds the description of the grid that has the column with customised display settings and the link to the screen it belongs to.
Columns
NameTypeConstraintsDescription
user_interface_grid_KEYint (4)NOT NULLPrimary key.
user_interface_screen_KEYint (4)NOT NULLA link to the screen this grid belongs to.
descriptionnvarchar (60)NOT NULLThe name of the grid.
Primary key
NameColumnsDescription
PK_User_Interface_Griduser_interface_grid_KEY
Unique constraints
NameColumnsDescription
UK_User_Interface_Grid$user_interface_grid_KEY$descriptionuser_interface_grid_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Interface_Grid__User_Interface_Screen__user_interface_screen_KEYuser_interface_screen_KEYUser_Interface_Screen (user_interface_screen_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Interface_Grid_Column__User_Interface_Grid__user_interface_grid_KEYuser_interface_grid_KEYUser_Interface_Grid_Column

Schema diagram