Lines 1821-1858
CREATE TABLE `subscriptionroutinglist` (
Link Here
|
1821 |
-- |
1821 |
-- |
1822 |
|
1822 |
|
1823 |
DROP TABLE IF EXISTS `suggestions`; |
1823 |
DROP TABLE IF EXISTS `suggestions`; |
1824 |
CREATE TABLE `suggestions` ( |
1824 |
CREATE TABLE `suggestions` ( -- purchase suggestions |
1825 |
`suggestionid` int(8) NOT NULL auto_increment, |
1825 |
`suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha |
1826 |
`suggestedby` int(11) NOT NULL default 0, |
1826 |
`suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table |
1827 |
`suggesteddate` date NOT NULL default 0, |
1827 |
`suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted |
1828 |
`managedby` int(11) default NULL, |
1828 |
`managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table |
1829 |
`manageddate` date default NULL, |
1829 |
`manageddate` date default NULL, -- date the suggestion was updated |
1830 |
acceptedby INT(11) default NULL, |
1830 |
acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table |
1831 |
accepteddate date default NULL, |
1831 |
accepteddate date default NULL, -- date the suggestion was marked as accepted |
1832 |
rejectedby INT(11) default NULL, |
1832 |
rejectedby INT(11) default NULL, -- borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table |
1833 |
rejecteddate date default NULL, |
1833 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
1834 |
`STATUS` varchar(10) NOT NULL default '', |
1834 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
1835 |
`note` mediumtext, |
1835 |
`note` mediumtext, -- note entered on the suggestion |
1836 |
`author` varchar(80) default NULL, |
1836 |
`author` varchar(80) default NULL, -- author of the suggested item |
1837 |
`title` varchar(80) default NULL, |
1837 |
`title` varchar(80) default NULL, -- title of the suggested item |
1838 |
`copyrightdate` smallint(6) default NULL, |
1838 |
`copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item |
1839 |
`publishercode` varchar(255) default NULL, |
1839 |
`publishercode` varchar(255) default NULL, -- publisher of the suggested item |
1840 |
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
1840 |
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the suggestion was updated |
1841 |
`volumedesc` varchar(255) default NULL, |
1841 |
`volumedesc` varchar(255) default NULL, |
1842 |
`publicationyear` smallint(6) default 0, |
1842 |
`publicationyear` smallint(6) default 0, |
1843 |
`place` varchar(255) default NULL, |
1843 |
`place` varchar(255) default NULL, -- publication place of the suggested item |
1844 |
`isbn` varchar(30) default NULL, |
1844 |
`isbn` varchar(30) default NULL, -- isbn of the suggested item |
1845 |
`mailoverseeing` smallint(1) default 0, |
1845 |
`mailoverseeing` smallint(1) default 0, |
1846 |
`biblionumber` int(11) default NULL, |
1846 |
`biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered |
1847 |
`reason` text, |
1847 |
`reason` text, -- reason for making the suggestion |
1848 |
budgetid INT(11), |
1848 |
budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table |
1849 |
branchcode VARCHAR(10) default NULL, |
1849 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
1850 |
collectiontitle text default NULL, |
1850 |
collectiontitle text default NULL, -- collection name for the suggested item |
1851 |
itemtype VARCHAR(30) default NULL, |
1851 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
1852 |
quantity SMALLINT(6) default NULL, |
1852 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
1853 |
currency VARCHAR(3) default NULL, |
1853 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
1854 |
price DECIMAL(28,6) default NULL, |
1854 |
price DECIMAL(28,6) default NULL, -- suggested price |
1855 |
total DECIMAL(28,6) default NULL, |
1855 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
1856 |
PRIMARY KEY (`suggestionid`), |
1856 |
PRIMARY KEY (`suggestionid`), |
1857 |
KEY `suggestedby` (`suggestedby`), |
1857 |
KEY `suggestedby` (`suggestedby`), |
1858 |
KEY `managedby` (`managedby`) |
1858 |
KEY `managedby` (`managedby`) |
1859 |
- |
|
|