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 | |
|---|---|
| id | int unsigned auto_increment primary key: ID, used by other tables to refer to a label. |
| name | varchar(250) not null: Label name. These are encoded hierarchically. |
| url | varchar(250) null: Label website. |
| contact | varchar(250) null: Label contact info. |
| Table: nr_album | |
| id | int unsigned auto_increment primary key: ID, used by other tables to refer to an album/release. |
| artist | varchar(250) null: Artist name. |
| title | varchar(250) not null: Album title. |
| sort | varchar(128) not null: Sort key for artist and/or title. |
| label | int unsigned references nr_label.id: Label. |
| labelid | varchar(32) null: Label number/identifier. |
| reldate | date not null: Release date. |
| reissue | smallint default 0: Reissue status: 0 = new release of current/recent music; 1 = reissue, compilation, or vault music. |
| priority | smallint 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.