First release date at musicbrainz DB

baklanaft · June 13, 2019, 2:30pm

Previously, release information could be found in the release_group_meta table.
How can I find “first-release-date” in DB (not xml) now?

yvanzo · June 13, 2019, 6:15pm

It is still the case, columns are:

first_release_date_year
first_release_date_month
first_release_date_day

baklanaft · June 14, 2019, 7:28am

Was the query in which table these columns?

Freso · June 14, 2019, 7:31am

They’re in the release_group_meta table:

github.com

metabrainz/musicbrainz-server/blob/48389bc8c77099f35fe6e690aff5d6dcd396586e/admin/sql/CreateTables.sql#L3101-L3109


CREATE TABLE release_group_meta ( -- replicate
    id                  INTEGER NOT NULL, -- PK, references release_group.id CASCADE
    release_count       INTEGER NOT NULL DEFAULT 0,
    first_release_date_year   SMALLINT,
    first_release_date_month  SMALLINT,
    first_release_date_day    SMALLINT,
    rating              SMALLINT CHECK (rating >= 0 AND rating <= 100),
    rating_count        INTEGER
);