Yun Hao at 06:55, 28 July 2015

2015-07-28T06:55:11Z

Yun Hao: Created page with "More details about each table are shown as below (also in alphabetical order): {| class="wikitable" |+ composition |- ! Column ! Description |- | id || auto_increment |- | titl..."

2015-07-28T06:51:58Z

Created page with "More details about each table are shown as below (also in alphabetical order): {| class="wikitable" |+ composition |- ! Column ! Description |- | id || auto_increment |- | titl..."

New page

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

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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
|}

← Older revision		Revision as of 06:55, 28 July 2015
Line 1:		Line 1:
−	More details about each table are shown as below (~~also~~ in alphabetical order):	+	More details about each table are shown as below (in alphabetical order):

	{\| class="wikitable"		{\| class="wikitable"

2015:GC15UX:JDISC Schema - Revision history

Yun Hao at 06:55, 28 July 2015

Yun Hao: Created page with "More details about each table are shown as below (also in alphabetical order): {| class="wikitable" |+ composition |- ! Column ! Description |- | id || auto_increment |- | titl..."