Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | null |
|
|
|||
| source | text | 2147483647 | 'unknown'::text |
|
|
|||
| actor_run_id | text | 2147483647 | null |
|
|
|||
| actor_name | text | 2147483647 | null |
|
|
|||
| item_id | text | 2147483647 | null |
|
|
|||
| title | text | 2147483647 | ''::text |
|
|
|||
| body | text | 2147483647 | ''::text |
|
|
|||
| text | 2147483647 | ''::text |
|
|
||||
| subreddit | text | 2147483647 | ''::text |
|
|
|||
| post_url | text | 2147483647 | ''::text |
|
|
|||
| score | int8 | 19 | 0 |
|
|
|||
| num_comments | int8 | 19 | 0 |
|
|
|||
| created_utc | text | 2147483647 | √ | ''::text |
|
|
||
| scraped_at | text | 2147483647 | now() |
|
|
|||
| is_video | bool | 1 | false |
|
|
|||
| is_gallery | bool | 1 | false |
|
|
|||
| has_media | bool | 1 | false |
|
|
|||
| thumbnail_url | text | 2147483647 | ''::text |
|
|
|||
| video_url | text | 2147483647 | ''::text |
|
|
|||
| keywords | text | 2147483647 | ''::text |
|
|
|||
| search_terms | text | 2147483647 | ''::text |
|
|
|||
| content_hash | text | 2147483647 | ''::text |
|
|
|||
| raw_json | text | 2147483647 | ''::text |
|
|
|||
| data_type | text | 2147483647 | 'post'::text |
|
|
|||
| parent_id | text | 2147483647 | ''::text |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| items_pkey | Primary key | Asc | id |
| idx_items_actor | Performance | Asc | actor_name |
| idx_items_data_type | Performance | Asc | data_type |
| idx_items_parent_id | Performance | Asc | parent_id |
| idx_items_scraped | Performance | Asc | scraped_at |
| idx_items_source | Performance | Asc | source |