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