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