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 |
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 | ||||
| VARCHAR | (64) | |||||||
| CONFIRM_VALUE | VARCHAR | (16) | Confirmed | |||||
| MODIFIED | TIMESTAMP | Modified | ||||||
| CREATED | TIMESTAMP | CreateDate | ||||||
| LAST_LOGIN | TIMESTAMP | LastLogin | ||||||
| OBJECTDATA | VARBINARY | Objectdata |
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 |
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 |
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 |
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 |
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 |