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" />

The simplified version of our releases is a slightly denormalized version, meaning that we have deliberately not followed the principles of the third normal form. We still provide a fully normalized version that you can decide to import if it should become necessary.

</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)
);