JavaScript
DROP TABLE STUDENT_MST;
DROP TABLE FILE_MST;
CREATE TABLE STUDENT_MST(
STUDENT_MST_ID INT AUTO_INCREMENT,
STUDENT_ID VARCHAR(100) NOT NULL,
STUDENT_FILE_ID VARCHAR(100) NOT NULL,
VISA_APPROVED VARCHAR(100) NOT NULL,
UNIVERSITY_APPROVED VARCHAR(100) NOT NULL,
PRIMARY KEY(STUDENT_MST_ID)
);
CREATE TABLE FILE_MST(
FILE_MST_ID INT AUTO_INCREMENT,
STUDENT_FILE_ID VARCHAR(100) NOT NULL,
FILE_PROCESSED VARCHAR(100) NOT NULL,
PRIMARY KEY(FILE_MST_ID)
);
INSERT INTO `STUDENT_MST` (`STUDENT_MST_ID`,`STUDENT_ID`,`STUDENT_FILE_ID`,`VISA_APPROVED`,`UNIVERSITY_APPROVED`) VALUES
(1, 'STU-1', 'FILE-1', 'P', 'P'),
(2, 'STU-2', 'FILE-2', 'Y', 'Y'),
(3, 'STU-3', 'FILE-3', 'N', 'N'),
(4, 'STU-3', 'FILE-3', 'Y', 'Y'),
(5, 'STU-4', 'FILE-4', 'N', 'Y'),
(6, 'STU-4', 'FILE-5', 'Y', 'Y'),
(7, 'STU-5', 'FILE-6', 'N', 'Y'),
(8, 'STU-5', 'FILE-7', 'N', 'Y'),
(9, 'STU-5', 'FILE-8', 'Y', 'Y');
INSERT INTO `FILE_MST` (`FILE_MST_ID`,`STUDENT_FILE_ID`,`FILE_PROCESSED`) VALUES
(1, 'FILE-1', 'N'),
(2, 'FILE-2', 'Y'),
(3, 'FILE-3', 'N'),
(4, 'FILE-4', 'Y'),
(5, 'FILE-5', 'Y'),
(6, 'FILE-6', 'Y'),
(7, 'FILE-7', 'Y'),
(8, 'FILE-8', 'Y'),
(9, 'FILE-9', 'Y');