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
|
