6.14 Links between musical works and resources file

The file describing the links between the musical works described in the musical works file and sound recordings or music videos described in the resources file, shall be called workresourcelinks.tsv and be referenced in the manifest file's TableType as WorkResourceLinks. It shall contain none, one or more data Records as follows:

Cell name

Definition

Data type

M/O/C

Example

1

LinkRecordId

The identifier of the link Record that identifies a link between a musical work and a resource,which shall be internally unique to the BWARM data feed.

This may be the primary key for the Record in the BWARM data feed sender’s links database table recordings (see Figure 2).

String

M

90ERF11

2

MusicalWorkId

The identifier of the Record describing the musical work which is the subject of this link Record that links the musical work to a resource the Record identifier for which, in turn, is in the ResourceRecordId Cell.

This may be a foreign key to the record in the BWARM data feed sender’s resources database table (see Figure 2).

String

M

165DE541A

3

ResourceRecordId

The identifier of the Record describing the resource which is the subject of this link Record that links the resource to a musical work the Record identifier for which is, in turn, in the MusicalWorkRecordId Cell.

This may be a foreign key to the record in the BWARM data feed sender’s musical works database table (see Figure 2).

String

M

U124X987