CSO_XML_ATTRIBUTE_USER_GRP

This table contains the user groups available for a specific channel attribute used for securing data on an individual attribute basis.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_XML_ATTRIBUTE_USER_GRP_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
DEFAULT_VALUE	NUMBER			Flag indicating if the user group should be selected by default (1=yes, 0=no)
ATTRIBUTE_ID	VARCHAR2	32	Yes	This is the GUID for the attribute the user group is available for.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
TAG_ID	VARCHAR2	32	Yes	This is the Reference to Tag table, containing the user group.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_XML_ATTRIBUTE_USER_GRP	cso_schema_attribute	ATTRIBUTE_ID
CSO_XML_ATTRIBUTE_USER_GRP	cso_tag	TAG_ID

Indexes

Index	Uniqueness	Columns
CSO_XML_ATTRIBUTE_USER_GRP_U1	Unique	RECORD_ID
CSO_XML_ATTRIBUTE_USER_GRP_N1	Non Unique	ATTRIBUTE_ID
CSO_XML_ATTRIBUTE_USER_GRP_N2	Non Unique	TAG_ID