Lines 600-605
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
600 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
600 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
601 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
601 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
602 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
602 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
|
|
603 |
`date_renewed` date default NULL, -- date the patron/borrower's card was last renewed |
603 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
604 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
604 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
605 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
605 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) |
606 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) |
Lines 1637-1642
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1637 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
1638 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
1638 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
1639 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
1639 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
1640 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
|
|
1641 |
`date_renewed` date default NULL, -- date the patron/borrower's card was last renewed |
1640 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
1642 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
1641 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
1643 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
1642 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) |
1644 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) |
Lines 3418-3423
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3418 |
`categorycode` varchar(10) DEFAULT NULL, |
3420 |
`categorycode` varchar(10) DEFAULT NULL, |
3419 |
`dateenrolled` date DEFAULT NULL, |
3421 |
`dateenrolled` date DEFAULT NULL, |
3420 |
`dateexpiry` date DEFAULT NULL, |
3422 |
`dateexpiry` date DEFAULT NULL, |
|
|
3423 |
`date_renewed` date default NULL, |
3421 |
`gonenoaddress` tinyint(1) DEFAULT NULL, |
3424 |
`gonenoaddress` tinyint(1) DEFAULT NULL, |
3422 |
`lost` tinyint(1) DEFAULT NULL, |
3425 |
`lost` tinyint(1) DEFAULT NULL, |
3423 |
`debarred` date DEFAULT NULL, |
3426 |
`debarred` date DEFAULT NULL, |