2015:GC15UX:JDISC Schema

More details about each table are shown as below (in alphabetical order):

composition

Column	Description
id	auto_increment
title	Human-readable primary title for this composition
jdisc_nid	Legacy JDISC node ID for this composition
jdisc_vid	Legacy JDISC version ID for this composition

composition_composer

Column	Description
composition	Reference to the composition composed by this person
composer	Reference to a person who composed this composition
order_key	Ordering of this composer, relative to this composition

composition_lyricist

Column	Description
composition	Reference to the composition with lyrics by this person
lyricist	Reference to a person who wrote lyrics for this composition
order_key	Ordering of this lyricist, relative to this composition

composition_title

Column	Description
id	auto_increment
composition	Reference to the composition for which this is an alternative title
title	Alternative title for this composition
order_key	Ordering of the titles relative to the composition

issue

Column	Description
id	auto_increment
name	Human-readable title for this release
alternate_leader	Reference to the alternate leader on this release
label_name	Name of the issuing label
catalog_number	Catalog number given to this release by the label or company
date	Date of this release
format	Physical medium of this release (LP, CD, etc.)
num_channels	Number of audio channels used for this release
length	Textual representation of the playing time of this release
status	Status of this release (original, reissue, etc.)
producer	Reference to the person who produced this release
master_engineer	Reference to the person who mastered this release
reissue_producer	Reference to the person who produced this reissued release, if applicable
reissue_engineer	Reference to the person who engineered this reissued release, if applicable
remaster	Indicates that this release was remastered
remaster_engineer	Reference to the person who engineered the remastering process, if applicable
remix	Indicates that this release is a remix
remix_engineer	Reference to the person who engineered the remixing process, if applicable
overdub	Indicates that this release has tracks combined (overdubbed) from multiple sessions
method_notes	Free text notes on the post-production editing process for this release
editing_facility	Name of the facility where this release was edited
liner_notes_author	Reference to the person who wrote the notes for this release
language	Language of the text associated with this release (e.g., liner notes)
cover_artist	Reference to the person who created art for the release cover, if any
design_supervisor	Reference to the person who supervised the design of this release
photographer	Reference to the person who took photographs included in this release
release_details_value	Free text description of the release
release_details_format	1: filtered HTML; 2: raw HTML; 3: PHP code(!)
sources	Free text listing of sources for information about this release
jdisc_nid	Legacy JDISC node ID for this release
jdisc_vid	Legacy JDISC version ID for this release

issue_leader

Column	Description
issue	Reference to the release being led
person	Reference to the person leading the release
order_key	Ordering of the leaders relative to the release

issue_overdub_people

Column	Description
issue	Reference to the release being overdubbed
person	Reference to the person working on the overdubbing
order_key	Ordering of the people relative to the release

issue_track

Column	Description
issue	Reference to the release on which this track appears
track	Reference to the track appearing on this release
order_key	Ordering of the tracks relative to the release

person

Column	Description
id	auto_increment
name	Best-known English name for this person
name_first	First or given name for this person
name_last	Last or family name for this person
alternate_name	Alternative name (usu. birth name) for this person
gender	Textual represenation of person’s gender
birth_date_earliest	Earliest possible date of person’s birth
birth_date_latest	Last possible date of person’s birth
birth_place	Textual representation of place of person’s birth, if known
region_origin	Textual representation of person’s region of origin, if known
jdisc_nid	Legacy JDISC node ID for this skill
jdisc_vid	Legacy JDISC version ID for this skill

person_ethnicity

Column	Description
id	auto_increment
person	Reference to the person being described
ethnicity	Textual description of the person’s ethnicity
order_key	Ordering of ethnicities relative to the person

person_session_skill

Column	Description
person	Reference to the person playing in this session
session	Reference to the session performed in by this person
skill	Reference to the skill performed by this person in this session
order_key	Ordering of the people relative to the session

person_skill

Column	Description
person	Reference to the person with this skill
skill	Reference to the skill held by this person
order_key	Ordering of the skills relative to the person

person_track_skill

Column	Description
person	Reference to the person playing (or not) on this track
track	Reference to the track performed on (or not) by this person
skill	Reference to the skill performed, or absence thereof, by this person in on this track
order_key	Ordering of the people relative to the track

session

Column	Description
id	auto_increment
name	Human-readable label for the session
venue_type	Type of venue where this session took place
venue_name	Name of the venue
venue_location	Location of the venue
label_name	Name of the record label recording this session
ensemble_size	Name of the size of the ensemble (trio, quartet, etc.)
company_name	Name of the company making the recording
parent_company_name	Name of the corporate parent of the recording company
producer	Reference to the person who produced the session
engineer	Reference to the person who was engineer for the session
date_earliest	Earliest possible date of the session
date_latest	Last possible date of the session
date_precision	Date certainty (as single character, y, m, or d)
session_details_value	Free text description of the session
session_details_format	1: filtered HTML; 2: raw HTML; 3: PHP code(!)
sources	Free text listing of sources for information about this recording
jdisc_nid	Legacy JDISC node ID for this session
jdisc_vid	Legacy JDISC version ID for this session

session_leader

Column	Description
session	Reference to the session being led
person	Reference to the person leading the session
order_key	Ordering of the leaders relative to the session

skill

Column	Description
id	auto_increment
name	English label for this skill or instrument
jdisc_nid	Legacy JDISC node ID for this skill
jdisc_vid	Legacy JDISC version ID for this skill

track

Column	Description
id	auto_increment
name	Human-readable title for the track
session	Reference to the session in which this track was recorded, if known
order_key	Ordering of the track relative to the session, if known
length	Textual representation of track length, mm:ss
matrix_number	Track identification code used by recording company
production_status	Textual representation of usage of track (master, alternate, etc.)
release_number	Textual representation of track usage on a release, possibly redundant with reified release information
splicing	Indicates if track was spliced with another recorded track for release
jdisc_nid	Legacy JDISC node ID for this track
jdisc_vid	Legacy JDISC version ID for this track

track_composition

Column	Description
track	Reference to the track as which this composition was recorded
composition	Reference to the composition recorded as this track
order_key	Ordering of the compositions relative to the track

track_soloist

Column	Description
track	Reference to the track on which this person had a solo
soloist	Reference to the person who had a solo on this track
order_key	Ordering of the soloists relative to the track