stream_post: Odoo itgen_odoo_stream_post
read only per partition
- Catalog:
Odoo - Schema:
social - Label: itgen_odoo_stream_post
Social Stream Post
Can only retrieve data.
Summary
A 'stream' post, as opposed to a regular social.post, references a post that actually exists on a social.media external database (a Facebook post, a Tweet, ...).
Stream posts are created by fetching data from the related social media third party API.
They should not be directly created/modified.
social.stream.posts are used to fill the 'Feed' view that allows users to follow the social.media activity
based on their interest (a Facebook Page, a Twitter hashtag, ...).
They are directly created by their related social.stream.
Table Columns
The columns of the table stream_post 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 |
|---|---|---|---|---|---|
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
author_ |
varchar2 |
Author Link | Author link to the external social.media (ex: link to the Twitter Account). | ||
author_ |
varchar2 |
Author Name | The post author name based on third party information (ex: 'John Doe'). | ||
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 | |||
facebook_ |
varchar2 |
Facebook Author ID | |||
facebook_ |
int32 |
Comments | |||
facebook_ |
boolean |
Is event post | |||
facebook_ |
int32 |
Likes | |||
facebook_ |
varchar2 |
Facebook Post ID | |||
facebook_ |
int32 |
Reach | |||
facebook_ |
int32 |
Shares | |||
facebook_ |
boolean |
User Likes | |||
formatted_ |
varchar2 |
Formatted Published Date | |||
id |
int32 |
ID | |||
instagram_ |
int32 |
Instagram Comments | |||
instagram_ |
varchar2 |
Instagram Facebook Author ID | The Facebook ID of this Instagram post author, used to fetch the profile picture. | ||
instagram_ |
int32 |
Instagram Likes | |||
instagram_ |
varchar2 |
Instagram Post ID | |||
instagram_ |
varchar2 |
Instagram Post URL | |||
link_ |
varchar2 |
Link Description | |||
link_ |
varchar2 |
Link Image URL | |||
link_ |
varchar2 |
Link Title | |||
link_ |
varchar2 |
Link URL | |||
linkedin_ |
varchar2 |
LinkedIn author ID | |||
linkedin_ |
varchar2 |
LinkedIn author image URL | |||
linkedin_ |
varchar2 |
LinkedIn author URN | |||
linkedin_ |
varchar2 |
LinkedIn Vanity Name | Vanity name, used to generate a link to the author | ||
linkedin_ |
int32 |
LinkedIn Comments | |||
linkedin_ |
int32 |
LinkedIn Likes | |||
linkedin_ |
varchar2 |
LinkedIn post URN | |||
media_ |
varchar2 |
Related Social Media | Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...). | ||
message |
varchar2 |
Message | |||
post_ |
varchar2 |
Post Link | Post link to the external social.media (ex: link to the actual Facebook Post). | ||
published_ |
datetime |
Published date | The post published date based on third party information. | ||
stream_ |
varchar2 |
||||
stream_ |
varchar2 |
||||
stream_ |
varchar2 |
Images that were shared with this post. | |||
stream_ |
varchar2 |
Stream Post Images URLs | |||
twitter_ |
varchar2 |
Twitter Author ID | |||
twitter_ |
boolean |
Twitter Can Retweet | |||
twitter_ |
int32 |
Twitter Comments | |||
twitter_ |
int32 |
Twitter Likes | |||
twitter_ |
varchar2 |
Twitter Profile Image URL | |||
twitter_ |
varchar2 |
Quoted tweet author Link | |||
twitter_ |
varchar2 |
Quoted tweet author Name | |||
twitter_ |
varchar2 |
Twitter Quoted Tweet ID | |||
twitter_ |
varchar2 |
Quoted tweet message | |||
twitter_ |
varchar2 |
Quoted tweet profile image URL | |||
twitter_ |
int32 |
Re-tweets | |||
twitter_ |
varchar2 |
Twitter Retweet ID | |||
twitter_ |
varchar2 |
Twitter Screen Name | |||
twitter_ |
varchar2 |
Twitter Tweet ID | |||
twitter_ |
boolean |
Twitter User Likes | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
youtube_ |
int32 |
YouTube Comments Count | |||
youtube_ |
int32 |
YouTube Dislikes | |||
youtube_ |
int32 |
YouTube Likes | |||
youtube_ |
int32 |
YouTube Likes Ratio | |||
youtube_ |
varchar2 |
YouTube Thumbnail Url | |||
youtube_ |
varchar2 |
YouTube Video ID | |||
youtube_ |
int32 |
YouTube Views |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: