CSO_SUBSCRIPTION
List of documents a user is subscribed to.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_SUBSCRIPTION_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACTIVE | CHAR | 1 | Yes | Flag indicating whether this subscription is active or not. | |
| CHANNEL_ID | VARCHAR2 | 32 | This is the channel id for this record. | ||
| CONTENT_ID | VARCHAR2 | 32 | This is the content id for this record. | ||
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime that the record was added to the repository. | ||
| DATE_MODIFIED | TIMESTAMP | Yes | This is the datetime that the record was modified. | ||
| END_DATE | TIMESTAMP | Yes | This is the datetime the subscription will end on. | ||
| FORUM_ID | VARCHAR2 | 32 | This is the forum id for this record. | ||
| LAST_CRAWL | TIMESTAMP | Yes | The last time this subscription was crawled. | ||
| LAST_MODIFIED_BY | VARCHAR2 | 100 | This is the obsolete GUID of the user that last modified the record. | ||
| NAME | VARCHAR2 | 100 | Yes | This is the user that last modified the record. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| SUBSCRIPTION_TYPE | NUMBER | Yes | This is the type of subscription this is. | ||
| TOPIC_ID | VARCHAR2 | 32 | This is the topic id for this record. | ||
| USER_ID | VARCHAR2 | 32 | The obsolete GUID of the user to which this subscription belongs. | ||
| LOCALE_ID | VARCHAR2 | 32 | The localeid only required if this is a content subscription. | ||
| LAST_MODIFIED_BY_PARTY_ID | NUMBER | 18 | This is the ID of the user that last modified the record. | ||
| USER_PARTY_ID | NUMBER | 18 | The ID of the user to which this subscription belongs. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_SUBSCRIPTION | cso_locale | LOCALE_ID |
| CSO_SUBSCRIPTION | cso_db_topic | TOPIC_ID |
| CSO_SUBSCRIPTION | cso_db_forum | FORUM_ID |
| CSO_SUBSCRIPTION | cso_channel | CHANNEL_ID |
| CSO_SUBSCRIPTION | cso_content | CONTENT_ID |
| cso_subscription_tag | cso_subscription | SUBSCRIPTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_SUBSCRIPTION_N1 | Non Unique | Default | CONTENT_ID |
| CSO_SUBSCRIPTION_N2 | Non Unique | Default | CHANNEL_ID |
| CSO_SUBSCRIPTION_N3 | Non Unique | Default | FORUM_ID |
| CSO_SUBSCRIPTION_N4 | Non Unique | Default | LOCALE_ID |
| CSO_SUBSCRIPTION_N5 | Non Unique | Default | TOPIC_ID |
| CSO_SUBSCRIPTION_N6 | Non Unique | Default | SUBSCRIPTION_TYPE |
| CSO_SUBSCRIPTION_N7 | Non Unique | Default | END_DATE |
| CSO_SUBSCRIPTION_N8 | Non Unique | Default | USER_PARTY_ID |
| CSO_SUBSCRIPTION_U1 | Unique | Default | RECORD_ID |