fw group
Database Table
| Name | fw_group |
| Prefix | grp |
| Group Item | Admin module, Group |
| Initial Build | 2006.02 |
Overview
fw_group is a security table. It stores the name and description for each netFORUM Security Group.
Columns
| Name | Description | Datatype | Notes |
|---|---|---|---|
| grp_key | Unique Key | av_key | |
| grp_code | Group | nvarchar(50) | |
| grp_descr | Description | nvarchar(80) | |
| grp_add_user | Add User | av_user | |
| grp_add_date | Add Date | av_date | |
| grp_change_date | Change Date | av_date | |
| grp_change_user | Change User | av_user | |
| grp_delete_flag | Delete Flag | av_delete_flag | |
| grp_entity_key | Entity Key | av_key |
Child Tables
| Child Table | Parent Key | Child Key | Join |
|---|---|---|---|
| ac_batch_x_fw_group | grp_code | bgr_grp_code | bgr_grp_code = grp_code |
| co_demographic_x_fw_group | grp_key | dmx_grp_key | dmx_grp_key = grp_key |
| fw_group_table_privilege | grp_code | gtp_grp_code | gtp_grp_code = grp_code |
| fw_group_x_link | grp_code | fgl_grp_code | fgl_grp_code = grp_code |
| fw_user_x_group | grp_code | uxg_grp_code | uxg_grp_code = grp_code |
| md_dynamic_form_child_x_group | grp_code | cgx_grp_code | cgx_grp_code = grp_code |
| md_query_x_group_deny | grp_key | qxg_grp_key | qxg_grp_key = grp_key |
| md_search_table_x_group | grp_code | sxg_grp_code | sxg_grp_code = grp_code |