##### General Information

- Overview
- Features
- Specification
- Getting Started
- Howto Build Turbine
- Changes

##### Documentation

- Services
  - Assembler Broker Service
  - Avalon Component Service
  - Crypto Service
  - Cache Service
  - Component Service
  - Factory Service
  - Intake Service
  - JSON-RPC Service
  - JSP Service
  - Localization Service
  - MimeType Service
  - Naming Service
  - Parser Service
  - Pool Service
  - Pull Service
  - RunData Service
  - Scheduler Service
  - Security Service
  - Servlet Service
  - Session Service
  - Template Service
  - Torque Security Service
  - Torque Security Service Schema
  - UI Service
  - Unique ID Service
  - Upload Service
  - Velocity Service
  - XML-RPC Service
  - XSLT Service
- Howtos
- Wiki
- JavaDocs

##### Development

- Proposals
- How To Help
- Todo

##### Project Documentation

- Project Information
- Project Reports

##### Apache

- Apache Website
- License
- How the ASF works
- Sponsorship
- Thanks
- Security

## 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 |