| serialid |
INT |
10 |
|
√ |
null |
|
|
unique key for the issue |
| biblionumber |
INT |
10 |
|
|
null |
|
| biblio.biblionumber |
serial_ibfk_1C |
|
foreign key for the biblio.biblionumber that this issue is attached to |
| subscriptionid |
INT |
10 |
|
|
null |
|
|
foreign key to the subscription.subscriptionid that this issue is part of |
| serialseq |
VARCHAR |
100 |
|
|
|
|
|
issue information (volume, number, etc) |
| serialseq_x |
VARCHAR |
100 |
√ |
|
null |
|
|
first part of issue information |
| serialseq_y |
VARCHAR |
100 |
√ |
|
null |
|
|
second part of issue information |
| serialseq_z |
VARCHAR |
100 |
√ |
|
null |
|
|
third part of issue information |
| status |
TINYINT |
3 |
|
|
0 |
|
|
status code for this issue (see manual for full descriptions) |
| planneddate |
DATE |
10 |
√ |
|
null |
|
|
date expected |
| notes |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
notes |
