Overview

This is the Turbine included schema for generating Torque Peers for the Torque Security Service:

Table Name OM Class Description
TURBINE_USER TurbineUser
TURBINE_GROUP TurbineGroup
TURBINE_ROLE TurbineRole
TURBINE_PERMISSION TurbinePermission
TURBINE_ROLE_PERMISSION TurbineRolePermission
TURBINE_USER_GROUP_ROLE TurbineUserGroupRole

User Peer

The User Peer contains all information regarding a Turbine User.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
USER_ID INTEGER UserId X X
LOGIN_NAME VARCHAR (64) UserName X
PASSWORD_VALUE VARCHAR (16) Password X
FIRST_NAME VARCHAR (64) FirstName X
LAST_NAME VARCHAR (64) LastName X
EMAIL VARCHAR (64) Email
CONFIRM_VALUE VARCHAR (16) Confirmed
MODIFIED TIMESTAMP Modified
CREATED TIMESTAMP CreateDate
LAST_LOGIN TIMESTAMP LastLogin
OBJECTDATA VARBINARY Objectdata

Group Peer

The Group Peer contains all information regarding the Turbine Groups.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
GROUP_ID INTEGER GroupId X X
GROUP_NAME VARCHAR (64) Name X

Role Peer

The Role Peer contains all information regarding a Turbine Role.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
ROLE_ID INTEGER RoleId X X
ROLE_NAME VARCHAR (64) Name X

User Peer

The Permission Peer contains all information regarding the Turbine Permissions.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
PERMISSION_ID INTEGER PermissionId X X
PERMISSION_NAME VARCHAR (64) Name X

Role / Permission Peer

The Role / Permission Peer contains the relation between Roles and Permissions. It controls which Role has which Permissions assigned.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
ROLE_ID INTEGER RoleId X X X
PERMISSION_ID INTEGER PermissionId X X X

User / Group / Role Peer

The User / Group / Role Peer contains the User / Group / Role relation which assigns Roles to an User according to its membership in a Group.

Name Type Size Default JavaName Primary Key Foreign Key not null Description
USER_ID INTEGER UserId X X X
GROUP_ID INTEGER GroupId X X X
ROLE_ID INTEGER RoleId X X X