COMMON schema tables

Table 1. ACTIONS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
ACTIONS	ACTIONKEY	INTEGER	4	No
	ACTION_GROUP_ID	INTEGER	4	Yes
	ACTION_INTERNAL_NAME	VARCHAR	100	No
	ACTIONAME	VARCHAR	100	No
	ACTIONDESC	VARCHAR	1024	Yes
	ACTION_LABEL_PROP	VARCHAR	100	Yes
	ACTION_TYPE	INTEGER	4	Yes

Table 2. ASSETPERMISSIONSDEFAULT table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
ASSETPERMISSIONSDEFAULT	ASSETPERMDEFKEY	INTEGER	4	No
	ACTIONKEY	INTEGER	4	No
	ACTIONSTATE	INTEGER	4	Yes
	INT_VALUE	INTEGER	4	Yes
	STR_VALUE	VARCHAR	255	Yes

Table 3. ASSETPERMISSIONSDEFAULTNAME table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
ASSETPERMISSIONSDEFAULTNAME	ASSETPERMDEFKEY	INTEGER	4	No
	DEFDESC	VARCHAR	1024	Yes

Table 4. CACHE_GROUPASSET table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CACHE_GROUPASSET	HWKEY	INTEGER	4	No
	GAKEYS	VARCHAR	128	Yes
	EXPIRES	TIMESTAMP	10	Yes

Table 5. CACHE_GROUPUSER table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CACHE_GROUPUSER	USERKEY	INTEGER	4	No
	GUKEYS	VARCHAR	128	Yes
	EXPIRES	TIMESTAMP	10	Yes

Table 6. CONFIGURATION table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CONFIGURATION	NAME	VARCHAR	128	No
	VALUE	VARCHAR	256	Yes

Table 7. CUSTOM_QUERY table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CUSTOM_QUERY	CUSTOM_QUERYKEY	INTEGER	4	No
	NAME	VARCHAR	50	No
	MENU_NAME	VARCHAR	50	No
	DESCRIPTION	VARCHAR	120	Yes
	SQL_DATA	CLOB	524288	No
	CREATOR	INTEGER	4	Yes
	CREATED	TIMESTAMP	10	No

Table 8. CUSTOM_QUERY_GROUP_ACCESS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CUSTOM_QUERY_GROUP_ACCESS	CUSTOM_QUERYKEY	INTEGER	4	No
	GROUPKEY	INTEGER	4	No

Table 9. CUSTOM_QUERY_USER_ACCESS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
CUSTOM_QUERY_USER_ACCESS	CUSTOM_QUERYKEY	INTEGER	4	No
	USERKEY	INTEGER	4	No

Table 10. FAVOURITES table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
FAVOURITES	USERKEY	INTEGER	4	No
	HWKEY	INTEGER	4	No

Table 11. GROUPASSET table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPASSET	GAKEY	INTEGER	4	No
	NAME	VARCHAR	50	Yes
	GADESC	VARCHAR	1024	Yes
	ASSETPERMDEFKEY	INTEGER	4	Yes
	CREATED	TIMESTAMP	10	Yes

Table 12. GROUPASSETGROUPMEMBER table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPASSETGROUPMEMBER	GAKEY	INTEGER	4	No
	GAPARENTKEY	INTEGER	4	No

Table 13. GROUPASSETMEMBER table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPASSETMEMBER	GAKEY	INTEGER	4	No
	GAPARENTKEY	INTEGER	4	No

Table 14. GROUPATTRIBUTES table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPATTRIBUTES	ATT_DEFN	INTEGER	4	No
	GROUPTYPE	INTEGER	4	No
	GROUPKEY	INTEGER	4	No
	STR_VALUE	VARCHAR	255	Yes
	INT_VALUE	INTEGER	4	Yes

Table 15. GROUPATTRIBUTEDEFNS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPATTRIBUTEDEFNS	ATT_DEFN_KEY	INTEGER	4	No
	GROUPTYPE	INTEGER	4	No
	ATT_INTERNAL_NAME	VARCHAR	100	No
	ATT_NAME	VARCHAR	100	No
	ATT_DESC	VARCHAR	1024	Yes
	ATT_LABEL_PROP	VARCHAR	100	Yes
	ATT_DATA_TYPE	INTEGER	4	No
	ATT_RULE	INTEGER	4	No

Table 16. GROUP_HOMEPAGE table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUP_HOMEPAGE	GHKEY	INTEGER	4	No
	GROUPKEY	INTEGER	4	No
	CUSTOM_QUERYKEY	INTEGER	4	Yes
	LAST_UPDATED	TIMESTAMP	10	No

Table 17. GROUPUSERGROUPMEMBER table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUPUSERGROUPMEMBER	GROUPKEY	INTEGER	4	No
	GUPARENTKEY	INTEGER	4	No

Table 18. GROUP_MEMBERS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
GROUP_MEMBERS	GROUPKEY	INTEGER	4	No
	USERKEY	INTEGER	4	No

Table 19. LIVEPOINTS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
LIVEPOINTS	HWKEY	INTEGER	4	No
	PORT	INTEGER	4	No
	HOSTNAME	VARCHAR	64	Yes
	DOMAIN_NAME	VARCHAR	64	Yes
	CUSTOM1	VARCHAR	128	Yes
	CUSTOM2	VARCHAR	128	Yes
	CUSTOM3	VARCHAR	128	Yes
	IP_ADDRESS	VARCHAR	64	Yes
	LOGGED_USER	VARCHAR	48	Yes
	USER_LANGUAGE	VARCHAR	48	Yes
	OS_NAME	VARCHAR	50	Yes
	OS_LANGUAGE	VARCHAR	48	Yes
	TIMEZONE	VARCHAR	48	Yes
	SCREENSAVER	VARCHAR	300	Yes
	RC_STATE	VARCHAR	128	Yes
	RC_CONTROLLER	VARCHAR	128	Yes
	CUSTOM_REGKEY	VARCHAR	128	Yes
	INT_MODE	VARCHAR	48	Yes
	ENDPOINT_ID	VARCHAR	64	Yes
	TARGET_ID	VARCHAR	64	Yes
	LAST_UPDATE	VARCHAR	10	Yes

Table 20. MENU_ACTIONS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
MENU_ACTIONS	QUERYKEY	INTEGER	4	No
	MENU	VARCHAR	30	No
	NAME	VARCHAR	30	No
	COL1	VARCHAR	60	No
	COL2	VARCHAR	60	No
	COL3	VARCHAR	60	No
	COL4	VARCHAR	60	No
	MENU_ACTION	VARCHAR	150	Yes
	LOGO	VARCHAR	40	Yes
	MULTIPLE	VARCHAR	15	No
	CLICK_TYPE	CHARACTER	1	No
	DESCRIPTION	VARCHAR	200	Yes
	AUTHORITY	CHARACTER	1	No
	AUTH_PROPERTY	VARCHAR	100	Yes

Table 21. MENU_LINKS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
MENU_LINKS	QUERYKEY	INTEGER	4	No
	MENU	VARCHAR	30	No
	COL1	VARCHAR	60	No
	COL2	VARCHAR	60	No
	COL3	VARCHAR	60	No
	COL4	VARCHAR	60	No
	MULTIPLE	VARCHAR	15	Yes
	QUERYKEY2	INTEGER	4	No

Table 22. MENU_STATIC_ITEMS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
MENU_STATIC_ITEMS	MENUKEY	INTEGER	4	No
	MENU	VARCHAR	30	Yes
	SUB_MENU	VARCHAR	30	Yes
	NAME	VARCHAR	60	No
	MENU_URL	VARCHAR	150	Yes
	LOGO	VARCHAR	40	Yes
	DESCRIPTION	VARCHAR	200	Yes
	PRIORITY	INTEGER	4	No
	AUTHORITY	CHARACTER	1	No
	AUTH_PROPERTY	VARCHAR	100	Yes
	CONDITIONS	VARCHAR	50	Yes
	CLICK_TYPE	CHARACTER	1	No

Table 23. MENU_STATIC_LINKED_ITEMS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
MENU_STATIC_LINKED_ITEMS	QUERYKEY	INTEGER	4	No
	MENU	VARCHAR	30	No
	MENU_NAME	VARCHAR	30	No
	NAME	VARCHAR	30	No
	COL1	VARCHAR	60	No
	COL2	VARCHAR	60	No
	COL3	VARCHAR	60	No
	COL4	VARCHAR	60	No
	DESCRIPTION	VARCHAR	200	Yes
	AUTHORITY	CHARACTER	1	No
	AUTH_PROPERTY	VARCHAR	100	Yes

Note: This table may be removed in future releases.

