project name : library management System full details with db and source

project name :  library management System


data base using this project is MYSQL



create database named lib
CREATE TABLE `bookissue` (
  `ModeratorId` varchar(11) default NULL,
  `BookIssueId` varchar(11) NOT NULL default '',
  `BookId` varchar(11) default NULL,
  `UserId` varchar(11) default NULL,
  `Card` varchar(11) default NULL,
  `DateOfIssue` date default NULL,
  `DateOfReturn` date default NULL,
  `GropId` varchar(11) NOT NULL,
  PRIMARY KEY  (`BookIssueId`),
  UNIQUE KEY `ModeratorId` (`ModeratorId`),
  UNIQUE KEY `UserId` (`UserId`),
  UNIQUE KEY `BookId` (`BookId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;




#
# Table structure for table bookorder
#

DROP TABLE IF EXISTS `bookorder`;
CREATE TABLE `bookorder` (
  `OrderNo` varchar(11) NOT NULL default '',
  `OrderId` varchar(11) default NULL,
  `OrderBookName` varchar(50) default NULL,
  `OrderAuthor` varchar(100) default NULL,
  `OrderNoOfCopies` int(11) default NULL,
  `OrderPublisherName` varchar(50) default NULL,
  `OrderEdition` varchar(30) default NULL,
  `OrderPrice` int(11) default NULL,
  `OrderOther` varchar(100) default NULL,
  `ModeratorId` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`OrderNo`),
  KEY `OrderId` (`OrderId`),
  KEY `M` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;






#
# Table structure for table category
#

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `DepartmentId` varchar(11) default NULL,
  `CategoryId` varchar(11) NOT NULL,
  `CategoryName` varchar(50) default NULL,
  PRIMARY KEY  (`CategoryId`),
  UNIQUE KEY `DepartmentId` (`DepartmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


#
# Table structure for table finedetails
#

DROP TABLE IF EXISTS `finedetails`;
CREATE TABLE `finedetails` (
  `BookIssueId` varchar(11) NOT NULL default '',
  `UserId` varchar(11) NOT NULL default '',
  `BookId` varchar(11) default NULL,
  `FineDate` date default NULL,
  `FineAmount` int(11) default NULL,
  `ReceiptNo` varchar(11) default NULL,
  `GropId` varchar(11) NOT NULL,
  PRIMARY KEY  (`BookIssueId`),
  KEY `UserId` (`UserId`),
  KEY `gId` (`GropId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;




#
# Table structure for table groups
#

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `GroupId` varchar(11) NOT NULL default '',
  `GroupName` varchar(30) default NULL,
  `NoOfDays` int(11) NOT NULL,
  `FineAmount` int(11) NOT NULL,
  `ModeratorId` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`GroupId`),
  KEY `m` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;


for remaining tables and project modules of library management system click here

Posted in: