New Releases Database Schema

This is a very reduced set of database tables for keeping track of rather extensive lists of new releases. The main purpose here is to be able to kick out info on what's new/recent/forthcoming at any given point, so the release dates are key, and the label info is a major organizing point, but artist info much less unimportant.

Table: nr_label
idint unsigned auto_increment primary key: ID, used by other tables to refer to a label.
namevarchar(250) not null: Label name. These are encoded hierarchically.
urlvarchar(250) null: Label website.
contactvarchar(250) null: Label contact info.
Table: nr_album
idint unsigned auto_increment primary key: ID, used by other tables to refer to an album/release.
artistvarchar(250) null: Artist name.
titlevarchar(250) not null: Album title.
sortvarchar(128) not null: Sort key for artist and/or title.
labelint unsigned references nr_label.id: Label.
labelidvarchar(32) null: Label number/identifier.
reldatedate not null: Release date.
reissuesmallint default 0: Reissue status: 0 = new release of current/recent music; 1 = reissue, compilation, or vault music.
prioritysmallint default 0: Priority value: a small integer, where 0 = just for completism; 1 = potentially interesting; 2 = seen some secondary references; 3 = have some personal interest in the release; 4 = definitely on wish list; 5 = own it.

At some future point we'll probably want to extend this table to make reference to the other Terminal Zone tables.