scarab
| Table Name | OM Class | Description |
|---|
| TURBINE_PERMISSION | TurbinePermission | |
| TURBINE_ROLE | TurbineRole | |
| TURBINE_GROUP | TurbineGroup | |
| TURBINE_ROLE_PERMISSION | TurbineRolePermission | |
| TURBINE_USER | TurbineUser | |
| TURBINE_USER_GROUP_ROLE | TurbineUserGroupRole | |
TURBINE_PERMISSION
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| PERMISSION_ID | INTEGER | | | PermissionId | X | | X | |
| PERMISSION_NAME | VARCHAR | (99) | | Name | | | X | |
TURBINE_ROLE
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| ROLE_ID | INTEGER | | | RoleId | X | | X | |
| ROLE_NAME | VARCHAR | (99) | | Name | | | X | |
TURBINE_GROUP
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| GROUP_ID | INTEGER | | | GroupId | X | | X | |
| GROUP_NAME | VARCHAR | (99) | | Name | | | X | |
TURBINE_ROLE_PERMISSION
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| ROLE_ID | INTEGER | | | RoleId | X | X | X | |
| PERMISSION_ID | INTEGER | | | PermissionId | X | X | X | |
TURBINE_USER
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| USER_ID | INTEGER | | | UserId | X | | X | |
| LOGIN_NAME | VARCHAR | (99) | | UserName | | | X | |
| PASSWORD_VALUE | VARCHAR | (32) | | Password | | | X | |
| FIRST_NAME | VARCHAR | (99) | | FirstName | | | X | |
| LAST_NAME | VARCHAR | (99) | | LastName | | | X | |
| EMAIL | VARCHAR | (99) | | Email | | | | |
| CONFIRM_VALUE | VARCHAR | (99) | | Confirmed | | | | |
| MODIFIED | TIMESTAMP | | | Modified | | | | |
| CREATED | TIMESTAMP | | | CreateDate | | | | |
| LAST_LOGIN | TIMESTAMP | | | LastLogin | | | | |
| OBJECTDATA | VARBINARY | | | Objectdata | | | | |
TURBINE_USER_GROUP_ROLE
| Name | Type | Size | Default | JavaName | PK | FK | not null | Description |
|---|
| USER_ID | INTEGER | | | UserId | X | X | X | |
| GROUP_ID | INTEGER | | | GroupId | X | | X | |
| ROLE_ID | INTEGER | | | RoleId | X | X | X | |