Lines 2848-2853
CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
Link Here
|
2848 |
KEY `booksellerid` (`booksellerid`), |
2848 |
KEY `booksellerid` (`booksellerid`), |
2849 |
KEY `basketgroupid` (`basketgroupid`), |
2849 |
KEY `basketgroupid` (`basketgroupid`), |
2850 |
KEY `contractnumber` (`contractnumber`), |
2850 |
KEY `contractnumber` (`contractnumber`), |
|
|
2851 |
KEY `authorisedby` (`authorisedby`), |
2851 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
2852 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
2852 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
2853 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
2853 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
2854 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
Lines 2902-2907
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
2902 |
PRIMARY KEY (`id`), |
2903 |
PRIMARY KEY (`id`), |
2903 |
KEY `listprice` (`listprice`), |
2904 |
KEY `listprice` (`listprice`), |
2904 |
KEY `invoiceprice` (`invoiceprice`), |
2905 |
KEY `invoiceprice` (`invoiceprice`), |
|
|
2906 |
KEY `name` (`name`(255)), |
2905 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2907 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2906 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2908 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2907 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2909 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
Lines 2927-2933
CREATE TABLE `aqbudgets` ( -- information related to Funds
Link Here
|
2927 |
`sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund |
2929 |
`sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund |
2928 |
`budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber) |
2930 |
`budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber) |
2929 |
`budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone) |
2931 |
`budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone) |
2930 |
PRIMARY KEY (`budget_id`) |
2932 |
PRIMARY KEY (`budget_id`), |
|
|
2933 |
KEY `budget_parent_id` (`budget_parent_id`), |
2934 |
KEY `budget_code` (`budget_code`), |
2935 |
KEY `budget_branchcode` (`budget_branchcode`), |
2936 |
KEY `budget_period_id` (`budget_period_id`), |
2937 |
KEY `budget_owner_id` (`budget_owner_id`), |
2931 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2938 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2932 |
|
2939 |
|
2933 |
-- |
2940 |
-- |
Lines 2980-2985
CREATE TABLE `aqbudgets_planning` (
Link Here
|
2980 |
`authvalue` varchar(30) NOT NULL, |
2987 |
`authvalue` varchar(30) NOT NULL, |
2981 |
`display` tinyint(1) DEFAULT 1, |
2988 |
`display` tinyint(1) DEFAULT 1, |
2982 |
PRIMARY KEY (`plan_id`), |
2989 |
PRIMARY KEY (`plan_id`), |
|
|
2990 |
KEY `budget_period_id` (`budget_period_id`), |
2983 |
CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE |
2991 |
CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE |
2984 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2992 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2985 |
|
2993 |
|
Lines 3070-3075
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3070 |
KEY `basketno` (`basketno`), |
3078 |
KEY `basketno` (`basketno`), |
3071 |
KEY `biblionumber` (`biblionumber`), |
3079 |
KEY `biblionumber` (`biblionumber`), |
3072 |
KEY `budget_id` (`budget_id`), |
3080 |
KEY `budget_id` (`budget_id`), |
|
|
3081 |
KEY `parent_ordernumber` (`parent_ordernumber`), |
3082 |
KEY `orderstatus` (`orderstatus`), |
3073 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3083 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3074 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
3084 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
3075 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3085 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3076 |
- |
|
|