|
Music Data Table |
  
|
|
Music Data Table |
|
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. |
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. |