stream_post: Odoo itgen_odoo_stream_post
read only per partition
- Catalogo:
Odoo - Schema:
social - Etichetta: itgen_odoo_stream_post
Social Stream Post
È possibile solo recuperare i dati.
Riepilogo
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.
Colonne della tabella
Di seguito sono riportate le colonne della tabella stream_post. 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 |
|---|---|---|---|---|---|
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
author_ |
varchar2 |
Author Link | Author link to the external social.media (ex: link to the Twitter Account). | ||
author_ |
varchar2 |
Nome dell'autore | 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 |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
URL del collegamento | |||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: