Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. messybrainz=> \d recording_json
  2. Table "public.recording_json"
  3. Column | Type | Modifiers
  4. -------------+---------------+--------------------------------------------------------------
  5. id | integer | not null default nextval('recording_json_id_seq1'::regclass)
  6. data | jsonb | not null
  7. data_sha256 | character(64) | not null
  8. meta_sha256 | character(64) | not null
  9. Indexes:
  10. "recording_json_pkey" PRIMARY KEY, btree (id)
  11. "artist_mbid_array_ndx_recording_json" btree (convert_json_array_to_sorted_uuid_array((data -> 'artist_mbids'::text)::json))
  12. "artist_mbid_ndx_recording_json" btree ((data ->> 'artist_mbids'::text))
  13. "recording_mbid_ndx_recording_json" btree ((data ->> 'recording_mbid'::text))
  14. "release_mbid_ndx_recording_json" btree ((data ->> 'release_mbid'::text))
  15. Referenced by:
  16. TABLE "recording" CONSTRAINT "recording_fk_recording_json" FOREIGN KEY (data) REFERENCES recording_json(id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement