cm group

Database Table

Name	cm_group
Prefix	cgr
Group Item	Content Group
Initial Build	2006.02

Overview

cm_group is a navigation metadata table. It is used to store information about Content Groups (NetForum Modules).

Columns

Name	Description	Datatype	Notes
cgr_key	Unique Key	av_key
cgr_code	Group Name	nvarchar(50)
cgr_description	Group Description	nvarchar(100)
cgr_order	Group Order	av_integer
cgr_cssfile	CSS File	nvarchar(50)
cgr_icon	Icon File	nvarchar(50)
cgr_add_date	Add Date	av_date
cgr_add_user	Add User	av_user
cgr_change_date	Change Date	av_date
cgr_change_user	Change User	av_user
cgr_delete_flag	Delete Flag	av_delete_flag
cgr_entity_key	Entity Key	av_key

Child Tables

Child Table	Parent Key	Child Key	Join
cm_group_item	cgr_key	cgi_cgr_key	cgi_cgr_key = cgr_key
cm_group_item_link	cgr_key	cgl_cgr_key	cgl_cgr_key = cgr_key