Table 9.16: Locationlog table layout

Column Name

Data Type

Remark

locLogIdId

integer

Primary Key

Date

datetime

Time/date log record created

MediaId

integer

Points to Media record

LocationId

integer

Points to Location record

NewVolStatus

integer

enum: Full, Archive, Append, Recycle, Purged Read-only, Disabled, Error, Busy, Used, Cleaning

Enabled

tinyint

Whether or not Volume is enabled