Scarab - scarab

Scarab Home | Scarab Wiki

General Information

Documentation

Maven Goals

Project Tools

Project Documentation

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