responses

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
response_id VARCHAR 255 null
phenomenons.response_id phenomenons_response_id_foreign N
response_phenomenoms.response_phenomenon_id response_phenomenoms_response_phenomenon_id_foreign C
prompt_id VARCHAR 255 null
elicitation_prompts.elicitation_prompt_id responses_prompt_id_foreign R
location_id VARCHAR 255 null
locations.location_id responses_location_id_foreign R
elicited_form VARCHAR 255 null
entry_variant_id VARCHAR 255 √ null
elicited_entry_id VARCHAR 255 null
entries.entry_id responses_elicited_entry_id_foreign R
response_type VARCHAR 255 √ null
speaker_id VARCHAR 255 null
speakers.speaker_id responses_speaker_id_foreign R
origin_source_id VARCHAR 255 null
sources.source_id responses_origin_source_id_foreign R
year INT 10 √ null
certainty_id VARCHAR 255 √ null
certainty_labels.certainty_labels_id responses_certainty_id_foreign N
comment TEXT 65535 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc response_id
responses_certainty_id_foreign Performance Asc certainty_id
responses_elicited_entry_id_foreign Performance Asc elicited_entry_id
responses_location_id_foreign Performance Asc location_id
responses_origin_source_id_foreign Performance Asc origin_source_id
responses_prompt_id_foreign Performance Asc prompt_id
responses_speaker_id_foreign Performance Asc speaker_id

Relationships

Close relationships within degrees of separation