public.statuses

                                              Table "public.statuses"
            Column            |            Type             | Collation | Nullable |            Default
------------------------------+-----------------------------+-----------+----------+--------------------------------
 id                           | bigint                      |           | not null | timestamp_id('statuses'::text)
 uri                          | character varying           |           |          |
 text                         | text                        |           | not null | ''::text
 created_at                   | timestamp without time zone |           | not null |
 updated_at                   | timestamp without time zone |           | not null |
 in_reply_to_id               | bigint                      |           |          |
 reblog_of_id                 | bigint                      |           |          |
 url                          | character varying           |           |          |
 sensitive                    | boolean                     |           | not null | false
 visibility                   | integer                     |           | not null | 0
 spoiler_text                 | text                        |           | not null | ''::text
 reply                        | boolean                     |           | not null | false
 language                     | character varying           |           |          |
 conversation_id              | bigint                      |           |          |
 local                        | boolean                     |           |          |
 account_id                   | bigint                      |           | not null |
 application_id               | bigint                      |           |          |
 in_reply_to_account_id       | bigint                      |           |          |
 poll_id                      | bigint                      |           |          |
 deleted_at                   | timestamp without time zone |           |          |
 edited_at                    | timestamp without time zone |           |          |
 trendable                    | boolean                     |           |          |
 ordered_media_attachment_ids | bigint[]                    |           |          |
 local_only                   | boolean                     |           |          |
 content_type                 | character varying           |           |          |
Indexes:
    "statuses_pkey" PRIMARY KEY, btree (id)
    "index_statuses_20190820" btree (account_id, id DESC, visibility, updated_at) WHERE deleted_at IS NULL
    "index_statuses_local_20190824" btree (id DESC, account_id) WHERE (local OR uri IS NULL) AND deleted_at IS NULL AND visibility = 0 AND reblog_of_id IS NULL AND (NOT reply OR in_reply_to_account_id = account_id)
    "index_statuses_on_account_id" btree (account_id)
    "index_statuses_on_deleted_at" btree (deleted_at) WHERE deleted_at IS NOT NULL
    "index_statuses_on_in_reply_to_account_id" btree (in_reply_to_account_id) WHERE in_reply_to_account_id IS NOT NULL
    "index_statuses_on_in_reply_to_id" btree (in_reply_to_id) WHERE in_reply_to_id IS NOT NULL
    "index_statuses_on_reblog_of_id_and_account_id" btree (reblog_of_id, account_id)
    "index_statuses_on_uri" UNIQUE, btree (uri text_pattern_ops) WHERE uri IS NOT NULL
    "index_statuses_public_20200119" btree (id DESC, account_id) WHERE deleted_at IS NULL AND visibility = 0 AND reblog_of_id IS NULL AND (NOT reply OR in_reply_to_account_id = account_id)
Foreign-key constraints:
    "fk_9bda1543f7" FOREIGN KEY (account_id) REFERENCES accounts(id) ON DELETE CASCADE
    "fk_c7fa917661" FOREIGN KEY (in_reply_to_account_id) REFERENCES accounts(id) ON DELETE SET NULL
    "fk_rails_256483a9ab" FOREIGN KEY (reblog_of_id) REFERENCES statuses(id) ON DELETE CASCADE
    "fk_rails_94a6f70399" FOREIGN KEY (in_reply_to_id) REFERENCES statuses(id) ON DELETE SET NULL
Referenced by:
    TABLE "favourites" CONSTRAINT "fk_b0e856845e" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "bookmarks" CONSTRAINT "fk_rails_11207ffcfd" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "statuses" CONSTRAINT "fk_rails_256483a9ab" FOREIGN KEY (reblog_of_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "custom_filter_statuses" CONSTRAINT "fk_rails_2f6d20c0cf" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "polls" CONSTRAINT "fk_rails_3e0d9f1115" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "media_attachments" CONSTRAINT "fk_rails_3ec0cfdd70" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE SET NULL
    TABLE "status_stats" CONSTRAINT "fk_rails_4a247aac42" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "mentions" CONSTRAINT "fk_rails_59edbe2887" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "notification_requests" CONSTRAINT "fk_rails_61c7aa9c1f" FOREIGN KEY (last_status_id) REFERENCES statuses(id) ON DELETE SET NULL
    TABLE "status_pins" CONSTRAINT "fk_rails_65c05552f1" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "status_trends" CONSTRAINT "fk_rails_68c610dc1a" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "statuses" CONSTRAINT "fk_rails_94a6f70399" FOREIGN KEY (in_reply_to_id) REFERENCES statuses(id) ON DELETE SET NULL
    TABLE "status_edits" CONSTRAINT "fk_rails_a960f234a0" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "statuses_tags" CONSTRAINT "fk_rails_df0fe11427" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE