- CREATE TABLE `BOOK` (
- `Code` INT NOT NULL AUTO_INCREMENT,
- `Bookname` VARCHAR,
- `Author` VARCHAR,
- `Publication` VARCHAR,
- `Subject` VARCHAR,
- `No. of copies` INT,
- PRIMARY KEY (`Code`)
- );
- CREATE TABLE `STUDENT` (
- `libid` INT NOT NULL AUTO_INCREMENT,
- `regno` INT,
- `branch` INT,
- `section` VARCHAR,
- `semester` VARCHAR,
- `yearofadm` DATE,
- PRIMARY KEY (`libid`)
- );
- CREATE TABLE `TEACHER` (
- `Tid` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR,
- `designation` VARCHAR,
- `branch` VARCHAR,
- `contactno.` INT,
- `lectures` LONGBLOB,
- PRIMARY KEY (`Tid`)
- );
- CREATE TABLE `BOOKISSUE` (
- `bookid` INT NOT NULL,
- `stuid` INT,
- `issuedate` DATE,
- `returndate` DATE
- FOREIGN KEY (`bookid`) REFERENCES BOOK(`Code`)
- FOREIGN KEY (`stuid`) REFERENCES STUDENT(`libid`)
- );
- CREATE TABLE `STUDENTLOGIN` (
- `loginid` INT NOT NULL,
- `password` VARCHAR,
- `no. of books` INT
- FOREIGN KEY (`loginid`) REFERENCES STUDENT(`libid`)
- );
- CREATE TABLE `TEACHERLOGIN` (
- `loginid` INT NOT NULL,
- `password` VARCHAR
- FOREIGN KEY (`loginid`) REFERENCES TEACHER(`Tid`)
- );
- CREATE TABLE `EVENT` (
- `Name` VARCHAR,
- `Date` DATETIME,
- `contactno.` INT,
- `email` VARCHAR,
- `venue` VARCHAR
- );
[text] library
Viewer
Editor
You can edit this paste and save as new: