Posts: Discourse Posts
insert REST
- Catálogo:
Discourse - Esquema:
Posts - Label: Posts
Get a list of the latest posts across topics
Permite recuperar y modificar datos mediante insert.
Resumen
Get a list of the latest posts across topics
Fuente de la API
- Punto final:
/posts.json - Operación:
get /posts.json
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 243 |
| Escribir filas por minuto | 219 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla Posts. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
accepted_ |
char |
Respuesta aceptada | filters on the platform, writable, accepted_ |
||
action_ |
varchar2 |
Código de acción | filters on the platform, writable, action_ |
||
admin |
char |
Administrator | filters on the platform, writable, admin |
||
avatar_ |
varchar2 |
Plantilla de avatar | filters on the platform, writable, avatar_ |
||
avg_ |
varchar2 |
itgen_dce_avg_time | writable | The JSON text of the nested object. | |
bookmarked |
char |
Bookmarked | filters on the platform, writable, bookmarked |
||
can_ |
char |
Puedo aceptar la respuesta | filters on the platform, writable, can_ |
||
can_ |
char |
Se puede eliminar | filters on the platform, writable, can_ |
||
can_ |
char |
Se puede editar | filters on the platform, writable, can_ |
||
can_ |
varchar2 |
Se puede recuperar | writable | The JSON text of the nested object. | |
can_ |
char |
¿Se puede rechazar una respuesta? | filters on the platform, writable, can_ |
||
can_ |
char |
Se puede ver el historial de modificaciones | filters on the platform, writable, can_ |
||
can_ |
char |
Puede votar | filters on the platform, writable, can_ |
||
can_ |
char |
¿Se puede convertir en un artículo de la Wikipedia? | filters on the platform, writable, can_ |
||
category_ |
decimal |
ID de Categoría | filters on the platform, writable, category_ |
||
cooked |
varchar2 |
Cooked | filters on the platform, writable, cooked |
||
created_ |
varchar2 |
Creado en | filters on the platform, writable, created_ |
||
deleted_ |
varchar2 |
Eliminado el | writable | The JSON text of the nested object. | |
display_ |
varchar2 |
Mostrar nombre de usuario | filters on the platform, writable, display_ |
||
edit_ |
varchar2 |
Motivo de la edición | writable | The JSON text of the nested object. | |
hidden |
char |
Hidden | filters on the platform, writable, hidden |
||
id |
decimal |
ID | filters on the platform, writable, id |
||
incoming_ |
decimal |
#Enlaces entrantes | filters on the platform, writable, incoming_ |
||
moderator |
char |
Moderator | filters on the platform, writable, moderator |
||
name |
varchar2 |
Name | filters on the platform, writable, name |
||
notice_ |
varchar2 |
Tipo de aviso | filters on the platform, writable, notice. |
||
post_ |
decimal |
Número de publicación | filters on the platform, writable, post_ |
||
post_ |
decimal |
Tipo de entrada | filters on the platform, writable, post_ |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Nombre del grupo principal | writable | The JSON text of the nested object. | |
quote_ |
decimal |
#Quotes | filters on the platform, writable, quote_ |
||
raw |
varchar2 |
Raw | filters on the platform, writable, raw |
||
readers_ |
int32 |
Los lectores cuentan | filters on the platform, writable, readers_ |
||
reads |
decimal |
#Reads | filters on the platform, writable, reads |
||
reply_ |
decimal |
#Replies | filters on the platform, writable, reply_ |
||
reply_ |
varchar2 |
Responder al mensaje número | writable | The JSON text of the nested object. | |
reply_ |
varchar2 |
Plantilla de respuesta al avatar de un usuario | filters on the platform, writable, reply_ |
||
reply_ |
varchar2 |
Responder al usuario «Nombre de usuario» | filters on the platform, writable, reply_ |
||
reviewable_ |
int32 |
Recuento de puntuaciones revisables | filters on the platform, writable, reviewable_ |
||
reviewable_ |
int32 |
Puntuación revisable: número de casos pendientes | filters on the platform, writable, reviewable_ |
||
score |
decimal |
Score | filters on the platform, writable, score |
||
staff |
char |
Staff | filters on the platform, writable, staff |
||
static_ |
char |
Documentación estática | filters on the platform, writable, static_ |
||
title_ |
char |
Título: Grupo | filters on the platform, writable, title_ |
||
topic_ |
varchar2 |
Título HTML del tema | filters on the platform, writable, topic_ |
||
topic_ |
decimal |
ID del Tema | filters on the platform, writable, topic_ |
||
topic_ |
varchar2 |
Slug del tema | filters on the platform, writable, topic_ |
||
topic_ |
varchar2 |
Título del tema | filters on the platform, writable, topic_ |
||
trust_ |
decimal |
Nivel de confianza | filters on the platform, writable, trust_ |
||
updated_ |
varchar2 |
Actualizado en | filters on the platform, writable, updated_ |
||
user_ |
char |
Usuario eliminado | filters on the platform, writable, user_ |
||
user_ |
decimal |
Identificación de Usuario | filters on the platform, writable, user_ |
||
user_ |
varchar2 |
Título de usuario | writable | The JSON text of the nested object. | |
username |
varchar2 |
Nombre de Usuario | filters on the platform, writable, username |
||
version |
decimal |
Version | filters on the platform, writable, version |
||
via_ |
char |
Por correo electrónico | filters on the platform, writable, via_ |
||
wiki |
char |
Wiki | filters on the platform, writable, wiki |
||
yours |
char |
Yours | filters on the platform, writable, yours |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Posts_ |
category_ |
Categories.id |
Candidate | Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table. |
Referenciado por
- Posts_Latest_postsActions_summary
id_2(Candidate)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:
Modificaciones de esta tabla, De 26.0 a 27.0
-avg_time~can_recover(database_data_type:varchar2→char)~can_recover(dotnet_data_type:string→boolean)~category_id(database_data_type:decimal→int64)~category_id(dotnet_data_type:decimal→int64)~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~incoming_link_count(database_data_type:decimal→int64)~incoming_link_count(dotnet_data_type:decimal→int64)~post_number(database_data_type:decimal→int64)~post_number(dotnet_data_type:decimal→int64)~post_type(database_data_type:decimal→int64)~post_type(dotnet_data_type:decimal→int64)-primary_group_flair_bg_color-primary_group_flair_color
42 cambios más
Discourse.Posts.Posts: cambios de tipo
El tipo de «Discourse.Posts.Posts» cambia de «Tabla» a «función de tabla».
Qué hacer
Comprueba las sentencias, Views y scripts que la utilicen antes de la actualización.
- puede interrumpir una instrucción
table→tablefunction- importancia 3
El parámetro anterior se añade a Discourse.Posts.Posts
Opcional.
- importancia 2
-primary_group_flair_url~quote_count(database_data_type:decimal→int64)~quote_count(dotnet_data_type:decimal→int64)~readers_count(database_data_type:int32→int64)~readers_count(dotnet_data_type:int32→int64)~reads(database_data_type:decimal→int64)~reads(dotnet_data_type:decimal→int64)~reply_count(database_data_type:decimal→int64)~reply_count(dotnet_data_type:decimal→int64)~reviewable_score_count(database_data_type:int32→int64)~reviewable_score_count(dotnet_data_type:int32→int64)~reviewable_score_pending_count(database_data_type:int32→int64)~reviewable_score_pending_count(dotnet_data_type:int32→int64)-static_doc~topic_id(database_data_type:decimal→int64)~topic_id(dotnet_data_type:decimal→int64)~trust_level(database_data_type:decimal→int64)~trust_level(dotnet_data_type:decimal→int64)~user_id(database_data_type:decimal→int64)~user_id(dotnet_data_type:decimal→int64)~version(database_data_type:decimal→int64)~version(dotnet_data_type:decimal→int64)+archetype(varchar2)+auto_track(char)+can_see_hidden_post(char)+category(int32)+embed_url(varchar2)+excerpt(varchar2)+external_id(varchar2)+flair_bg_color(varchar2)+flair_color(varchar2)+flair_group_id(varchar2)+flair_name(varchar2)+flair_url(varchar2)+post_url(varchar2)+posts_count(int64)+reviewable_id(varchar2)+target_recipients(varchar2)+title(varchar2)+truncated(char)