Lines 602-615
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
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 |
`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 |
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 |
`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 |
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 |
`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 (YYY-MM-DD) |
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 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
606 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
607 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
607 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
608 |
`contactfirstname` text, -- used for children to include first name of guarentor |
608 |
`contactfirstname` text, -- used for children to include first name of guarantor |
609 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
609 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
610 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
610 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
611 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
611 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
612 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
612 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
613 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
613 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
614 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
614 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
615 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
615 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
Lines 627-633
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
627 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
627 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
628 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
628 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
629 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
629 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
630 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
630 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
631 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
631 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
632 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
632 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
633 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
633 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
Lines 1639-1654
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1639 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
1639 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
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 |
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 |
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 |
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 |
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 (YYY-MM-DD) |
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) |
1643 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
1643 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
1644 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
1644 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
1645 |
`contactfirstname` text, -- used for children to include first name of guarentor |
1645 |
`contactfirstname` text, -- used for children to include first name of guarantor |
1646 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
1646 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
1647 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
1647 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
1648 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
1648 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
1649 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
1649 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
1650 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
1650 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
1651 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
1651 |
`password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password |
1652 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
1652 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
1653 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
1653 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
1654 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
1654 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
Lines 1664-1670
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1664 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
1664 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
1665 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
1665 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
1666 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
1666 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
1667 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
1667 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
1668 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
1668 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
1669 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
1669 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
1671 |
- |
|
|