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 |
- |
|
|