# Posts: Discourse Posts Get a list of the latest posts across topics - Catalog: `Discourse` - Schema: `Posts` - Label: Posts - Retrieve: True - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `Posts` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accepted_answer` | `char` | | ☐ | | | `action_code` | `varchar2` | | ☐ | | | `admin` | `char` | Administrator | ☐ | | | `avatar_template` | `varchar2` | Avatar Template | ☐ | | | `avg_time` | `varchar2` | | ☐ | | | `bookmarked` | `char` | Bookmarked | ☐ | | | `can_accept_answer` | `char` | | ☐ | | | `can_delete` | `char` | Can Delete | ☐ | | | `can_edit` | `char` | Can Edit | ☐ | | | `can_recover` | `varchar2` | Can Recover | ☐ | | | `can_unaccept_answer` | `char` | | ☐ | | | `can_view_edit_history` | `char` | Can View Edit History | ☐ | | | `can_vote` | `char` | | ☐ | | | `can_wiki` | `char` | Can Wikify | ☐ | | | `category_id` | `decimal` | Category ID | ☐ | | | `cooked` | `varchar2` | Cooked | ☐ | | | `created_at` | `varchar2` | Created at | ☐ | | | `deleted_at` | `varchar2` | | ☐ | | | `display_username` | `varchar2` | Display User Name | ☐ | | | `edit_reason` | `varchar2` | | ☐ | | | `hidden` | `char` | Hidden | ☐ | | | `id` | `decimal` | ID | ☐ | | | `incoming_link_count` | `decimal` | #Incoming Links | ☐ | | | `moderator` | `char` | Moderator | ☐ | | | `name` | `varchar2` | Name | ☐ | | | `notice_type` | `varchar2` | | ☐ | | | `post_number` | `decimal` | Post Number | ☐ | | | `post_type` | `decimal` | Post Type | ☐ | | | `primary_group_flair_bg_color` | `varchar2` | | ☐ | | | `primary_group_flair_color` | `varchar2` | | ☐ | | | `primary_group_flair_url` | `varchar2` | | ☐ | | | `primary_group_name` | `varchar2` | | ☐ | | | `quote_count` | `decimal` | #Quotes | ☐ | | | `raw` | `varchar2` | Raw | ☐ | | | `readers_count` | `int32` | | ☐ | | | `reads` | `decimal` | #Reads | ☐ | | | `reply_count` | `decimal` | #Replies | ☐ | | | `reply_to_post_number` | `varchar2` | | ☐ | | | `reply_to_user_avatar_template` | `varchar2` | | ☐ | | | `reply_to_user_username` | `varchar2` | | ☐ | | | `reviewable_score_count` | `int32` | | ☐ | | | `reviewable_score_pending_count` | `int32` | | ☐ | | | `score` | `decimal` | Score | ☐ | | | `staff` | `char` | Staff | ☐ | | | `static_doc` | `char` | Static Doc | ☐ | | | `title_is_group` | `char` | | ☐ | | | `topic_html_title` | `varchar2` | Topic HTML Title | ☐ | | | `topic_id` | `decimal` | Topic ID | ☐ | | | `topic_slug` | `varchar2` | Topic Slug | ☐ | | | `topic_title` | `varchar2` | Topic Title | ☐ | | | `trust_level` | `decimal` | Trust Level | ☐ | | | `updated_at` | `varchar2` | Updated at | ☐ | | | `user_deleted` | `char` | User Deleted | ☐ | | | `user_id` | `decimal` | User ID | ☐ | | | `user_title` | `varchar2` | | ☐ | | | `username` | `varchar2` | User Name | ☐ | | | `version` | `decimal` | Version | ☐ | | | `via_email` | `char` | | ☐ | | | `wiki` | `char` | Wiki | ☐ | | | `yours` | `char` | Yours | ☐ | |