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`), |
2852 |
KEY `branch` (`branch`), |
2851 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
2853 |
CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, |
2852 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
2854 |
CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), |
2853 |
CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, |
2855 |
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`), |
2904 |
PRIMARY KEY (`id`), |
2903 |
KEY `listprice` (`listprice`), |
2905 |
KEY `listprice` (`listprice`), |
2904 |
KEY `invoiceprice` (`invoiceprice`), |
2906 |
KEY `invoiceprice` (`invoiceprice`), |
|
|
2907 |
KEY `name` (`name`(255)), |
2905 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2908 |
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 |
2909 |
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; |
2910 |
) 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 |
2930 |
`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) |
2931 |
`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) |
2932 |
`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`) |
2933 |
PRIMARY KEY (`budget_id`), |
|
|
2934 |
KEY `budget_parent_id` (`budget_parent_id`), |
2935 |
KEY `budget_code` (`budget_code`), |
2936 |
KEY `budget_branchcode` (`budget_branchcode`), |
2937 |
KEY `budget_period_id` (`budget_period_id`), |
2938 |
KEY `budget_owner_id` (`budget_owner_id`), |
2931 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2939 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2932 |
|
2940 |
|
2933 |
-- |
2941 |
-- |
Lines 2980-2985
CREATE TABLE `aqbudgets_planning` (
Link Here
|
2980 |
`authvalue` varchar(30) NOT NULL, |
2988 |
`authvalue` varchar(30) NOT NULL, |
2981 |
`display` tinyint(1) DEFAULT 1, |
2989 |
`display` tinyint(1) DEFAULT 1, |
2982 |
PRIMARY KEY (`plan_id`), |
2990 |
PRIMARY KEY (`plan_id`), |
|
|
2991 |
KEY `budget_id` (`budget_id`), |
2992 |
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 |
2993 |
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; |
2994 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2985 |
|
2995 |
|
Lines 3003-3008
CREATE TABLE aqcontacts (
Link Here
|
3003 |
serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages |
3013 |
serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages |
3004 |
booksellerid int(11) not NULL, |
3014 |
booksellerid int(11) not NULL, |
3005 |
PRIMARY KEY (id), |
3015 |
PRIMARY KEY (id), |
|
|
3016 |
KEY `booksellerid` (`booksellerid`), |
3006 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
3017 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
3007 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
3018 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
3008 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; |
3019 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; |
Lines 3020-3025
CREATE TABLE `aqcontract` (
Link Here
|
3020 |
`contractdescription` mediumtext, |
3031 |
`contractdescription` mediumtext, |
3021 |
`booksellerid` int(11) not NULL, |
3032 |
`booksellerid` int(11) not NULL, |
3022 |
PRIMARY KEY (`contractnumber`), |
3033 |
PRIMARY KEY (`contractnumber`), |
|
|
3034 |
KEY `booksellerid` (`booksellerid`), |
3023 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
3035 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
3024 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
3036 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
3025 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
3037 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
Lines 3070-3075
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3070 |
KEY `basketno` (`basketno`), |
3082 |
KEY `basketno` (`basketno`), |
3071 |
KEY `biblionumber` (`biblionumber`), |
3083 |
KEY `biblionumber` (`biblionumber`), |
3072 |
KEY `budget_id` (`budget_id`), |
3084 |
KEY `budget_id` (`budget_id`), |
|
|
3085 |
KEY `invoiceid` (`invoiceid`), |
3086 |
KEY `subscriptionid` (`subscriptionid`), |
3087 |
KEY `parent_ordernumber` (`parent_ordernumber`), |
3088 |
KEY `orderstatus` (`orderstatus`), |
3073 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3089 |
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, |
3090 |
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, |
3091 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
Lines 3135-3140
CREATE TABLE aqinvoices (
Link Here
|
3135 |
shipmentcost decimal(28,6) default NULL, -- shipment cost |
3151 |
shipmentcost decimal(28,6) default NULL, -- shipment cost |
3136 |
shipmentcost_budgetid int(11) default NULL, -- foreign key to aqbudgets, link the shipment cost to a budget |
3152 |
shipmentcost_budgetid int(11) default NULL, -- foreign key to aqbudgets, link the shipment cost to a budget |
3137 |
PRIMARY KEY (invoiceid), |
3153 |
PRIMARY KEY (invoiceid), |
|
|
3154 |
KEY `booksellerid` (`booksellerid`), |
3155 |
KEY `shipmentcost_budgetid` (`shipmentcost_budgetid`), |
3138 |
CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, |
3156 |
CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, |
3139 |
CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE |
3157 |
CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE |
3140 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3158 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3141 |
- |
|
|