Area

class django_musicbrainz_connector.models.Area(*args, **kwargs)

PostgreSQL Definition

The area table is defined in the MusicBrainz Server as:

CREATE TABLE area ( -- replicate (verbose)
    id                  SERIAL, -- PK
    gid                 uuid NOT NULL,
    name                VARCHAR NOT NULL,
    type                INTEGER, -- references area_type.id
    edits_pending       INTEGER NOT NULL DEFAULT 0 CHECK (edits_pending >=0),
    last_updated        TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    begin_date_year     SMALLINT,
    begin_date_month    SMALLINT,
    begin_date_day      SMALLINT,
    end_date_year       SMALLINT,
    end_date_month      SMALLINT,
    end_date_day        SMALLINT,
    ended               BOOLEAN NOT NULL DEFAULT FALSE
    CHECK (
        (
        -- If any end date fields are not null, then ended must be true
        (end_date_year IS NOT NULL OR
        end_date_month IS NOT NULL OR
        end_date_day IS NOT NULL) AND
        ended = TRUE
        ) OR (
        -- Otherwise, all end date fields must be null
        (end_date_year IS NULL AND
        end_date_month IS NULL AND
        end_date_day IS NULL)
        )
    ),
    comment             VARCHAR(255) NOT NULL DEFAULT ''
);