Lines 661-667
CREATE TABLE `deleteditems` (
Link Here
|
661 |
`onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) |
661 |
`onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) |
662 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
662 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
663 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
663 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
664 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
664 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
665 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
665 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
666 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
666 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
667 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
667 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
Lines 923-929
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
923 |
`onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) |
923 |
`onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) |
924 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
924 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
925 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
925 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
926 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
926 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
927 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
927 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
928 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
928 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
929 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
929 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
Lines 1988-1994
CREATE TABLE `statistics` ( -- information related to transactions (circulation
Link Here
|
1988 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
1988 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
1989 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower |
1989 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower |
1990 |
`associatedborrower` int(11) default NULL, -- unused in Koha |
1990 |
`associatedborrower` int(11) default NULL, -- unused in Koha |
1991 |
`ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code |
1991 |
`ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code |
1992 |
KEY `timeidx` (`datetime`), |
1992 |
KEY `timeidx` (`datetime`), |
1993 |
KEY `branch_idx` (`branch`), |
1993 |
KEY `branch_idx` (`branch`), |
1994 |
KEY `proccode_idx` (`proccode`), |
1994 |
KEY `proccode_idx` (`proccode`), |
Lines 2640-2646
CREATE TABLE branch_transfer_limits (
Link Here
|
2640 |
toBranch varchar(10) NOT NULL, |
2640 |
toBranch varchar(10) NOT NULL, |
2641 |
fromBranch varchar(10) NOT NULL, |
2641 |
fromBranch varchar(10) NOT NULL, |
2642 |
itemtype varchar(10) NULL, |
2642 |
itemtype varchar(10) NULL, |
2643 |
ccode varchar(10) NULL, |
2643 |
ccode varchar(80) NULL, |
2644 |
PRIMARY KEY (limitId) |
2644 |
PRIMARY KEY (limitId) |
2645 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2645 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2646 |
|
2646 |
|
Lines 3794-3800
CREATE TABLE `course_items` (
Link Here
|
3794 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id |
3794 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id |
3795 |
`itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve |
3795 |
`itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve |
3796 |
`itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional) |
3796 |
`itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional) |
3797 |
`ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional) |
3797 |
`ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional) |
3798 |
`holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional) |
3798 |
`holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional) |
3799 |
`location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional) |
3799 |
`location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional) |
3800 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' |
3800 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' |
3801 |
- |
|
|