Library master is the major master table which displays all the information regarding the book which you can see in the grid. And its interlinked with transaction i any one makes any changes then it reflects to the library master.
This is the master details and this is called as a menu from the menu sheet only it will redirect to the respected pages.
Library Master List:
1. Go to the back-office and click on the option Library Management - Management and then click on the option Library Master.
2. Library Master is a major one which displays the id , title , author, subject, language,category etc.it gives the total information about the book weather it is available or not what kind of book it is and it is available or not.
3.When we click on the first menu called lib master it will take to the following page which displays all the records. It gives the complete information like how many books are available and how many or on rent.
Add New Library Record:
4. Its a libmaster which has a details form with all the necessary requirements where the user has to fill the form to get register himself/herself.
5. It has a forms fields like id , title of the book, which subject, who is the author, what is the language ,by whom it is published, publication date ,to which category it belongs to , type of book , number of pages.
6. If we click on add new it will redirect to the form where we can give the required information and register himself/herself.
7. Once you have completed the Library Master details, clicking the Add button as shown below.
8. Click on LIB Detail button.
9. Click on LIB Trans button.
ID : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
ISBN : |
Field Type : VARCHAR SQL Type : Text Field size in DataBase : 20 |
EAN : |
Field Type : VARCHAR SQL Type : Text Field size in DataBase : 20 |
Title : |
Field Type : VARCHAR SQL Type : Text Field size in DataBase : 50 |
Author Id : |
Field Type : VARCHAR SQL Type : Select Field size in DataBase : 20 |
Subject : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
Language : |
Field Type : INT SQL Type : Select Field size in DataBase : 11 |
Publisher ID: |
Field Type : VARCHAR SQL Type : Select Field size in DataBase : 20 |
Category : |
Field Type : VARCHAR SQL Type : Select Field size in DataBase : 20 |
Type : |
Field Type : VARCHAR SQL Type : Select Field size in DataBase : 10 |
Pages : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
Size Code : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
On Hand : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
On Loan : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
Reserved : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |
Available : |
Field Type : INT SQL Type : Text Field size in DataBase : 11 |