# Pastebin vwSq0ord messybrainz=> \d recording_json; Table "public.recording_json" Column | Type | Modifiers -------------+---------------+------------------------------------------------------------- id | integer | not null default nextval('recording_json_id_seq'::regclass) data | json | not null data_sha256 | character(64) | not null meta_sha256 | character(64) | not null Indexes: "recording_json_pkey" PRIMARY KEY, btree (id) "data_sha256_ndx_recording_json" UNIQUE, btree (data_sha256) "id_ndx_recording_json" UNIQUE, btree (id) "data_artist_mbids_ndx_recording_json" btree ((data ->> 'artist_mbids'::text)) "data_recording_mbid_ndx_recording_json" btree ((data ->> 'recording_mbid'::text)) "data_release_mbid_ndx_recording_json" btree ((data ->> 'release_mbid'::text)) "meta_sha256_ndx_recording_json" btree (meta_sha256) Referenced by: TABLE "recording" CONSTRAINT "recording_fk_recording_json" FOREIGN KEY (data) REFERENCES recording_json(id)