Table 24. ORGANISATION table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
ORGANISATION	ORGKEY	INTEGER	4	No
	DEPT_ID	VARCHAR	50	No
	NAME	VARCHAR	128	No
	REAL_DEPT	VARCHAR	250	Yes
	REAL_DEPT_ID	VARCHAR	100	Yes
	PARENT_ORGKEY	INTEGER	4	No
	PARENT_DEPT_ID	VARCHAR	50	Yes
	OWNER_USERKEY	INTEGER	4	No
	OWNER_EMPLOYEEID	VARCHAR	50	Yes
	"TYPE"	VARCHAR	128	Yes
	ADDRESS_1	VARCHAR	128	Yes
	ADDRESS_2	VARCHAR	128	Yes
	CITY	VARCHAR	128	Yes
	STATE	VARCHAR	128	Yes
	POSTCODE	VARCHAR	10	Yes
	COUNTRY	VARCHAR	128	Yes
	CLOSE_STATUS	SMALLINT	2	No
	OPEN_DATE	TIMESTAMP	10	No
	CLOSE_DATE	TIMESTAMP	10	Yes

Table 25. PASSWORDS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
PASSWORDS	USERKEY	INTEGER	4	No
	PASSWORD	VARCHAR	100	No
	UPDATED	TIMESTAMP	10	No

Table 26. PERMISSIONS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
PERMISSIONS	PERMISSIONKEY	INTEGER	4	No
	DEFAULTEXPLICIT	INTEGER	4	No
	GROUPKEY	INTEGER	4	No
	GAKEY	INTEGER	4	Yes
	ACTIONKEY	INTEGER	4	No
	DENYACCEPT	INTEGER	4	No
	START_DATE	TIMESTAMP	10	Yes
	END_DATE	TIMESTAMP	10	Yes
	REPEATS	INTEGER	4	Yes
	WEEK_DAYS	VARCHAR	40	Yes
	STR_VALUE	VARCHAR	255	Yes
	INT_VALUE	INTEGER	4	Yes
	LIVE_STATE	INTEGER	4	Yes

Table 27. PERMISSIONSET table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
PERMISSIONSET	ACTIONKEY	INTEGER	4	No
	ACTIONSTATE	INTEGER	4	No
	INT_VALUE	INTEGER	4	Yes
	LIVE_STATE	INTEGER	4	Yes
	PRIORITYLEVEL	INTEGER	4	Yes
	SETNAMEKEY	INTEGER	4	Yes
	STR_VALUE	VARCHAR	10	Yes

Table 28. PERMISSIONSETNAMES table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
PERMISSIONSETNAMES	CREATED	TIMESTAMP	10	No
	SETNAME	VARCHAR	80	Yes
	SETNAMEKEY	INTEGER	4	No

Table 29. QUERY table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
QUERY	QUERYKEY	INTEGER	4	No
	NAME	VARCHAR	50	No
	DESCRIPTION	VARCHAR	120	Yes
	SQL_DATA	CLOB	524288	No
	FONTSIZE	INTEGER	4	No
	AUTHORITY	CHARACTER	1	No
	DISPLAY	INTEGER	4	No
	REFRESH	INTEGER	4	No
	CREATOR	VARCHAR	20	Yes
	CREATED	TIMESTAMP	10	No

Table 30. QUERY_COL_INFO table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
QUERY_COL_INFO	QUERYKEY	INTEGER	4	No
	NAME	VARCHAR	30	No
	DISPLAYCOL	INTEGER	4	No
	DISPLAYDATA	INTEGER	4	No
	"ALIAS"	VARCHAR	30	Yes
	ACTION1	VARCHAR	150	Yes
	ACTION2	VARCHAR	150	Yes
	ACTION3	VARCHAR	150	Yes
	ACTION_LOGO	VARCHAR	20	Yes
	ACTION_LOGO2	VARCHAR	20	Yes
	ACTION_LOGO3	VARCHAR	20	Yes
	ACTION_POPUP	VARCHAR	200	Yes
	ACTION_POPUP2	VARCHAR	200	Yes
	ACTION_POPUP3	VARCHAR	200	Yes
	COLOUR	VARCHAR	10	Yes
	ALIGN	VARCHAR	10	Yes
	SUMMARY	VARCHAR	10	Yes
	POPUP	VARCHAR	200	Yes
	DELETEABLE	INTEGER	4	Yes
	AUTHORITY	CHARACTER	1	No

Table 31. QUERY_GROUP table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
QUERY_GROUP	QUERYKEY	INTEGER	4	No
	GROUP_NAME	VARCHAR	50	No

