tblbooks Table: Int(11) InUse Id Varchar(500) ISBN Varchar(500) InUse BookTitle Varchar(500) InUse BookDesc Varchar(500) Category Varchar(500) InUse Author Varchar(500) InUse BookPublisher Varchar(500) Future Prospect MainUrl Varchar(500) MainUrlId Int(11) Price Int(11) InUse Qty Int(11) InUse Borrowed Date InUse AddedOn Varchar(500) InUse AddedBy tblborrowed Table: Int(11) InUse Id Int(11) InUse BookId Int(11) InUse StudentId Varchar(500) Notes Varchar(500) DateBorrowed Varchar(500) InUse DateToReturn Varchar(500) InUse DateReturned Int(11) InUse DelayedDay
tblbooks Table: Id Int(11) InUse ISBN Varchar(500) BookTitle Varchar(500) InUse BookDesc Varchar(500) InUse Category Varchar(500) Author Varchar(500) InUse BookPublisher Varchar(500) InUse MainUrl Varchar(500) Future Prospect MainUrlId Varchar(500) Price Int(11) Qty Int(11) InUse Borrowed Int(11) InUse AddedOn Date InUse AddedBy Varchar(500) InUse tblborrowed Table: Id Int(11) InUse BookId Int(11) InUse StudentId Int(11) InUse Notes Varchar(500) DateBorrowed Varchar(500) DateToReturn Varchar(500) InUse DateReturned Varchar(500) InUse DelayedDay Int(11) InUse
BlackBook.docx