Overview

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

Table NameOM ClassDescription
TURBINE_USERTurbineUser
TURBINE_GROUPTurbineGroup
TURBINE_ROLETurbineRole
TURBINE_PERMISSIONTurbinePermission
TURBINE_ROLE_PERMISSIONTurbineRolePermission
TURBINE_USER_GROUP_ROLETurbineUserGroupRole

User Peer

The User Peer contains all information regarding a Turbine User.

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
USER_IDINTEGER UserIdXX
LOGIN_NAMEVARCHAR (64)UserNameX
PASSWORD_VALUEVARCHAR (16)PasswordX
FIRST_NAMEVARCHAR (64)FirstNameX
LAST_NAMEVARCHAR (64)LastNameX
EMAILVARCHAR (64)Email
CONFIRM_VALUEVARCHAR (16)Confirmed
MODIFIEDTIMESTAMP Modified
CREATEDTIMESTAMP CreateDate
LAST_LOGINTIMESTAMP LastLogin
OBJECTDATAVARBINARY Objectdata

Group Peer

The Group Peer contains all information regarding the Turbine Groups.

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
GROUP_IDINTEGER GroupIdXX
GROUP_NAMEVARCHAR (64)NameX

Role Peer

The Role Peer contains all information regarding a Turbine Role.

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
ROLE_IDINTEGER RoleIdXX
ROLE_NAMEVARCHAR (64)NameX

User Peer

The Permission Peer contains all information regarding the Turbine Permissions.

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
PERMISSION_IDINTEGER PermissionIdXX
PERMISSION_NAMEVARCHAR (64)NameX

Role / Permission Peer

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

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
ROLE_IDINTEGER RoleIdXXX
PERMISSION_IDINTEGER PermissionIdXXX

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.

NameTypeSizeDefaultJavaNamePrimary KeyForeign Keynot nullDescription
USER_IDINTEGER UserIdXXX
GROUP_IDINTEGER GroupIdXXX
ROLE_IDINTEGER RoleIdXXX