|
Lines 2853-2858
CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
Link Here
|
| 2853 |
KEY `booksellerid` (`booksellerid`), |
2853 |
KEY `booksellerid` (`booksellerid`), |
| 2854 |
KEY `basketgroupid` (`basketgroupid`), |
2854 |
KEY `basketgroupid` (`basketgroupid`), |
| 2855 |
KEY `contractnumber` (`contractnumber`), |
2855 |
KEY `contractnumber` (`contractnumber`), |
|
|
2856 |
KEY `authorisedby` (`authorisedby`), |
| 2856 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
2857 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
| 2857 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
2858 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
| 2858 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
2859 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
|
Lines 2907-2912
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
| 2907 |
PRIMARY KEY (`id`), |
2908 |
PRIMARY KEY (`id`), |
| 2908 |
KEY `listprice` (`listprice`), |
2909 |
KEY `listprice` (`listprice`), |
| 2909 |
KEY `invoiceprice` (`invoiceprice`), |
2910 |
KEY `invoiceprice` (`invoiceprice`), |
|
|
2911 |
KEY `name` (`name`(255)), |
| 2910 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2912 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2911 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2913 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2912 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2914 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
Lines 2932-2938
CREATE TABLE `aqbudgets` ( -- information related to Funds
Link Here
|
| 2932 |
`sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund |
2934 |
`sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund |
| 2933 |
`budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber) |
2935 |
`budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber) |
| 2934 |
`budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone) |
2936 |
`budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone) |
| 2935 |
PRIMARY KEY (`budget_id`) |
2937 |
PRIMARY KEY (`budget_id`), |
|
|
2938 |
KEY `budget_parent_id` (`budget_parent_id`), |
| 2939 |
KEY `budget_code` (`budget_code`), |
| 2940 |
KEY `budget_branchcode` (`budget_branchcode`), |
| 2941 |
KEY `budget_period_id` (`budget_period_id`), |
| 2942 |
KEY `budget_owner_id` (`budget_owner_id`) |
| 2936 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2943 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2937 |
|
2944 |
|
| 2938 |
-- |
2945 |
-- |
|
Lines 2985-2990
CREATE TABLE `aqbudgets_planning` (
Link Here
|
| 2985 |
`authvalue` varchar(30) NOT NULL, |
2992 |
`authvalue` varchar(30) NOT NULL, |
| 2986 |
`display` tinyint(1) DEFAULT 1, |
2993 |
`display` tinyint(1) DEFAULT 1, |
| 2987 |
PRIMARY KEY (`plan_id`), |
2994 |
PRIMARY KEY (`plan_id`), |
|
|
2995 |
KEY `budget_period_id` (`budget_period_id`), |
| 2988 |
CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE |
2996 |
CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2989 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2997 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2990 |
|
2998 |
|
|
Lines 3074-3079
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
| 3074 |
KEY `basketno` (`basketno`), |
3082 |
KEY `basketno` (`basketno`), |
| 3075 |
KEY `biblionumber` (`biblionumber`), |
3083 |
KEY `biblionumber` (`biblionumber`), |
| 3076 |
KEY `budget_id` (`budget_id`), |
3084 |
KEY `budget_id` (`budget_id`), |
|
|
3085 |
KEY `parent_ordernumber` (`parent_ordernumber`), |
| 3086 |
KEY `orderstatus` (`orderstatus`), |
| 3077 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3087 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3078 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
3088 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3079 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3089 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 3080 |
- |
|
|