CSO_SITE_USER_GRPS

This table associates a user group (tag) with a specific repository and/or view.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SITE_USER_GRPS_PK

TAG_ID, SITE_ID

Columns

Name Datatype Length Not-null Comments
TAG_ID VARCHAR2 32 Yes This is the Reference to Tag table, containing a user group.
SITE_ID VARCHAR2 32 Yes This is the Reference to the Site table.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_SITE_USER_GRPS cso_site SITE_ID
CSO_SITE_USER_GRPS cso_tag TAG_ID

Indexes

Index Uniqueness Columns
CSO_SITE_USER_GRPS_U1 Unique TAG_ID, SITE_ID
CSO_SITE_USER_GRPS_N1 Non Unique SITE_ID