ZSO_PRESENTATION_SESSIONS
This table represents a session during which one or more Lighbox Documents or one or more Content Sets are presented. The session may optionally take place for an appointment, and may optionally take place for an account. In some cases, the presentation may be ad hoc, which may be related to neither an account nor an appointment, but will be identified only by a date and time.
Details
-
Schema: FUSION
-
Object owner: ZSO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZSO_PRES_SESSIONS_PK |
PRESENTATION_SESSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRESENTATION_SESSION_ID | NUMBER | 18 | Yes | ID column: the uniquely identifying surrogate key value. | |
| SESSION_DATE | TIMESTAMP | Yes | The date and time that the Presentation Session took place. | ||
| ACTIVITY_ID | NUMBER | 18 | Appointment for which the Presentation Session has been generated, if applicable. | ||
| ACCOUNT_ID | NUMBER | 18 | Account for which the Presentation Session has been generated, if applicable. | ||
| SESSION_OWNER_ID | NUMBER | 18 | Yes | The session owner will be default from the Activity Owner for actvity-based presentation sessions, and from the current logged in user for ad-hoc presentation sessions. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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_presentation_sessions | PRESENTATION_SESSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZSO_PRESENTATION_SESSIONS_N1 | Non Unique | Default | SESSION_OWNER_ID, "SESSION_DATE" |
| ZSO_PRESENTATION_SESSIONS_N2 | Non Unique | Default | ACTIVITY_ID, "SESSION_DATE", SESSION_OWNER_ID |
| ZSO_PRESENTATION_SESSIONS_N3 | Non Unique | Default | ACCOUNT_ID, "SESSION_DATE", SESSION_OWNER_ID |
| ZSO_PRESENTATION_SESSIONS_U1 | Unique | Default | PRESENTATION_SESSION_ID |
| ZSO_PRES_SESSIONS_U1 | Unique | Default | SESSION_DATE, ACTIVITY_ID |