user_input: Odoo itgen_odoo_user_input
read only per partition
- Catalogo:
Odoo - Schema:
survey - Etichetta: itgen_odoo_user_input
Survey User Input
È possibile solo recuperare i dati.
Riepilogo
Metadata for a set of one user's answers to a particular survey
Colonne della tabella
Di seguito sono riportate le colonne della tabella user_input. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
access_ |
varchar2 |
Identification token | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
attempts_ |
int32 |
Attempts Count | |||
attempts_ |
int32 |
Number of attempts | |||
attempts_ |
int32 |
Attempt n° | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
deadline |
datetime |
Deadline | Datetime until customer can open the survey and submit answers | ||
display_ |
varchar2 |
Nome visualizzato | |||
email |
varchar2 |
||||
end_ |
datetime |
End date and time | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
invite_ |
varchar2 |
Invite token | |||
is_ |
boolean |
Limited number of attempts | Check this option if you want to limit the number of attempts per user | ||
is_ |
boolean |
Is in a Session | Is that user input part of a survey session or not. | ||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
message_ |
int32 |
Numero di allegati | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
nickname |
varchar2 |
Nickname | Attendee nickname, mainly used to identify them in the survey session leaderboard. | ||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
predefined_ |
varchar2 |
||||
question_ |
boolean |
Question Time Limit Reached | |||
scoring_ |
numeric |
Score (%) | |||
scoring_ |
boolean |
Quizz Passed | |||
scoring_ |
numeric |
Punteggio totale | |||
scoring_ |
varchar2 |
Scoring | |||
slide_ |
varchar2 |
The related course slide when there is no membership information | |||
slide_ |
varchar2 |
The related course slide when there is no membership information | |||
slide_ |
varchar2 |
Slide membership information for the logged in user | |||
slide_ |
varchar2 |
Slide membership information for the logged in user | |||
start_ |
datetime |
Start date and time | |||
state |
varchar2 |
Status | |||
survey_ |
varchar2 |
||||
survey_ |
varchar2 |
||||
survey_ |
boolean |
Survey Time Limit Reached | |||
test_ |
boolean |
Test Entry | |||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: