Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Indranil Das Gupta
Hi,

On Wed, Jun 25, 2014 at 11:59 AM, Phillip Ponchot pponc...@live.com wrote:
 Where can I find where information is stored in the Koha tables?

http://schema.koha-community.org/

cheers
-idg

-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog: http://indradg.randomink.org/blog
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Zeno Tajoli
Hi Phillip,
 
When a book is checked out what tables are changed to show that the book is 
checked out.  If the book is deleted from koha, does that release the book 
from the table which shows that the book is checked out?
Any infomation is welcome and thanks to everyone whose helped me with this 
issue. 

in fact you can't delete a book from Koha if is checked out. There are blockers 
in circulation and cataloguing modules
about this.

There is a site where info about tables are visble ina graphic way:
http://schema.koha-community.org/

All information are avaible as comment in the file installer 
../data/mysql/kohastructure.sql

Bye
Zeno Tajoli
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
Thanks for the reply, I'll do some reading on this from the site.  Thanks again!

 Date: Wed, 25 Jun 2014 09:19:16 +0200
 From: z.taj...@cineca.it
 To: pponc...@live.com
 CC: koha@lists.katipo.co.nz
 Subject: Re: [Koha] Where can I find documentation on the Koha tables
 
 Hi Phillip,
  
 When a book is checked out what tables are changed to show that the book is 
 checked out.  If the book is deleted from koha, does that release the 
 book from the table which shows that the book is checked out?
 Any infomation is welcome and thanks to everyone whose helped me with this 
 issue. 
 
 in fact you can't delete a book from Koha if is checked out. There are 
 blockers in circulation and cataloguing modules
 about this.
 
 There is a site where info about tables are visble ina graphic way:
 http://schema.koha-community.org/
 
 All information are avaible as comment in the file installer 
 ../data/mysql/kohastructure.sql
 
 Bye
 Zeno Tajoli
  
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
Thanks so much, this info has been very helpful. 

 Date: Wed, 25 Jun 2014 09:19:16 +0200
 From: z.taj...@cineca.it
 To: pponc...@live.com
 CC: koha@lists.katipo.co.nz
 Subject: Re: [Koha] Where can I find documentation on the Koha tables
 
 Hi Phillip,
  
 When a book is checked out what tables are changed to show that the book is 
 checked out.  If the book is deleted from koha, does that release the 
 book from the table which shows that the book is checked out?
 Any infomation is welcome and thanks to everyone whose helped me with this 
 issue. 
 
 in fact you can't delete a book from Koha if is checked out. There are 
 blockers in circulation and cataloguing modules
 about this.
 
 There is a site where info about tables are visble ina graphic way:
 http://schema.koha-community.org/
 
 All information are avaible as comment in the file installer 
 ../data/mysql/kohastructure.sql
 
 Bye
 Zeno Tajoli
  
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
This information has been very helpful and will help me on our migration to a 
new server and koha version. 

 Date: Wed, 25 Jun 2014 12:05:01 +0530
 Subject: Re: [Koha] Where can I find documentation on the Koha tables
 From: indr...@gmail.com
 To: pponc...@live.com
 CC: koha@lists.katipo.co.nz
 
 Hi,
 
 On Wed, Jun 25, 2014 at 11:59 AM, Phillip Ponchot pponc...@live.com wrote:
  Where can I find where information is stored in the Koha tables?
 
 http://schema.koha-community.org/
 
 cheers
 -idg
 
 -- 
 Indranil Das Gupta
 
 Phone : +91-98300-20971
 Blog: http://indradg.randomink.org/blog
 IRC  : indradg on irc://irc.freenode.net
 Twitter : indradg
 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
 Please exchange editable Office documents only in ODF Format. No other
 format is acceptable. Support Open Standards.
 
 For a free editor supporting ODF, please visit LibreOffice -
 http://www.documentfoundation.org
  
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha