ZSO_SESSION_ATTENDEES

The session attendees table defines individual parties who have attended or may attend a Presentation Session. An individual attending a session may, for example, be a Sales Cloud Contact, or a Sales Cloud Lead. A session attendee will be eligible to give Session Feedback

Details

• Schema: FUSION

• Object owner: ZSO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZSO_SESSION_ATTENDEE_PK	ATTENDEE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ATTENDEE_ID	NUMBER		18	Yes	ID column: the uniquely identifying surrogate key value
ATTENDEE_TYPE	VARCHAR2	32		Yes	Discriminator column that identifies the type of Attendee
PARTY_ID	NUMBER		18	Yes	The party ID for the indicated type of Attendee. For an Attendee Type of 'CONTACT', this will be the Contact Id
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NO	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
zso_session_feedback	zso_session_attendees	ATTENDEE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZSO_SESSION_ATTENDEES_U1	Unique	Default	ATTENDEE_TYPE, PARTY_ID
ZSO_SESSION_ATTENDEES_U2	Unique	Default	ATTENDEE_ID
ZSO_SESSION_ATTENDEES_U3	Unique	Default	PARTY_ID