Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- messybrainz=> \d recording_json
- Table "public.recording_json"
- Column | Type | Modifiers
- -------------+---------------+--------------------------------------------------------------
- id | integer | not null default nextval('recording_json_id_seq1'::regclass)
- data | jsonb | not null
- data_sha256 | character(64) | not null
- meta_sha256 | character(64) | not null
- Indexes:
- "recording_json_pkey" PRIMARY KEY, btree (id)
- "artist_mbid_array_ndx_recording_json" btree (convert_json_array_to_sorted_uuid_array((data -> 'artist_mbids'::text)::json))
- "artist_mbid_ndx_recording_json" btree ((data ->> 'artist_mbids'::text))
- "recording_mbid_ndx_recording_json" btree ((data ->> 'recording_mbid'::text))
- "release_mbid_ndx_recording_json" btree ((data ->> 'release_mbid'::text))
- Referenced by:
- TABLE "recording" CONSTRAINT "recording_fk_recording_json" FOREIGN KEY (data) REFERENCES recording_json(id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement