dbo.user_roles
Documentation | CRM |
Schema | dbo |
Name | user_roles |
Module | Users |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | user_role_id | int | Identity | |||||
Identity |
||||||||
2 | login | nvarchar(100) | ||||||
3 | user_role | nvarchar(50) | dbo.user_role_types | |||||
References: dbo.user_role_types |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.user_roles | dbo.user_role_types | dbo.user_roles.user_role = dbo.user_role_types.user_role | FK_user_roles_tab_user_role_types_tab |
|
dbo.user_roles.user_role = dbo.user_role_types.user_role Name: FK_user_roles_tab_user_role_types_tab |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_user_roles_tab | user_role_id | ||
Uses
Name |
---|
dbo.user_roles
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29