rendered paste body<schema> <database> <table> <name>GroupRoleUser</name> <comment>Table of Group''s Roles Users</comment> <column> <name>GroupId</name> <comment>Group Primary Key.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>UserId</name> <comment>User Primary Key.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>RoleId</name> <comment>Role Primary Key.</comment> <dataType>int</dataType> <null>false</null> </column> <primaryKey> <name>GroupRoleUser_PK</name> <column>RoleId</column> <column>UserId</column> <column>GroupId</column> </primaryKey> <foreignKey> <name>UserGroup_GroupRoleUser_FK1</name> <column>GroupId</column> <column>UserId</column> <reference> <table>UserGroup</table> <column>GroupId</column> <column>UserId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>GroupRole_GroupRoleUser_FK1</name> <column>GroupId</column> <column>RoleId</column> <reference> <table>GroupRole</table> <column>GroupId</column> <column>RoleId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>RoleLog</name> <comment>Table of Role Activity Logs</comment> <column> <name>RoleLogId</name> <comment>Primary Key for Role Log Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>RoleId</name> <comment>Primary Key for Role.</comment> <dataType>int</dataType> <null>true</null> </column> <column> <name>ActivityId</name> <comment>Id of Created Activity.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>DataCreated</name> <comment>Date Role Log was Created.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>true</null> </column> <primaryKey> <name>RoleLog_PK</name> <column>RoleLogId</column> </primaryKey> <foreignKey> <name>Role_RoleLog_OUC_ODSN_FK1</name> <column>RoleId</column> <reference> <table>Role</table> <column>RoleId</column> </reference> <action> <update>cascade</update> <delete>set null</delete> </action> </foreignKey> </table> <table> <name>UserRole</name> <comment>Table of User''s Roles</comment> <column> <name>UserId</name> <comment>Primary Key for User.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>RoleId</name> <comment>Primary Key for Role.</comment> <dataType>int</dataType> <null>false</null> </column> <primaryKey> <name>UserRole_PK</name> <column>UserId</column> <column>RoleId</column> </primaryKey> <foreignKey> <name>User_UserRole_FK1</name> <column>UserId</column> <reference> <table>User</table> <column>UserId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Role_UserRole_FK1</name> <column>RoleId</column> <reference> <table>Role</table> <column>RoleId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>RolePermission</name> <comment>Table of Role Permission</comment> <column> <name>RoleId</name> <comment>Primary Key for Role.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>PermissionId</name> <comment>Primary Key for Permission.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>Deny</name> <comment>Can be set to true if a deny permission is to be placed on a permission for an inherited role.</comment> <dataType>bit</dataType> <default>false</default> <null>true</null> </column> <primaryKey> <name>RolePermission_PK</name> <column>RoleId</column> <column>PermissionId</column> </primaryKey> <foreignKey> <name>Role_RolePermission_FK1</name> <column>RoleId</column> <reference> <table>Role</table> <column>RoleId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Permission_RolePermission_FK1</name> <column>PermissionId</column> <reference> <table>Permission</table> <column>PermissionId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>GroupRole</name> <comment>Table of Group''s Roles</comment> <column> <name>GroupId</name> <comment>Primary Key for Group.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>RoleId</name> <comment>Primary Key for Role.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>Title</name> <comment>Title of the Role.</comment> <dataType>varchar(50)</dataType> <null>true</null> </column> <primaryKey> <name>GroupRole_PK</name> <column>GroupId</column> <column>RoleId</column> </primaryKey> <foreignKey> <name>Group_GroupRole_FK1</name> <column>GroupId</column> <reference> <table>Group</table> <column>GroupId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Role_GroupRole_FK1</name> <column>RoleId</column> <reference> <table>Role</table> <column>RoleId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>Role</name> <comment>Table of Roles</comment> <column> <name>RoleId</name> <comment>Primary Key for Group Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>Title</name> <comment>Title of the Role.</comment> <dataType>varchar(50)</dataType> <null>false</null> </column> <column> <name>Description</name> <comment>Verbose Description of Role.</comment> <dataType>text</dataType> <null>true</null> </column> <column> <name>DateCreated</name> <comment>Date Role was Created.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>false</null> </column> <column> <name>Removable</name> <comment>Boolean Value to specify whether Role is removable.</comment> <dataType>bit</dataType> <default>false</default> <null>false</null> </column> <primaryKey> <name>Role_PK</name> <column>RoleId</column> </primaryKey> </table> <table> <name>GroupLog</name> <comment>Group Activity Log Table</comment> <column> <name>GroupLogId</name> <comment>Primary Key for Group Log Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>GroupId</name> <comment>Primary Key for Group.</comment> <dataType>int</dataType> <null>true</null> </column> <column> <name>ActivityId</name> <comment>Id of Created Activity.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>DateCreated</name> <comment>Date Group Log was Created.</comment> <dataType>timestamp</dataType> <null>true</null> </column> <primaryKey> <name>GroupLog_PK</name> <column>GroupLogId</column> </primaryKey> <foreignKey> <name>Group_GroupLog_OUC_ODSN_FK1</name> <column>GroupId</column> <reference> <table>Group</table> <column>GroupId</column> </reference> <action> <update>cascade</update> <delete>set null</delete> </action> </foreignKey> </table> <table> <name>UserLog</name> <comment>User Activity Log Table</comment> <column> <name>UserLogId</name> <comment>Primary Key for User Log Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>UserId</name> <comment>Primary Key for User.</comment> <dataType>int</dataType> <null>true</null> </column> <column> <name>ActivityId</name> <comment>Id of Created Activity.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>DateCreated</name> <comment>Date User Log was Created.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>true</null> </column> <primaryKey> <name>UserLog_PK</name> <column>UserLogId</column> </primaryKey> <foreignKey> <name>User_UserLog_OUC_ODSN_FK1</name> <column>UserId</column> <reference> <table>User</table> <column>UserId</column> </reference> <action> <update>cascade</update> <delete>set null</delete> </action> </foreignKey> </table> <table> <name>GroupPermission</name> <comment>Table of Group Permission</comment> <column> <name>GroupId</name> <comment>Primary Key for Group.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>PermissionId</name> <comment>Primary Key for Permission.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>Deny</name> <comment>Can be set to true if a deny permission is to be placed on a permission for an inherited group.</comment> <dataType>bit</dataType> <default>false</default> <null>true</null> </column> <primaryKey> <name>GroupPermission_PK</name> <column>GroupId</column> <column>PermissionId</column> </primaryKey> <foreignKey> <name>Group_GroupPermission_FK1</name> <column>GroupId</column> <reference> <table>Group</table> <column>GroupId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Permission_GroupPermission_FK1</name> <column>PermissionId</column> <reference> <table>Permission</table> <column>PermissionId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>UserPermission</name> <comment>Table of User Permissions</comment> <column> <name>UserId</name> <comment>Primary Key for User.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>PermissionId</name> <comment>Primary Key for Permission.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>Deny</name> <comment>Can be set to true if a deny permission is to be placed on a permission for an inherited group.</comment> <dataType>bit</dataType> <default>false</default> <null>true</null> </column> <primaryKey> <name>UserPermission_PK</name> <column>UserId</column> <column>PermissionId</column> </primaryKey> <foreignKey> <name>User_UserPermission_FK1</name> <column>UserId</column> <reference> <table>User</table> <column>UserId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Permission_UserPermission_FK1</name> <column>PermissionId</column> <reference> <table>Permission</table> <column>PermissionId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>Permission</name> <comment>Table of Permissions</comment> <column> <name>PermissionId</name> <comment>Primary Key for Permission Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>Name</name> <comment>Nameof Permission.</comment> <dataType>varchar(50)</dataType> <null>false</null> </column> <column> <name>Description</name> <comment>Verbose Description for Permission.</comment> <dataType>text</dataType> <null>true</null> </column> <column> <name>DateCreated</name> <comment>Date Permission was Installed.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>true</null> </column> <column> <name>Removable</name> <comment>Boolean Value to specify whether permission is removable.</comment> <dataType>bit</dataType> <default>false</default> <null>false</null> </column> <primaryKey> <name>Permission_PK</name> <column>PermissionId</column> </primaryKey> </table> <table> <name>UserGroup</name> <comment>Table of User Groups</comment> <column> <name>UserId</name> <comment>Primary Key for User.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>GroupId</name> <comment>Primary Key for Group.</comment> <dataType>int</dataType> <null>false</null> </column> <primaryKey> <name>UserGroup_PK</name> <column>GroupId</column> <column>UserId</column> </primaryKey> <foreignKey> <name>User_UserGroup_FK1</name> <column>UserId</column> <reference> <table>User</table> <column>UserId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> <foreignKey> <name>Group_UserGroup_FK1</name> <column>GroupId</column> <reference> <table>Group</table> <column>GroupId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>Group</name> <comment>System Groups Table</comment> <column> <name>GroupId</name> <comment>Primary Key for Group Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>ParentId</name> <comment>Parent Id for Group.</comment> <dataType>int</dataType> <null>false</null> </column> <column> <name>Name</name> <comment>Name of Group.</comment> <dataType>varchar(32)</dataType> <null>false</null> </column> <column> <name>MemberTitle</name> <comment>Default Title of Group Member.</comment> <dataType>varchar(50)</dataType> <null>false</null> </column> <column> <name>Description</name> <comment>Verbose Description of Group.</comment> <dataType>text</dataType> <null>true</null> </column> <column> <name>DateCreated</name> <comment>Date Group was Created.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>true</null> </column> <column> <name>Removable</name> <comment>Boolean Value to specify whether Group is removable.</comment> <dataType>bit</dataType> <default>false</default> <null>false</null> </column> <column> <name>MinimumMembers</name> <comment>Minimum Number of required Group Users.</comment> <dataType>int</dataType> <default>0</default> <null>false</null> </column> <column> <name>MaximumMembers</name> <comment>Maximum Number of required Group Users.</comment> <dataType>int</dataType> <null>true</null> </column> <primaryKey> <name>Group_PK</name> <column>GroupId</column> </primaryKey> <index> <name>Group_Name_IX</name> <column>Name</column> </index> <foreignKey> <name>Group_Group_FK1</name> <column>ParentId</column> <reference> <table>Group</table> <column>GroupId</column> </reference> <action> <update>cascade</update> <delete>cascade</delete> </action> </foreignKey> </table> <table> <name>User</name> <comment>System Users Table</comment> <column> <name>UserId</name> <comment>Primary Key for User Table.</comment> <dataType>int</dataType> <autoNumber>true</autoNumber> <null>false</null> </column> <column> <name>Username</name> <comment>Username of User.</comment> <dataType>varchar(32)</dataType> <null>false</null> </column> <column> <name>Password</name> <comment>Password of User.</comment> <dataType>varchar(32)</dataType> <null>false</null> </column> <column> <name>Active</name> <comment>Boolean Value if the User is an Active User.</comment> <dataType>bit</dataType> <null>false</null> </column> <column> <name>DateCreated</name> <comment>Date User was Created.</comment> <dataType>timestamp</dataType> <default>now()</default> <null>true</null> </column> <primaryKey> <name>User_PK</name> <column>UserId</column> </primaryKey> <uniqueKey> <name>User_UC1</name> <column>UserId</column> </uniqueKey> </table> </database></schema>