Table 32. REMOTE_INSTALL table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
REMOTE_INSTALL	INSTALLKEY	INTEGER	4	No
	USERKEY	INTEGER	4	No
	INSTALL_TIME	TIMESTAMP	10	No
	TARGET	VARCHAR	100	No
	TARGET_USER	VARCHAR	40	No
	TARGET_PLATFORM	CHAR	7	No
	TARGET_GROUP	VARCHAR	40	No
	SERVER_URL	VARCHAR	200	No
	LISTENING_PORT	INTEGER	4	No
	INSTALL_FOLDER	VARCHAR	255	No
	TEMP_FOLDER	VARCHAR	255	No
	USE_FIPS	INTEGER	4	No
	ALLOW_P2P	INTEGER	4	No
	ALLOW_P2P_FAILOVER	INTEGER	4	No
	PROXY_ADDRESS	VARCHAR	200	Yes
	PROXY_PORT	INTEGER	4	Yes
	PROXY_USER	VARCHAR	40	Yes
	STATUS	VARCHAR	20	No
	ERROR	CLOB	Unlimited	Yes

Table 33. SESSIONS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSIONS	SESSIONKEY	INTEGER	4	No
	USERKEY	INTEGER	4	No
	HWKEY	INTEGER	4	No
	REQUEST_TIME	TIMESTAMP	10	Yes
	START_TIME	TIMESTAMP	10	Yes
	END_TIME	TIMESTAMP	10	Yes
	DESCRIPTION	VARCHAR	512	Yes

Table 34. SESSIONS_ACTIVE table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSIONS_ACTIVE	SESSIONKEY	INTEGER	4	No
	SESSION_TOKEN	VARCHAR	265	Yes
	CONTROLLER_NAME	VARCHAR	256	Yes
	HWKEY	INTEGER	4	No
	STATUS	SMALLINT	2	No
	COLLAB_IP	VARCHAR	255	Yes
	COLLAB_PORT	INTEGER	4	Yes

Table 35. SESSION_AUDIT table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSION_AUDIT	AUDITEVENTKEY	INTEGER	4	No
	SESSIONKEY	INTEGER	4	No
	LOCALTIMESTAMP	TIMESTAMP	10	Yes
	ORIGINATOR	SMALLINT	2	Yes
	EVENTID	VARCHAR	25	Yes
	ARGUMENT0	VARCHAR	255	Yes
	ARGUMENT1	VARCHAR	255	Yes
	ARGUMENT2	VARCHAR	255	Yes
	ARGUMENT3	VARCHAR	255	Yes
	ARGUMENT4	VARCHAR	255	Yes
	ARGUMENT5	VARCHAR	255	Yes
	ARGUMENT6	VARCHAR	255	Yes
	ARGUMENT7	VARCHAR	255	Yes
	ARGUMENT8	VARCHAR	255	Yes
	ARGUMENT9	VARCHAR	255	Yes

Table 36. SESSION_BROKER table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSION_BROKER	SESSIONID	VARCHAR	64	No
	REQ_USERID	INTEGER	4	No
	REQ_IP	VARCHAR	64	Yes
	TARGET_HWKEY	INTEGER	4	No
	REQ_TIME	TIMESTAMP	10	Yes

Table 37. SESSION_POLICIES table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSION_POLICIES	SESSIONKEY	INTEGER	4	No
	POLICY_NAME	VARCHAR	25	No
	POLICY_VALUE	VARCHAR	25	Yes

Table 38. SESSION_RECORDING table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
SESSION_RECORDING	RECORDINGKEY	INTEGER	4	No
	SESSIONKEY	INTEGER	4	No
	FILENAME	VARCHAR	255	Yes

Table 39. TRANSLATIONS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
TRANSLATIONS	NAME	VARCHAR	48	No
	"LOCALE"	VARCHAR	16	No
	VALUE	VARCHAR	128	No

Table 40. TRUSTED_CERTS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
TRUSTED_CERTS	SUBJECT	VARCHAR	256	No
	PEM_DATA	VARCHAR	1500	No
	CERTKEY	INTEGER	4	No

Table 41. USERPERMISSIONSDEFAULT table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USERPERMISSIONSDEFAULT	USERPERMDEFKEY	INTEGER	4	No
	ACTIONKEY	INTEGER	4	No
	ACTIONSTATE	INTEGER	4	Yes
	INT_VALUE	INTEGER	4	Yes
	STR_VALUE	VARCHAR	255	Yes

Table 42. USERPERMISSIONSDEFAULTNAME table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USERPERMISSIONSDEFAULTNAME	USERPERMDEFKEY	INTEGER	4	No
	DEFDESC	VARCHAR	1024	Yes

