internal_mapping

CREATE TABLE apple_internal_mapping
(
  id             BIGSERIAL PRIMARY KEY NOT NULL,
  from_uuid      UUID                  NOT NULL,
  to_uuid        UUID                  NOT NULL,
  to_provider_id INTEGER               NOT NULL,
  entity_type    INTEGER               NOT NULL
);
CREATE INDEX apple_internal_mapping_from_uuid_idx
  ON apple_internal_mapping USING BTREE (from_uuid);
CREATE UNIQUE INDEX apple_internal_mapping_unique_idx
  ON apple_internal_mapping (from_uuid, to_uuid);
CREATE INDEX apple_internal_mapping_entity_type_idx
  ON apple_internal_mapping (entity_type);

CREATE TABLE spotify_internal_mapping
(
  id             BIGSERIAL PRIMARY KEY NOT NULL,
  from_uuid      UUID                  NOT NULL,
  to_uuid        UUID                  NOT NULL,
  to_provider_id INTEGER               NOT NULL,
  entity_type    INTEGER               NOT NULL
);
CREATE INDEX spotify_internal_mapping_from_uuid_idx
  ON spotify_internal_mapping USING BTREE (from_uuid);
CREATE UNIQUE INDEX spotify_internal_mapping_unique_idx
  ON spotify_internal_mapping (from_uuid, to_uuid);
CREATE INDEX spotify_internal_mapping_entity_type_idx
  ON spotify_internal_mapping (entity_type);