badge: Odoo itgen_odoo_badge
read only per partition
- Catalog:
Odoo - Schema:
gamification - Label: itgen_odoo_badge
Gamification Badge
Can only retrieve data.
Summary
Badge object that users can send and receive
Table Columns
The columns of the table badge are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
can_ |
boolean |
Can Publish | |||
challenge_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Display Name | |||
goal_ |
varchar2 |
The users that have succeeded these goals will receive automatically the badge. | |||
granted_ |
int32 |
Total | The number of time this badge has been received. | ||
granted_ |
int32 |
Granted Employees Count | |||
granted_ |
int32 |
Number of users | The number of time this badge has been received by unique users. | ||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
image_ |
varbinary |
Image 1024 | |||
image_ |
varbinary |
Image 128 | |||
image_ |
varbinary |
Image | |||
image_ |
varbinary |
Image 256 | |||
image_ |
varbinary |
Image 512 | |||
is_ |
boolean |
Is Published | |||
level |
varchar2 |
Forum Badge Level | |||
message_ |
int32 |
Attachment Count | |||
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 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
name |
varchar2 |
Badge | |||
owner_ |
varchar2 |
The list of instances of this badge granted to users | |||
remaining_ |
int32 |
Remaining Sending Allowed | If a maximum is set | ||
rule_ |
varchar2 |
Allowance to Grant | Who can grant this badge | ||
rule_ |
varchar2 |
Only the people having these badges can give this badge | |||
rule_ |
varchar2 |
Only these people can give this badge | |||
rule_ |
boolean |
Monthly Limited Sending | Check to set a monthly limit per person of sending this badge | ||
rule_ |
int32 |
Limitation Number | The maximum number of time this badge can be sent per month per person. | ||
stat_ |
int32 |
My Total | The number of time the current user has received this badge. | ||
stat_ |
int32 |
My Monthly Sending Total | The number of time the current user has sent this badge this month. | ||
stat_ |
int32 |
My Monthly Total | The number of time the current user has received this badge this month. | ||
stat_ |
int32 |
Monthly total | The number of time this badge has been received this month. | ||
survey_ |
varchar2 |
||||
survey_ |
varchar2 |
||||
survey_ |
varchar2 |
||||
unique_ |
varchar2 |
The list of unique users having received this badge. | |||
website_ |
varchar2 |
Website communication history | |||
website_ |
boolean |
Visible on current website | |||
website_ |
varchar2 |
Website URL | The full URL to access the document through the website. | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: