user_input_line |
Survey User Input Line
Catalog: Odoo
Schema: survey
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table user_input_line are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
answer_is_correct |
boolean |
Correct |
☐ |
|
answer_score |
decimal |
Score |
☐ |
|
answer_type |
string |
Answer Type |
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
matrix_row_id_label |
string |
|
☐ |
|
matrix_row_id |
string |
|
☐ |
|
page_id_label |
string |
|
☐ |
|
page_id |
string |
|
☐ |
|
question_id_label |
string |
|
☐ |
|
question_id |
string |
|
☐ |
|
question_sequence |
int32 |
Sequence |
☐ |
|
skipped |
boolean |
Skipped |
☐ |
|
suggested_answer_id_label |
string |
|
☐ |
|
suggested_answer_id |
string |
|
☐ |
|
survey_id_label |
string |
|
☐ |
|
survey_id |
string |
|
☐ |
|
user_input_id_label |
string |
|
☐ |
|
user_input_id |
string |
|
☐ |
|
value_char_box |
string |
Text answer |
☐ |
|
value_date |
datetime |
Date answer |
☐ |
|
value_datetime |
datetime |
Datetime answer |
☐ |
|
value_numerical_box |
decimal |
Numerical answer |
☐ |
|
value_text_box |
string |
Free Text answer |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826