gistfile1.txt

titusvpcservice=> \d branch_eni_attachments

                                                Table "public.branch_eni_attachments"
          Column           |            Type             | Collation | Nullable |                      Default                       
---------------------------+-----------------------------+-----------+----------+----------------------------------------------------
 id                        | integer                     |           | not null | nextval('branch_eni_attachments_id_seq'::regclass)
 branch_eni                | text                        |           | not null | 
 trunk_eni                 | text                        |           |          | 
 idx                       | integer                     |           |          | 
 association_id            | text                        |           |          | 
 created_at                | timestamp without time zone |           | not null | CURRENT_TIMESTAMP
 attachment_generation     | integer                     |           |          | 
 association_token         | text                        |           |          | 
 disassociation_token      | text                        |           |          | 
 attachment_created_by     | text                        |           |          | 
 attachment_created_at     | timestamp without time zone |           |          | now()
 attachment_completed_by   | text                        |           |          | 
 attachment_completed_at   | timestamp without time zone |           |          | 
 unattachment_created_by   | text                        |           |          | 
 unattachment_created_at   | timestamp without time zone |           |          | 
 unattachment_completed_by | text                        |           |          | 
 unattachment_completed_at | timestamp without time zone |           |          | 
 state                     | attachment_state            |           | not null | 'attached'::attachment_state
 force                     | boolean                     |           |          | false
 error_code                | text                        |           |          | 
 error_message             | text                        |           |          | 
Indexes:
    "branch_eni_attachments_pk" PRIMARY KEY, btree (id)
    "branch_eni_attachments_association_id_uindex" UNIQUE, btree (association_id)
    "branch_eni_attachments_association_token_uindex" UNIQUE, btree (association_token)
    "branch_eni_attachments_branch_eni_trunk_eni_idx_uindex" UNIQUE, btree (branch_eni, trunk_eni, idx) WHERE state = 'attaching'::attachment_state OR state = 'attached'::attachment_state OR state = 'unattaching'::attachment_state
    "branch_eni_attachments_branch_eni_uindex" UNIQUE, btree (branch_eni) WHERE state = 'attaching'::attachment_state OR state = 'attached'::attachment_state OR state = 'unattaching'::attachment_state
    "branch_eni_attachments_disassociation_token_uindex" UNIQUE, btree (disassociation_token)
    "branch_eni_attachments_trunk_eni_idx_uindex" UNIQUE, btree (trunk_eni, idx) WHERE state = 'attaching'::attachment_state OR state = 'attached'::attachment_state OR state = 'unattaching'::attachment_state
    "branch_eni_attachments_branch_eni_state_index" btree (branch_eni, state)
    "branch_eni_attachments_state_index" btree (state)
    "branch_eni_attachments_trunk_eni_index" btree (trunk_eni)
Check constraints:
    "branch_eni_attachments_association_id_check" CHECK (association_id IS NULL OR association_id ~~ 'trunk-assoc-%'::text)
    "branch_eni_attachments_branch_eni_check" CHECK (branch_eni ~~ 'eni-%'::text)
    "branch_eni_attachments_trunk_eni_check" CHECK (trunk_eni ~~ 'eni-%'::text)
Foreign-key constraints:
    "branch_eni_attachments_branch_enis_branch_eni_fk" FOREIGN KEY (branch_eni) REFERENCES branch_enis(branch_eni) ON DELETE CASCADE
Referenced by:
    TABLE "assignments" CONSTRAINT "assignments_branch_eni_attachments_association_id_fk" FOREIGN KEY (branch_eni_association) REFERENCES branch_eni_attachments(association_id) ON DELETE CASCADE
    TABLE "branch_eni_actions_disassociate" CONSTRAINT "bea_disassociate_branch_eni_attachments_association_id_fk" FOREIGN KEY (association_id) REFERENCES branch_eni_attachments(association_id) ON DELETE CASCADE