3Rd82hRe

1DROP TABLE IF EXISTS `hostelsystem`.`leave_request` ;
2drop table leave_request;
3select * from leave_request;
4
5CREATE TABLE IF NOT EXISTS `hostelsystem`.`leave_request`(
6  `leaveId` INT NOT NULL AUTO_INCREMENT,
7  `hostelId` INT NULL,
8  `entryDate` DATE NULL,
9  `fromDate` DATE NULL,
10  `toDate` DATE NULL,
11  `subject` VARCHAR(100) NULL,
12  `reason` VARCHAR(100) NULL,
13  
14  
15  `seenByStudent` VARCHAR(3) DEFAULT "NO",
16  `seenByAdmin` VARCHAR(3) DEFAULT "NO",
17  `seenByParent` VARCHAR(3) DEFAULT "NO",
18
19  `approvedByAdmin` VARCHAR(3) DEFAULT "NO",
20  `approvedByParent` VARCHAR(3) DEFAULT "NO",
21  
22  `deletedByParent` VARCHAR(3) DEFAULT "NO",
23  `deletedByStudent` VARCHAR(3) DEFAULT "NO",
24  `deletedByAdmin` VARCHAR(3) DEFAULT "NO",
25  
26  `sendToStudentEmail` VARCHAR(3) DEFAULT "NO",
27  `sendToStudentEmailTime` DATE NULL,
28  
29  PRIMARY KEY (`leaveId`))
30ENGINE = InnoDB;