Table 43. USERS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USERS	USERKEY	INTEGER	4	No
	USERID	VARCHAR	70	No
	EMAIL	VARCHAR	70	No
	TITLE	VARCHAR	5	Yes
	FORENAME	VARCHAR	30	Yes
	SURNAME	VARCHAR	30	Yes
	INITIALS	VARCHAR	30	Yes
	NICKNAME	VARCHAR	30	Yes
	COMPANY	VARCHAR	40	Yes
	LOCATION	VARCHAR	60	Yes
	DEPARTMENT	VARCHAR	60	Yes
	FLOOR	VARCHAR	40	Yes
	ROOM	VARCHAR	40	Yes
	TEAM	VARCHAR	60	Yes
	ORG	VARCHAR	60	Yes
	EMPLOYEEID	VARCHAR	30	Yes
	MAILPOINT	VARCHAR	10	Yes
	ADDRESS_1	VARCHAR	100	Yes
	ADDRESS_2	VARCHAR	100	Yes
	TOWN	VARCHAR	40	Yes
	POSTCODE	VARCHAR	10	Yes
	COUNTRY	VARCHAR	25	Yes
	STATE	VARCHAR	25	Yes
	REGION	VARCHAR	25	Yes
	TEL_NO	VARCHAR	25	Yes
	MOB_NO	VARCHAR	25	Yes
	CID	VARCHAR	8	Yes
	BUILDING	VARCHAR	64	Yes
	CITY	VARCHAR	64	Yes
	GEO	VARCHAR	64	Yes
	AUTHORITY	CHARACTER	1	Yes
	COST_CENTRE	VARCHAR	30	Yes
	"LOCALE"	VARCHAR	30	Yes
	PASSWORD	VARCHAR	100	No
	EXPIRED	CHARACTER	1	No
	DEMOGRAPHICS_STALE	INTEGER	4	No
	PASSWORD_CHANGED	TIMESTAMP	10	Yes
	LAST_UPDATE	TIMESTAMP	10	Yes
	CREATED	TIMESTAMP	10	No
	ASSIGNMENT_DATE	TIMESTAMP	10	Yes
	START_DATE	TIMESTAMP	10	Yes

Table 44. USER_ACCESS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_ACCESS	USERKEY	INTEGER	4	No
	SUCCESS	INTEGER	4	Yes
	DATE_TIME	TIMESTAMP	10	No

Table 45. USER_ACCOUNTS table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_ACCOUNTS	HWKEY	INTEGER	4	No
	REVISION	INTEGER	4	No
	USERID	VARCHAR	100	No
	USERNAME	VARCHAR	100	Yes
	PW_SET	VARCHAR	7	Yes
	PW_AGE	INTEGER	4	Yes
	USER_PRIVILEGE	VARCHAR	100	Yes
	DISABLED	VARCHAR	7	Yes
	PW_NOT_REQUIRED	VARCHAR	5	Yes
	CANNOT_CHANGE_PW	VARCHAR	5	Yes
	LOCKED_OUT	VARCHAR	5	Yes
	PW_NEVER_EXPIRES	VARCHAR	5	Yes
	PW_EXPIRED	VARCHAR	5	Yes

Table 46. USER_AUTHENTICATION_KEY table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_AUTHENTICATION_KEY	USERKEY	INTEGER	4	No
	KEY_TYPE	INTEGER	4	No
	UNIQUE_KEY	VARCHAR	50	Yes
	CREATED	TIMESTAMP	10	No

Table 47. USER_AUTHORITY table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_AUTHORITY	USERKEY	INTEGER	4	No
	AUTHTYPE	VARCHAR	20	No
	AUTHORITY	CHARACTER	1	No

Table 48. USER_GROUP table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_GROUP	GROUPKEY	INTEGER	4	No
	NAME	VARCHAR	50	No
	DESCRIPTION	VARCHAR	128	Yes
	HASRULE	SMALLINT	2	No
	RULE	VARCHAR	128	Yes
	CREATED	TIMESTAMP	10	No
	USERPERMDEFKEY	INTEGER	4	Yes

Table 49. USER_INFO table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_INFO	USERKEY	INTEGER	4	No
	CUSTOM1	VARCHAR	250	Yes
	CUSTOM2	VARCHAR	250	Yes
	CUSTOM3	VARCHAR	250	Yes
	CUSTOM4	VARCHAR	250	Yes
	CUSTOM5	VARCHAR	250	Yes
	CUSTOM6	VARCHAR	250	Yes
	CUSTOM7	VARCHAR	250	Yes
	CUSTOM8	VARCHAR	250	Yes
	CUSTOM9	VARCHAR	250	Yes

Table 50. USER_PREFERENCE table
TABLE NAME	COLUMN NAME	TYPE NAME	LENGTH	NULLS
USER_PREFERENCE	USERKEY	INTEGER	4	No
	ATTRIBUTE	VARCHAR	100	No
	VALUE	VARCHAR	100	No