Release data is delivered in two formats. To start, we feel that the “simplified” or flattened version works best.

<aside> <img src="/icons/warning_orange.svg" alt="/icons/warning_orange.svg" width="40px" />

Simplified version of releases a denormalized into a flattened structure. Because is simplified it is not able to represent all of the data about a release but it attempts to include adjacent information without the need to join multiple files together. We also provide normalized metadata files if the simplified does not work for your use case.

</aside>

The simplified version contains a lot of information about releases, such as:

• Title
• Primary author (the “display artist”)
• ISBN and GTIN13
• Series id and name
• Licensor id and name
• Label id and name
• Timestamps:
  • Added
  • Last modified
  • Media available from
• Release type (audiobook, ebook, podcast)
• Language (including original language)
• Copyright statement
• Limited shop information, separate columns for subscription, purchased, free and discoverable shops.
• Track count.
• Duration

Since we’ve included both identifiers and text content for any properties added here, you can chose to start out with the simplified releases, and add any additional, more advanced relations later.

Base table

To create the table, we recommend the following structure:

CREATE TABLE IF NOT EXISTS RELEASES_SIMPLIFIED (
	RELEASE_ID VARCHAR,
	ISBN VARCHAR(16777216),
	GTIN13 VARCHAR(16777216),
	TITLE VARCHAR(16777216),
	DISPLAY_ARTIST VARCHAR(16777216),
	SERIES_ID VARCHAR,
	SERIES_NAME VARCHAR(16777216),
	LICENSOR_ID VARCHAR,
	LICENSOR VARCHAR(16777216),
	LABEL_ID VARCHAR,
	LABEL VARCHAR(16777216),
	ADDED TIMESTAMP_TZ(9),
	LAST_MOD TIMESTAMP_TZ(9),
	MEDIA_AVAILABLE_FROM TIMESTAMP_TZ(9),
	RELEASE_TYPE VARCHAR(16777216),
	RELEASE_DATE TIMESTAMP_TZ(9),
	LANG VARCHAR(16777216),
	ORIGINAL_LANG VARCHAR(16777216),
	ORIGINAL_TITLE VARCHAR(16777216),
	COPYRIGHT VARCHAR(16777216),
	SHOP_SUBSCRIPTION BOOLEAN,
	SHOP_PURCHASED BOOLEAN,
	SHOP_FREE BOOLEAN,
	SHOP_DISCOVERABLE BOOLEAN,
	TRACK_COUNT NUMBER(38,0),
	DURATION VARCHAR(16777216),
	CONSTRAINT PKEY PRIMARY KEY (RELEASE_ID)
);