Lines 1861-1867
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
1861 |
`isbn` varchar(30) default NULL, -- isbn of the suggested item |
1861 |
`isbn` varchar(30) default NULL, -- isbn of the suggested item |
1862 |
`mailoverseeing` smallint(1) default 0, |
1862 |
`mailoverseeing` smallint(1) default 0, |
1863 |
`biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered |
1863 |
`biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered |
1864 |
`reason` text, -- reason for making the suggestion |
1864 |
`reason` text, -- reason for accepting or rejecting the suggestion |
|
|
1865 |
`patronreason` text, -- reason for making the suggestion |
1865 |
budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table |
1866 |
budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table |
1866 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
1867 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
1867 |
collectiontitle text default NULL, -- collection name for the suggested item |
1868 |
collectiontitle text default NULL, -- collection name for the suggested item |