md search table x group
Important! This table is deprecated. fw_group_security replaces its use within the netFORUM security framework.
Database Table
| Name |
md_search_table_x_group |
| Prefix | sxg |
| Group Item | |
| Initial Build |
Overview
This table is used to restrict access to a Table in the Super Search to a particular security Group.
Columns
| Name | Description | Datatype | Notes |
|---|---|---|---|
| sxg_key | Unique Key | av_key | |
| sxg_grp_code | Group Code | nvarchar(50) | |
| sxg_stb_key | Search Table Key | av_key | |
| sxg_no_access | No Access? | av_flag | |
| sxg_add_user | Add User | av_user | |
| sxg_add_date | Add Date | av_date | |
| sxg_change_user | Change User | av_user | |
| sxg_change_date | Change Date | av_date | |
| sxg_delete_flag | Delete Flag | av_delete_flag | |
| sxg_entity_key | Entity Key | av_key |
Parent Tables
| Parent Table | Parent Key | Child Key | Join |
|---|---|---|---|
| fw_group | grp_code | sxg_grp_code | sxg_grp_code = grp_code |
| md_search_table | stb_key | sxg_stb_key | sxg_stb_key = stb_key |