project name : library management System dbpage2

#
# Table structure for table librarydepartment
#


DROP TABLE IF EXISTS `librarydepartment`;
CREATE TABLE `librarydepartment` (
  `DepartmentId` varchar(11) NOT NULL,
  `DepartmentName` varchar(50) default NULL,
  `ModeratorId` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`DepartmentId`),
  KEY `ModeratorId` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


#
# Dumping data for table librarydepartment
#




#
# Table structure for table login
#


DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `AdminId` varchar(20) NOT NULL default '',
  `Password` varchar(10) NOT NULL,
  `adminname` varchar(11) default NULL,
  `Username` varchar(11) default NULL,
  PRIMARY KEY  (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;


#
# Dumping data for table login
#




#
# Table structure for table moderator
#


DROP TABLE IF EXISTS `moderator`;
CREATE TABLE `moderator` (
  `ModeratorId` varchar(11) NOT NULL default '',
  `GroupId` varchar(11) default NULL,
  `ModeratorName` varchar(50) default NULL,
  `CreationDate` datetime NOT NULL,
  `MUserName` varchar(20) default NULL,
  `Mpassword` varchar(11) default NULL,
  `Mqualification` varchar(11) default NULL,
  `AdminId` varchar(20) default NULL,
  PRIMARY KEY  (`ModeratorId`),
  UNIQUE KEY `username` (`MUserName`),
  KEY `AdminId` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;


#
# Dumping data for table moderator
#




#
# Table structure for table purchase
#


DROP TABLE IF EXISTS `purchase`;
CREATE TABLE `purchase` (
  `PurchaseId` varchar(11) NOT NULL default '',
  `OrderNo` varchar(11) default NULL,
  `BookName` varchar(100) default NULL,
  `PurchaseNoOfCopies` int(11) default NULL,
  `PublisherName` varchar(100) default NULL,
  `Author` varchar(50) default NULL,
  `Edition` varchar(11) default NULL,
  `Price` int(11) default NULL,
  `PurchaseDate` date default NULL,
  `AdminId` varchar(20) default NULL,
  PRIMARY KEY  (`PurchaseId`),
  KEY `OrderNO` (`OrderNo`),
  KEY `UserName` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;


for remaining tables and report click here

Posted in: