elicitation_prompts

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elicitation_prompt_id VARCHAR 255 null
prompt_elicits.prompt_id prompt_elicits_prompt_id_foreign C
responses.prompt_id responses_prompt_id_foreign R
prompt VARCHAR 255 null
prompt_type_id VARCHAR 255 null
prompt_types.prompt_type_id elicitation_prompts_prompt_type_id_foreign R
origin_source_id VARCHAR 255 null
sources.source_id elicitation_prompts_origin_source_id_foreign R
language_id VARCHAR 255 √ null
languages.language_id elicitation_prompts_language_id_foreign R
comment TEXT 65535 √ null
description 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 elicitation_prompt_id
elicitation_prompts_language_id_foreign Performance Asc language_id
elicitation_prompts_origin_source_id_foreign Performance Asc origin_source_id
elicitation_prompts_prompt_type_id_foreign Performance Asc prompt_type_id

Relationships

Close relationships within degrees of separation