cm group item

Database Table

Name	cm_group_item
Prefix	cgr
Group Item	Group Item
Initial Build	2006.02

Overview

cm_group_item is a navigation metadata table. It is used to store information about (Content) Group Items.

Columns

Name	Description	Datatype	Notes
cgi_key	Item Key	av_key
cgi_cgr_key	Group Key	av_key
cgi_code	Item Code	nvarchar(50)
cgi_description	Item Description	nvarchar(100)
cgi_order	Item Order	av_integer
cgi_add_date	Add Date	av_date
cgi_add_user	Add User	av_user
cgi_change_date	Change Date	av_date
cgi_change_user	Change User	av_user
cgi_delete_flag	Delete Flag	av_delete_flag
cgi_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
cm_group	cgr_key	cgi_cgr_key	cgi_cgr_key = cgr_key

Child Tables

Child Table	Parent Key	Child Key	Join
cm_group_item_link	cgi_key	cgl_cgi_key	cgl_cgi_key = cgi_key
cm_group_item_link	cgi_cgr_key	cgl_cgr_key	cgl_cgr_key = cgi_cgr_key