posts: StackExchange Posts |
Catalog: StackExchange
Schema: StackExchange
Primary Keys: post_id
Label: Posts
The data in this table is partitioned per value of the column.
This is a read-only table. The StackExchange API may not support changing the data or the Invantive SQL driver for StackExchange does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the StackExchange API.
Select StackExchange API URL: /posts/{ids}?order=desc&sort=activity&filter=!9YdnSEdG8
Insert StackExchange API URL: /posts/{ids}?order=desc&sort=activity&filter=!9YdnSEdG8
Update StackExchange API URL: /posts/{ids}?order=desc&sort=activity&filter=!9YdnSEdG8
Delete StackExchange API URL: /posts/{ids}?order=desc&sort=activity&filter=!9YdnSEdG8
Field Selection Method: NotRequired
Table Columns
The columns of the table posts are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
body_markdown |
string |
|
☐ |
|
body |
string |
Body |
☐ |
|
comment_count |
int32 |
|
☐ |
|
creation_date |
datetime |
|
☐ |
|
down_vote_count |
int32 |
|
☐ |
|
downvoted |
boolean |
|
☐ |
|
last_activity_date |
datetime |
|
☐ |
|
last_edit_date |
datetime |
Last Edit Date |
☐ |
|
last_editor_display_name |
string |
|
☐ |
|
last_editor_user_id |
int64 |
|
☐ |
|
link |
string |
|
☐ |
|
owner_accept_rate |
int64 |
|
☐ |
|
owner_display_name |
string |
|
☐ |
|
owner_link |
string |
|
☐ |
|
owner_profile_image |
string |
|
☐ |
|
owner_reputation |
int64 |
|
☐ |
|
owner_user_id |
int64 |
|
☐ |
|
owner_user_type |
string |
|
☐ |
|
post_id |
int64 |
|
☐ |
|
post_type |
string |
|
☐ |
|
score |
int32 |
|
☐ |
|
share_link |
string |
|
☐ |
|
title |
string |
|
☐ |
|
up_vote_count |
int32 |
|
☐ |
|
upvoted |
boolean |
|
☐ |
|
15-06-2022 22:37 Version 22.1.46-BETA+3385