The Music Data table contains song title and artist information, typically imported from a music scheduling system. Its on-disk name is: Music.nx1
Music Data Table Field Definitions
The fields contained in the Music Data table, including field type and size (if applicable).
Field Name |
Type |
Size |
Description |
|---|---|---|---|
ID |
AutoInc |
|
Each time a Music Data record is created, a unique ID value is automatically assigned by the system. This value is used to identify the record and is not user-modifiable. |
StationID |
Integer |
|
The work station to which this record is assigned. |
CartNo |
String |
8 |
The cart number of the song record. |
Title |
String |
70 |
The title of the song. |
Artist |
String |
70 |
The song's artist. |
RunTime |
Time |
|
The song's run length. |
SongCat |
String |
16 |
The song's Category, as defined by a music scheduling system. |
Album |
String |
70 |
The album in which the song appeared. |
RelYear |
Integer |
|
The year the song was released. |
Intro |
String |
3 |
The song's intro time, in seconds. |
Ending |
String |
3 |
The song's end type code. |
Misc |
String |
70 |
A miscellaneous information field. |
Data01 |
BLOB |
|
<Not used, for future expansion> |
RecCreateDate |
Date/Time |
|
The date and time the record was created. |
RecEditDate |
Date/Time |
|
The date and time the record was last edited. |
RecEditBy |
String |
30 |
The user who last edited the record. |
