Lines 1958-1963
CREATE TABLE `serial` ( -- issues related to subscriptions
Link Here
|
1958 |
`biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to |
1958 |
`biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to |
1959 |
`subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of |
1959 |
`subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of |
1960 |
`serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) |
1960 |
`serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) |
|
|
1961 |
`serialseq_x` varchar( 100 ) NULL DEFAULT NULL, -- first part of issue information |
1962 |
`serialseq_y` varchar( 100 ) NULL DEFAULT NULL, -- second part of issue information |
1963 |
`serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information |
1961 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1964 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1962 |
`planneddate` date default NULL, -- date expected |
1965 |
`planneddate` date default NULL, -- date expected |
1963 |
`notes` text, -- notes |
1966 |
`notes` text, -- notes |
1964 |
- |
|
|