Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.