CSO_NEWSLETTER

This table contains the definitions for newsletters. Newsletters are URLs to pages that get emailed to subscribers of the newsletters.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_NEWSLETTER_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
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.
OWNER_SITE_ID	VARCHAR2	32	Yes	This is the GUID reference to the repository that owns the newsletter.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	100	Yes	Locale independent name for the record. Translated localized versions of the reference key are stored in property files and in table with names ending in RESOURCe.
HTML_URL	VARCHAR2	255		The URL of the HTML formatted version of the newsletter.
TEXT_URL	VARCHAR2	255		The URL of the text formatted version of the newsletter.
SUBJECT	VARCHAR2	100		The email subject of the newsletter that is sent out.
FROM_EMAIL	VARCHAR2	100		The email address that will appear as the sender of the newsletter.
CHANNEL_ALERT	CHAR	1		Flag indicating if the newsletter is really a channel alert subscription.
DATE_LAST_SENT	TIMESTAMP			Datetime when the last email newsletter was sent out.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_NEWSLETTER	cso_site	OWNER_SITE_ID
cso_survey_result_newslet	cso_newsletter	NEWSLETTER_ID
cso_newsletter_site	cso_newsletter	NEWSLETTER_ID
cso_newsletter_res	cso_newsletter	NEWSLETTER_ID
cso_channel_newsletter	cso_newsletter	NEWSLETTER_ID
cso_newsletter_survey	cso_newsletter	NEWSLETTER_ID

Indexes

Index	Uniqueness	Columns
CSO_NEWSLETTER_U1	Unique	RECORD_ID
CSO_NEWSLETTER_N1	Non Unique	OWNER_SITE_ID