From f869d8d489adb90b3dfd7babb8bbea932ae0dfe5 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sat, 27 Aug 2011 00:30:15 -0400 Subject: [PATCH] Bug 6716 - Document subscriptionroutinglist table This table holds information related to serials routing lists. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6b5075be86..078a6e4481 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1807,11 +1807,11 @@ CREATE TABLE `subscriptionhistory` ( -- DROP TABLE IF EXISTS `subscriptionroutinglist`; -CREATE TABLE `subscriptionroutinglist` ( - `routingid` int(11) NOT NULL auto_increment, - `borrowernumber` int(11) NOT NULL, - `ranking` int(11) default NULL, - `subscriptionid` int(11) NOT NULL, +CREATE TABLE `subscriptionroutinglist` ( -- information related to the routing lists attached to subscriptions + `routingid` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines with patron is on the routing list + `ranking` int(11) default NULL, -- where the patron stands in line to receive the serial + `subscriptionid` int(11) NOT NULL, -- foreign key from the subscription table, defines which subscription this routing list is for PRIMARY KEY (`routingid`), UNIQUE (`subscriptionid`, `borrowernumber`), CONSTRAINT `subscriptionroutinglist_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) -- 2.20.1