fw user x group

Database Table

Name	fw_user_x_group
Prefix	uxg
Group Item	User Group
Initial Build	2006.02

Overview

User Group

Columns

Name	Description	Datatype	Notes
uxg_key	Unique Key	av_key
uxg_usr_code	User Name	av_user
uxg_grp_code	Group Name	nvarchar(50)
uxg_add_date	Add Date	av_date_small
uxg_add_user	Add User	av_user
uxg_change_date	Change Date	av_date_small
uxg_change_user	Change User	av_user
uxg_delete_flag	Delete Flag	av_delete_flag
uxg_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
fw_group	grp_code	uxg_grp_code	uxg_grp_code = grp_code
fw_user	usr_code	uxg_usr_code	uxg_usr_code = usr_code