GroupRoleUserTable of Group''s Roles Users GroupId Group Primary Key. int false UserId User Primary Key. int false RoleId Role Primary Key. int false GroupRoleUser_PK RoleId UserId GroupId UserGroup_GroupRoleUser_FK1 GroupId UserId UserGroup GroupId UserId cascade cascade GroupRole_GroupRoleUser_FK1 GroupId RoleId GroupRole GroupId RoleId cascade cascade RoleLogTable of Role Activity Logs RoleLogId Primary Key for Role Log Table. int true false RoleId Primary Key for Role. int true ActivityId Id of Created Activity. int false DataCreated Date Role Log was Created. timestamp now() true RoleLog_PK RoleLogId Role_RoleLog_OUC_ODSN_FK1 RoleId Role RoleId cascade set null UserRoleTable of User''s Roles UserId Primary Key for User. int false RoleId Primary Key for Role. int false UserRole_PK UserId RoleId User_UserRole_FK1 UserId User UserId cascade cascade Role_UserRole_FK1 RoleId Role RoleId cascade cascade RolePermissionTable of Role Permission RoleId Primary Key for Role. int false PermissionId Primary Key for Permission. int false Deny Can be set to true if a deny permission is to be placed on a permission for an inherited role. bit false true RolePermission_PK RoleId PermissionId Role_RolePermission_FK1 RoleId Role RoleId cascade cascade Permission_RolePermission_FK1 PermissionId Permission PermissionId cascade cascade GroupRoleTable of Group''s Roles GroupId Primary Key for Group. int false RoleId Primary Key for Role. int false Title Title of the Role. varchar(50) true GroupRole_PK GroupId RoleId Group_GroupRole_FK1 GroupId Group GroupId cascade cascade Role_GroupRole_FK1 RoleId Role RoleId cascade cascade RoleTable of Roles RoleId Primary Key for Group Table. int true false Title Title of the Role. varchar(50) false Description Verbose Description of Role. text true DateCreated Date Role was Created. timestamp now() false Removable Boolean Value to specify whether Role is removable. bit false false Role_PK RoleId GroupLogGroup Activity Log Table GroupLogId Primary Key for Group Log Table. int true false GroupId Primary Key for Group. int true ActivityId Id of Created Activity. int false DateCreated Date Group Log was Created. timestamp true GroupLog_PK GroupLogId Group_GroupLog_OUC_ODSN_FK1 GroupId Group GroupId cascade set null UserLogUser Activity Log Table UserLogId Primary Key for User Log Table. int true false UserId Primary Key for User. int true ActivityId Id of Created Activity. int false DateCreated Date User Log was Created. timestamp now() true UserLog_PK UserLogId User_UserLog_OUC_ODSN_FK1 UserId User UserId cascade set null GroupPermissionTable of Group Permission GroupId Primary Key for Group. int false PermissionId Primary Key for Permission. int false Deny Can be set to true if a deny permission is to be placed on a permission for an inherited group. bit false true GroupPermission_PK GroupId PermissionId Group_GroupPermission_FK1 GroupId Group GroupId cascade cascade Permission_GroupPermission_FK1 PermissionId Permission PermissionId cascade cascade UserPermissionTable of User Permissions UserId Primary Key for User. int false PermissionId Primary Key for Permission. int false Deny Can be set to true if a deny permission is to be placed on a permission for an inherited group. bit false true UserPermission_PK UserId PermissionId User_UserPermission_FK1 UserId User UserId cascade cascade Permission_UserPermission_FK1 PermissionId Permission PermissionId cascade cascade PermissionTable of Permissions PermissionId Primary Key for Permission Table. int true false Name Nameof Permission. varchar(50) false Description Verbose Description for Permission. text true DateCreated Date Permission was Installed. timestamp now() true Removable Boolean Value to specify whether permission is removable. bit false false Permission_PK PermissionId UserGroupTable of User Groups UserId Primary Key for User. int false GroupId Primary Key for Group. int false UserGroup_PK GroupId UserId User_UserGroup_FK1 UserId User UserId cascade cascade Group_UserGroup_FK1 GroupId Group GroupId cascade cascade GroupSystem Groups Table GroupId Primary Key for Group Table. int true false ParentId Parent Id for Group. int false Name Name of Group. varchar(32) false MemberTitle Default Title of Group Member. varchar(50) false Description Verbose Description of Group. text true DateCreated Date Group was Created. timestamp now() true Removable Boolean Value to specify whether Group is removable. bit false false MinimumMembers Minimum Number of required Group Users. int 0 false MaximumMembers Maximum Number of required Group Users. int true Group_PK GroupId Group_Name_IX Name Group_Group_FK1 ParentId Group GroupId cascade cascade UserSystem Users Table UserId Primary Key for User Table. int true false Username Username of User. varchar(32) false Password Password of User. varchar(32) false Active Boolean Value if the User is an Active User. bit false DateCreated Date User was Created. timestamp now() true User_PK UserId User_UC1 UserId