gistfile1.txt

louvre-d-# \d gallery_release
                                       Table "public.gallery_release"
   Column   |           Type           | Collation | Nullable |                   Default                   
------------+--------------------------+-----------+----------+---------------------------------------------
 id         | integer                  |           | not null | nextval('gallery_release_id_seq'::regclass)
 created_at | timestamp with time zone |           | not null | 
 updated_at | timestamp with time zone |           | not null | 
 label      | character varying(60)    |           | not null | 
 namespace  | character varying(20)    |           | not null | 
 creator_id | integer                  |           | not null | 
 owner_id   | integer                  |           | not null | 
 project_id | integer                  |           | not null | 
Indexes:
    "gallery_release_pkey" PRIMARY KEY, btree (id)
    "gallery_release_label_key" UNIQUE CONSTRAINT, btree (label)
    "gallery_release_creator_id_a76e1962" btree (creator_id)
    "gallery_release_label_57c887e7_like" btree (label varchar_pattern_ops)
    "gallery_release_owner_id_755a9088" btree (owner_id)
    "gallery_release_project_id_9e1018ef" btree (project_id)
Foreign-key constraints:
    "gallery_release_creator_id_a76e1962_fk_users_user_id" FOREIGN KEY (creator_id) REFERENCES users_user(id) DEFERRABLE INITIALLY DEFERRED
    "gallery_release_owner_id_755a9088_fk_users_user_id" FOREIGN KEY (owner_id) REFERENCES users_user(id) DEFERRABLE INITIALLY DEFERRED
    "gallery_release_project_id_9e1018ef_fk_gallery_project_id" FOREIGN KEY (project_id) REFERENCES gallery_project(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "gallery_release_parent_releases" CONSTRAINT "gallery_release_pare_from_release_id_f3f8befa_fk_gallery_r" FOREIGN KEY (from_release_id) REFERENCES gallery_release(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "gallery_release_parent_releases" CONSTRAINT "gallery_release_pare_to_release_id_fc3c2e08_fk_gallery_r" FOREIGN KEY (to_release_id) REFERENCES gallery_release(id) DEFERRABLE INITIALLY DEFERRED

louvre-d-# \d gallery_release_parent_releases
                                 Table "public.gallery_release_parent_releases"
     Column      |  Type   | Collation | Nullable |                           Default                           
-----------------+---------+-----------+----------+-------------------------------------------------------------
 id              | integer |           | not null | nextval('gallery_release_parent_releases_id_seq'::regclass)
 from_release_id | integer |           | not null | 
 to_release_id   | integer |           | not null | 
Indexes:
    "gallery_release_parent_releases_pkey" PRIMARY KEY, btree (id)
    "gallery_release_parent_r_from_release_id_to_relea_52522776_uniq" UNIQUE CONSTRAINT, btree (from_release_id, to_release_id)
    "gallery_release_parent_releases_from_release_id_f3f8befa" btree (from_release_id)
    "gallery_release_parent_releases_to_release_id_fc3c2e08" btree (to_release_id)
Foreign-key constraints:
    "gallery_release_pare_from_release_id_f3f8befa_fk_gallery_r" FOREIGN KEY (from_release_id) REFERENCES gallery_release(id) DEFERRABLE INITIALLY DEFERRED
    "gallery_release_pare_to_release_id_fc3c2e08_fk_gallery_r" FOREIGN KEY (to_release_id) REFERENCES gallery_release(id) DEFERRABLE INITIALLY DEFERRED