2015:GC15UX:JDISC Schema

From MIREX Wiki

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