account: Odoo itgen_odoo_account
read only per partition
- Catalog:
Odoo - Schema:
social - Label: itgen_odoo_account
Social Account
Can only retrieve data.
Summary
A social.account represents an actual account on the related social.media. Ex: A Facebook Page or a Twitter Account.
These social.accounts will then be used to send generic social.posts to multiple social.accounts.
They are also used to display a 'dashboard' of statistics on the 'Feed' view.
Account statistic fields are 'computed' manually through the _compute_statistics method
that is overridden by each actual social module implementations (social_facebook, social_twitter, ...).
The statistics computation is run manually when visualizing the Feed.
Table Columns
The columns of the table account 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 | |||
audience |
int32 |
Audience | General audience of the Social Account (Page Likes, Account Follows, ...). | ||
audience_ |
numeric |
Audience Trend | Percentage of increase/decrease of the audience over a defined period. | ||
company_ |
varchar2 |
Link an account to a company to restrict its usage or keep empty to let all companies use it. | |||
company_ |
varchar2 |
Link an account to a company to restrict its usage or keep empty to let all companies use it. | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
engagement |
int32 |
Engagement | Number of people engagements with your posts (Likes, Comments, ...). | ||
engagement_ |
numeric |
Engagement Trend | Percentage of increase/decrease of the engagement over a defined period. | ||
facebook_ |
varchar2 |
Facebook Access Token | Facebook Page Access Token provided by the Facebook API, this should never be set manually. It's used to authenticate requests when posting to or reading information from this account. | ||
facebook_ |
varchar2 |
Facebook Account ID | Facebook Page ID provided by the Facebook API, this should never be set manually. | ||
firebase_ |
varbinary |
Firebase Admin Key File | |||
firebase_ |
varchar2 |
Firebase Project ID | |||
firebase_ |
varchar2 |
Firebase Push Certificate Key | |||
firebase_ |
varchar2 |
Firebase Sender ID | |||
firebase_ |
boolean |
Use your own Firebase account | |||
firebase_ |
varchar2 |
Firebase Web API Key | |||
has_ |
boolean |
Has Account Stats | Defines whether this account has Audience/Engagements/Stories stats. Account with stats are displayed on the dashboard. | ||
has_ |
boolean |
Has Trends? | Defines whether this account has statistics tends or not. | ||
id |
int32 |
ID | |||
image |
varbinary |
Image | |||
instagram_ |
varchar2 |
Instagram Access Token | Instagram Access Token provided by the Facebook API, this should never be set manually. It's used to authenticate requests when posting to or reading information from this account. | ||
instagram_ |
varchar2 |
Instagram Account ID | Instagram Account ID provided by the Facebook API, this should never be set manually. | ||
instagram_ |
varchar2 |
Instagram Facebook Account ID | Facebook Account ID provided by the Facebook API, this should never be set manually. The Instagram ("Professional") account is always linked to a Facebook account. | ||
is_ |
boolean |
Link with external Social Media is broken | |||
linkedin_ |
varchar2 |
LinkedIn access token | The access token is used to perform request to the REST API | ||
linkedin_ |
varchar2 |
LinkedIn Account ID | |||
linkedin_ |
varchar2 |
LinkedIn Account URN | LinkedIn Account URN | ||
media_ |
varchar2 |
Related Social Media (Facebook, Twitter, ...). | |||
media_ |
varchar2 |
Related Social Media (Facebook, Twitter, ...). | |||
media_ |
varchar2 |
Media Type | Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...). | ||
name |
varchar2 |
Name | |||
notification_ |
varchar2 |
Notification Request Text | |||
notification_ |
int32 |
Notification Request Delay (seconds) | |||
notification_ |
varbinary |
Notification Request Icon | |||
notification_ |
varchar2 |
Notification Request Title | |||
social_ |
varchar2 |
Handle / Short Name | Contains the social media handle of the person that created this account. E.g: '@odoo.official' for the 'Odoo' Twitter account | ||
stats_ |
varchar2 |
Stats Link | Link to the external Social Account statistics | ||
stories |
int32 |
Stories | Number of stories created from your posts (Shares, Re-tweets, ...). | ||
stories_ |
numeric |
Stories Trend | Percentage of increase/decrease of the stories over a defined period. | ||
twitter_ |
varchar2 |
Twitter OAuth Token | |||
twitter_ |
varchar2 |
Twitter OAuth Token Secret | |||
twitter_ |
varchar2 |
Twitter User ID | |||
utm_ |
varchar2 |
Every time an account is created, a utm.medium is also created and linked to the account | |||
utm_ |
varchar2 |
Every time an account is created, a utm.medium is also created and linked to the account | |||
website_ |
varchar2 |
This firebase configuration will only be used for the specified website | |||
website_ |
varchar2 |
This firebase configuration will only be used for the specified website | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
youtube_ |
varchar2 |
Google Access Token | Access token provided by the YouTube API, this should never be set manually. | ||
youtube_ |
varchar2 |
YouTube Channel ID | YouTube Channel ID provided by the YouTube API, this should never be set manually. | ||
youtube_ |
varchar2 |
Google Refresh Token | Refresh token provided by the YouTube API, this should never be set manually. | ||
youtube_ |
datetime |
Token expiration date | Expiration date of the Access Token provided by the YouTube API, this should never be set manually. | ||
youtube_ |
varchar2 |
YouTube Upload Playlist ID | 'Uploads' Playlist ID provided by the YouTube API, this should never be set manually. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: