Schema

gistfile1.txt

# \d publish
                    Table "public.publish"
         Column         |           Type           | Modifiers 
------------------------+--------------------------+-----------
 domain                 | integer                  | 
 user_id                | integer                  | 
 id                     | uuid                     | 
 issued                 | timestamp with time zone | 
 content_id             | uuid                     | 
 overriding_contacttype | text                     | 
 syndicated             | boolean                  | 
 message_sms            | text                     | 
 message_email          | text                     | 
 total                  | integer                  | 
 have_reported_error    | boolean                  | 
 source                 | text                     | 
 content_name           | text                     | 
 content_document       | json                     | 
 sendas_email           | text                     | 
 funded                 | boolean                  | 
 plaintext_only         | boolean                  | 
Indexes:
    "publish_content_id_idx" btree (content_id)
    "publish_funded_syndicated_idx" btree (funded, syndicated)
    "publish_id_funded_idx" btree (id, funded)
    "publish_id_idx" btree (id)


# \d publish_queue
                   Table "public.publish_queue"
           Column           |           Type           | Modifiers 
----------------------------+--------------------------+-----------
 domain                     | integer                  | 
 send_id                    | uuid                     | 
 publish_id                 | uuid                     | 
 maturation_timestamp       | timestamp with time zone | 
 person_id                  | uuid                     | 
 status_executed            | integer                  | 
 status_executed_time       | timestamp with time zone | 
 status_executed_errdetail  | text                     | 
 mt_message_id              | uuid                     | 
 contact_id                 | uuid                     | 
 custom_data                | json                     | 
 active_subobject_instances | json                     | 
Indexes:
    "publish_queue_send_id_idx" UNIQUE, btree (send_id)
    "publish_queue_maturation_timestamp_idx" btree (maturation_timestamp)
    "publish_queue_person_id_idx" btree (person_id)
    "publish_queue_publish_id_idx" btree (publish_id)
    "publish_queue_status_executed_idx" btree (status_executed)