Medallia
Explore the interactive ERD
Table & Field Reference
survey_program
| Column | Type | Keys |
|---|
id | String | PK |
activation_date | Instant | |
modified_by | String | |
modified_on | Instant | |
name | String | |
unit
| Column | Type | Keys |
|---|
id | Long | PK |
identifier | String | PK |
city | String | |
name | String | |
postal_code | String | |
street_address | String | |
timezone | String | |
group
| Column | Type | Keys |
|---|
id | String | PK |
name | String | |
unit_group
| Column | Type | Keys |
|---|
group_id | String | PKFK |
unit_id | Long | PKFK |
feedback_topic
| Column | Type | Keys |
|---|
_fivetran_id | String | PK |
feedback_id | Long | FK |
question_id | String | FK |
comment | String | |
topic_id | Long | |
topic_name | String | |
feedback_theme
| Column | Type | Keys |
|---|
_fivetran_id | String | PK |
feedback_id | Long | FK |
question_id | String | FK |
comment | String | |
theme_id | Long | |
theme_name | String | |
feedback_answer
| Column | Type | Keys |
|---|
feedback_id | Long | PKFK |
question_id | String | PKFK |
value | String | PKFK |
rank | Int | |
feedback_theme_region
| Column | Type | Keys |
|---|
end_index | Int | PK |
start_index | Int | PK |
feedback_theme_id | String | PKFK |
value | String | |
feedback_history
| Column | Type | Keys |
|---|
id | Long | PK |
a_unit_identifier | String | FK |
e_accepteddate | Instant | |
e_creationdate | Instant | |
e_expirationdate | Instant | |
e_lastupdated | Instant | |
e_responsedate | Instant | |
e_status | String | |
e_survey_method | String | |
e_survey_source | String | |
feedback_topic_region
| Column | Type | Keys |
|---|
end_index | Int | PK |
start_index | Int | PK |
feedback_topic_id | String | PKFK |
value | String | |
feedback_sentiment_region
| Column | Type | Keys |
|---|
end_index | Int | PK |
start_index | Int | PK |
feedback_sentiment_id | String | PKFK |
value | String | |
field_option
| Column | Type | Keys |
|---|
id | String | PK |
field_id | String | PKFK |
name | String | |
numeric_value | Int | |
feedback_sentiment
| Column | Type | Keys |
|---|
_fivetran_id | String | PK |
feedback_id | Long | FK |
question_id | String | FK |
comment | String | |
sentiment | String | |
field_meta_data
| Column | Type | Keys |
|---|
id | String | PK |
data_type | String | |
filterable | Boolean | |
multivalued | Boolean | |
name | String | |
survey_question
| Column | Type | Keys |
|---|
program_id | String | PKFK |
question_id | String | PKFK |
text | String | |
