CSO_SURVEY
This table contains surveys (dataforms)
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_SURVEY_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ALLOW_MULTIPLE_RE_TAKES | CHAR | 1 | A flag indicating if a user can take the survey multiple times. | ||
| 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. | ||
| DISPLAY_END_DATE | TIMESTAMP | Yes | This has been deprecated from the schema. | ||
| DISPLAY_START_DATE | TIMESTAMP | Yes | This has been deprecated from the schema. | ||
| PUBLISHED | CHAR | 1 | A flag indicating the survey is published. | ||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| SITE_ID | VARCHAR2 | 32 | Yes | This is the GUID for the repository or view the survey is associated with | |
| SURVEY_TYPE_ID | VARCHAR2 | 32 | Yes | This is the GUID to the type of servey. | |
| 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. | |
| USER_ID | VARCHAR2 | 32 | This is the obsolete GUID for the user associated with this record. | ||
| EMAIL_CONTENT | CHAR | 1 | A flag indicating that the answer content should be included in the email notification. | ||
| RATING_TYPE | NUMBER | 0=custom rating (the old way of doing ratings), 1=YES rating, 2=YES/NO rating, 3=3 stars, 4=5 stars. | |||
| REVERSE_RATING_ORDER | NUMBER | Indicator that controls the display order of the rating. 1=reverse order, 0=ascending order. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| USER_PARTY_ID | NUMBER | 18 | This is the ID of the user associated with this record. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_SURVEY | cso_site | SITE_ID |
| CSO_SURVEY | cso_lookup_code | SURVEY_TYPE_ID |
| cso_user_survey_emails | cso_survey | SURVEY_ID |
| cso_survey_site | cso_survey | SURVEY_ID |
| cso_survey_question | cso_survey | SURVEY_ID |
| cso_survey_result | cso_survey | SURVEY_ID |
| cso_survey_privilege | cso_survey | SURVEY_ID |
| cso_discussion_board | cso_survey | TOPIC_RATING_ID |
| cso_discussion_board | cso_survey | MESSAGE_RATING_ID |
| cso_newsletter_survey | cso_survey | SURVEY_ID |
| cso_channel | cso_survey | SURVEY_ID |
| cso_survey_res | cso_survey | SURVEY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_SURVEY_N1 | Non Unique | Default | SITE_ID, SURVEY_TYPE_ID |
| CSO_SURVEY_N2 | Non Unique | Default | SURVEY_TYPE_ID |
| CSO_SURVEY_N3 | Non Unique | Default | USER_PARTY_ID |
| CSO_SURVEY_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_SURVEY_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |