Bugzilla – Attachment 4987 Details for
Bug 6716
Database Documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6716 - Document Borrowers Table
Bug-6716---Document-Borrowers-Table.patch (text/plain), 9.87 KB, created by
Nicole C. Engard
on 2011-08-12 20:33:29 UTC
(
hide
)
Description:
Bug 6716 - Document Borrowers Table
Filename:
MIME Type:
Creator:
Nicole C. Engard
Created:
2011-08-12 20:33:29 UTC
Size:
9.87 KB
patch
obsolete
>From 3c8ab4ac18ba0e6aa3f9692243b40ec0993f96dc Mon Sep 17 00:00:00 2001 >From: Nicole C. Engard <nengard@bywatersolutions.com> >Date: Wed, 10 Aug 2011 17:07:08 -0400 >Subject: [PATCH] Bug 6716 - Document Borrowers Table > >This is the first of many patches that will document the SQL structure >in Koha. This patch adds comments to the borrowers table. >--- > installer/data/mysql/kohastructure.sql | 134 ++++++++++++++++---------------- > 1 files changed, 67 insertions(+), 67 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index e9edf25..30260a5 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -193,73 +193,73 @@ CREATE TABLE `biblioitems` ( > -- > > DROP TABLE IF EXISTS `borrowers`; >-CREATE TABLE `borrowers` ( >- `borrowernumber` int(11) NOT NULL auto_increment, >- `cardnumber` varchar(16) default NULL, >- `surname` mediumtext NOT NULL, >- `firstname` text, >- `title` mediumtext, >- `othernames` mediumtext, >- `initials` text, >- `streetnumber` varchar(10) default NULL, >- `streettype` varchar(50) default NULL, >- `address` mediumtext NOT NULL, >- `address2` text, >- `city` mediumtext NOT NULL, >- `state` text default NULL, >- `zipcode` varchar(25) default NULL, >- `country` text, >- `email` mediumtext, >- `phone` text, >- `mobile` varchar(50) default NULL, >- `fax` mediumtext, >- `emailpro` text, >- `phonepro` text, >- `B_streetnumber` varchar(10) default NULL, >- `B_streettype` varchar(50) default NULL, >- `B_address` varchar(100) default NULL, >- `B_address2` text default NULL, >- `B_city` mediumtext, >- `B_state` text default NULL, >- `B_zipcode` varchar(25) default NULL, >- `B_country` text, >- `B_email` text, >- `B_phone` mediumtext, >- `dateofbirth` date default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(10) NOT NULL default '', >- `dateenrolled` date default NULL, >- `dateexpiry` date default NULL, >- `gonenoaddress` tinyint(1) default NULL, >- `lost` tinyint(1) default NULL, >- `debarred` tinyint(1) default NULL, >- `contactname` mediumtext, >- `contactfirstname` text, >- `contacttitle` text, >- `guarantorid` int(11) default NULL, >- `borrowernotes` mediumtext, >- `relationship` varchar(100) default NULL, >- `ethnicity` varchar(50) default NULL, >- `ethnotes` varchar(255) default NULL, >- `sex` varchar(1) default NULL, >- `password` varchar(30) default NULL, >- `flags` int(11) default NULL, >- `userid` varchar(30) default NULL, >- `opacnote` mediumtext, >- `contactnote` varchar(255) default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- `altcontactfirstname` varchar(255) default NULL, >- `altcontactsurname` varchar(255) default NULL, >- `altcontactaddress1` varchar(255) default NULL, >- `altcontactaddress2` varchar(255) default NULL, >- `altcontactaddress3` varchar(255) default NULL, >- `altcontactstate` text default NULL, >- `altcontactzipcode` varchar(50) default NULL, >- `altcontactcountry` text default NULL, >- `altcontactphone` varchar(50) default NULL, >- `smsalertnumber` varchar(50) default NULL, >- `privacy` integer(11) DEFAULT '1' NOT NULL, >+CREATE TABLE `borrowers` ( --this table includes information about your patrons/borrowers/members >+ `borrowernumber` int(11) NOT NULL auto_increment, --primary key, Koha assigned ID number for patrons/borrowers >+ `cardnumber` varchar(16) default NULL, --unique key, library assigned ID number for patrons/borrowers >+ `surname` mediumtext NOT NULL, --patron/borrower's last name (surname) >+ `firstname` text, --patron/borrower's first name >+ `title` mediumtext, --patron/borrower's title, for example: Mr. or Mrs. >+ `othernames` mediumtext, --any other names associated with the patron/borrower >+ `initials` text, --initials for your patron/borrower >+ `streetnumber` varchar(10) default NULL, --the house number for your patron/borrower's primary address >+ `streettype` varchar(50) default NULL, --the street type (Rd., Blvd, etc) for your patron/borrower's primary address >+ `address` mediumtext NOT NULL, --the first address line for your patron/borrower's primary address >+ `address2` text, --the second address line for your patron/borrower's primary address >+ `city` mediumtext NOT NULL, --the city or town for your patron/borrower's primary address >+ `state` text default NULL, --the state or province for your patron/borrower's primary address >+ `zipcode` varchar(25) default NULL, --the zip or postal code for your patron/borrower's primary address >+ `country` text, --the country for your patron/borrower's primary address >+ `email` mediumtext, --the primary email address for your patron/borrower's primary address >+ `phone` text, --the primary phone number for your patron/borrower's primary address >+ `mobile` varchar(50) default NULL, --the other phone number for your patron/borrower's primary address >+ `fax` mediumtext, --the fax number for your patron/borrower's primary address >+ `emailpro` text, --the secondary email addres for your patron/borrower's primary address >+ `phonepro` text, --the secondary phone number for your patron/borrower's primary address >+ `B_streetnumber` varchar(10) default NULL --the house number for your patron/borrower's alternate address >+ `B_streettype` varchar(50) default NULL, --the street type (Rd., Blvd, etc) for your patron/borrower's alternate address >+ `B_address` varchar(100) default NULL, --the first address line for your patron/borrower's alternate address >+ `B_address2` text default NULL, --the second address line for your patron/borrower's alternate address >+ `B_city` mediumtext, --the city or town for your patron/borrower's alternate address >+ `B_state` text default NULL, --the state for your patron/borrower's alternate address >+ `B_zipcode` varchar(25) default NULL, --the zip or postal code for your patron/borrower's alternate address >+ `B_country` text, --the country for your patron/borrower's alternate address >+ `B_email` text, --the patron/borrower's alternate email address >+ `B_phone` mediumtext, --the patron/borrower's alternate phone number >+ `dateofbirth` date default NULL, --the patron/borrower's date of birth (YYYY-MM-DD) >+ `branchcode` varchar(10) NOT NULL default '', --foreign key from the branches table, includes the code of the patron/borrower's home branch >+ `categorycode` varchar(10) NOT NULL default '', --foreign key from the categories table, includes the code of the patron category >+ `dateenrolled` date default NULL, --date the patron was added to Koha (YYYY-MM-DD) >+ `dateexpiry` date default NULL, --date the patron/borrower's card is set to expire (YYYY-MM-DD) >+ `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 >+ `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 >+ `debarred` tinyint(1) default NULL, --set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as being restricted >+ `contactname` mediumtext, --used for children and profesionals to include surname or last name of guarentor or organization name >+ `contactfirstname` text, --used for children to include first name of guarentor >+ `contacttitle` text, --used for children to include title (Mr., Mrs., etc) of guarentor >+ `guarantorid` int(11) default NULL, --borrowernumber used for children or professionals to link them to guarentors or organizations >+ `borrowernotes` mediumtext, --a note on the patron/borroewr's account that is only visible in the staff client >+ `relationship` varchar(100) default NULL, --used for children to include the relationship to their guarentor >+ `ethnicity` varchar(50) default NULL, --unused in Koha >+ `ethnotes` varchar(255) default NULL, --unused in Koha >+ `sex` varchar(1) default NULL, --patron/borrower's gender >+ `password` varchar(30) default NULL, --patron/borrower's encrypted password >+ `flags` int(11) default NULL, --unused in Koha >+ `userid` varchar(30) default NULL, --patron/borrower's opac and/or staff client log in >+ `opacnote` mediumtext, --a note on the patron/borrower's account that is visible in the OPAC and staff client >+ `contactnote` varchar(255) default NULL, --a note related to the patron/borrower's alternate address >+ `sort1` varchar(80) default NULL, --a field that can be used for any information unique to the library >+ `sort2` varchar(80) default NULL, --a field that can be used for any information unique to the library >+ `altcontactfirstname` varchar(255) default NULL, --first name of alternate contact for the patron/borrower >+ `altcontactsurname` varchar(255) default NULL, --surname or last name of the alternate contact for the patron/borrower >+ `altcontactaddress1` varchar(255) default NULL, --the first address line for the alternate contact for the patron/borrower >+ `altcontactaddress2` varchar(255) default NULL, --the second address line for the alternate contact for the patron/borrower >+ `altcontactaddress3` varchar(255) default NULL, --the third address line for the alternate contact for the patron/borrower >+ `altcontactstate` text default NULL, --the city and state for the alternate contact for the patron/borrower >+ `altcontactzipcode` varchar(50) default NULL, --the zipcode for the alternate contact for the patron/borrower >+ `altcontactcountry` text default NULL, --the country for the alternate contact for the patron/borrower >+ `altcontactphone` varchar(50) default NULL, --the phone number for the alternate contact for the patron/borrower >+ `smsalertnumber` varchar(50) default NULL, --the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) >+ `privacy` integer(11) DEFAULT '1' NOT NULL, --patron/borrower's privacy settings related to their reading history > UNIQUE KEY `cardnumber` (`cardnumber`), > PRIMARY KEY `borrowernumber` (`borrowernumber`), > KEY `categorycode` (`categorycode`), >-- >1.7.2.3
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6716
:
4987
|
4988
|
4989
|
4992
|
5003
|
5004
|
5005
|
5006
|
5007
|
5008
|
5009
|
5011
|
5012
|
5013
|
5014
|
5139
|
5140
|
5141
|
5142
|
5174
|
5175
|
5176
|
5177
|
5178
|
5179
|
5186
|
5187
|
5188
|
5190
|
5192
|
5193
|
5355
|
5356
|
5663
|
5664
|
5665
|
5666
|
5668
|
5669
|
5686
|
5687
|
5706
|
5829
|
6004
|
6015
|
6591
|
6592
|
6593
|
6594
|
6595
|
6596
|
6597
|
6598
|
6599
|
10788
|
10789
|
10790
|
10791
|
10792
|
10793
|
10794
|
10795
|
10822
|
10823
|
10824
|
10832
|
10833
|
10942
|
10970
|
10975
|
11011
|
11013
|
11014
|
11016
|
11018
|
11019
|
11020
|
11021
|
11022
|
11023
|
11084
|
11729
|
11823
|
11987
|
12024
|
12561
|
26777