{ "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "SET character_set_server=utf8, collation_server=utf8_general_ci;" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.EXCEL_COLUMN_MAPPING_MASTER" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.MEDICAL_DETAIL" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT_CONTACT" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.PARENT" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.SECTION" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT_TRANSFER" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT_GROUP_MEMBER" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.PROMOTION" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.PARENT_PROFESSION" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.CLASS" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.EXCEL_COLUMN_MAPPING" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT_CONTACT_ADDRESS" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.PAST_ACADEMICS" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.SIBLINGS" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.SIBLINGS_OTHER_SCHOOLS" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.REVINFO" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.STUDENT_GROUP" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.MEDICAL_DETAIL_LOG" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "ddl" : "DROP TABLE IF EXISTS NextStudent.RELATIVE" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "DROP DATABASE IF EXISTS NextStudent" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE DATABASE NextStudent" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "USE NextStudent" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `CLASS` (\n `CLASS_ID` binary(16) NOT NULL,\n `ACADEMIC_END_DATE` date DEFAULT NULL,\n `ACADEMIC_START_DATE` date DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CLASS_GROUP` varchar(255) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `END_TIME` time DEFAULT NULL,\n `MASTER_CLASS_ID` binary(16) DEFAULT NULL,\n `MASTER_BOARD_ID` binary(16) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `NAME` varchar(255) DEFAULT NULL,\n `PHYSICAL_LOCATION` varchar(255) DEFAULT NULL,\n `PRIMARY_TEACHER_ID` binary(16) DEFAULT NULL,\n `SANCTIONED_STRENGTH` bigint(20) DEFAULT NULL,\n `SECONDARY_TEACHER_ID` binary(16) DEFAULT NULL,\n `SEQ_NO` int(11) DEFAULT NULL,\n `SHIFT_ID` binary(16) DEFAULT NULL,\n `START_TIME` time DEFAULT NULL,\n `STATUS` varchar(20) DEFAULT NULL,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`CLASS_ID`),\n UNIQUE KEY `IDX__UNIQUE__BRANCH_ID__MASTER_BOARD_ID__MASTER_CLASS_ID` (`BRANCH_ID`,`MASTER_BOARD_ID`,`MASTER_CLASS_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `EXCEL_COLUMN_MAPPING` (\n `EXCEL_COLUMN_MAPPING_ID` bigint(20) NOT NULL AUTO_INCREMENT,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `CUSTOM_NAME` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `SEQ_NO` int(11) DEFAULT NULL,\n `MASTER_ID` bigint(20) NOT NULL,\n PRIMARY KEY (`EXCEL_COLUMN_MAPPING_ID`),\n KEY `FKccmegws2s6sweff9tyxtd3ulu` (`MASTER_ID`),\n CONSTRAINT `FKccmegws2s6sweff9tyxtd3ulu` FOREIGN KEY (`MASTER_ID`) REFERENCES `EXCEL_COLUMN_MAPPING_MASTER` (`EXCEL_COLUMN_MASTER_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `EXCEL_COLUMN_MAPPING_MASTER` (\n `EXCEL_COLUMN_MASTER_ID` bigint(20) NOT NULL AUTO_INCREMENT,\n `ENTITY_NAME` varchar(255) DEFAULT NULL,\n `FIELD_NAME` varchar(255) DEFAULT NULL,\n `HEADER_NAME` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`EXCEL_COLUMN_MASTER_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `MEDICAL_DETAIL` (\n `MEDICAL_DETAIL_ID` bigint(20) NOT NULL AUTO_INCREMENT,\n `ALLERGIC_TO` varchar(255) DEFAULT NULL,\n `BLOOD_GROUP` varchar(255) DEFAULT NULL,\n `BMI` varchar(255) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CHICKEN_POX` bit(1) DEFAULT NULL,\n `COLOR_VISION` varchar(255) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DISEASE` varchar(255) DEFAULT NULL,\n `DTP` bit(1) DEFAULT NULL,\n `HEIGHT` double DEFAULT NULL,\n `HEPATITIS_B` bit(1) DEFAULT NULL,\n `GLASSES_LT` varchar(255) DEFAULT NULL,\n `VISION_LEFT` varchar(255) DEFAULT NULL,\n `MEASLES` bit(1) DEFAULT NULL,\n `CURRENT_MEDICATION` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `MUMPS` bit(1) DEFAULT NULL,\n `ORAL_HYGIENE` varchar(255) DEFAULT NULL,\n `POLIO` bit(1) DEFAULT NULL,\n `RECORD_DATE` date DEFAULT NULL,\n `REMARKS` varchar(255) DEFAULT NULL,\n `GLASSES_RT` varchar(255) DEFAULT NULL,\n `VISION_RIGHT` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `TETANUS` bit(1) DEFAULT NULL,\n `TYPHOID` bit(1) DEFAULT NULL,\n `WEIGHT` double DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`MEDICAL_DETAIL_ID`),\n KEY `FKnje3xexycy7s6jpvg5c5wt3oa` (`STUDENT_ID`),\n CONSTRAINT `FKnje3xexycy7s6jpvg5c5wt3oa` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `MEDICAL_DETAIL_LOG` (\n `MEDICAL_DETAIL_ID` bigint(20) NOT NULL,\n `REVISION` int(11) NOT NULL,\n `REVTYPE` tinyint(4) DEFAULT NULL,\n `ALLERGIC_TO` varchar(255) DEFAULT NULL,\n `BLOOD_GROUP` varchar(255) DEFAULT NULL,\n `BMI` varchar(255) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CHICKEN_POX` bit(1) DEFAULT NULL,\n `COLOR_VISION` varchar(255) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DISEASE` varchar(255) DEFAULT NULL,\n `DTP` bit(1) DEFAULT NULL,\n `HEIGHT` double DEFAULT NULL,\n `HEPATITIS_B` bit(1) DEFAULT NULL,\n `GLASSES_LT` varchar(255) DEFAULT NULL,\n `VISION_LEFT` varchar(255) DEFAULT NULL,\n `MEASLES` bit(1) DEFAULT NULL,\n `CURRENT_MEDICATION` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `MUMPS` bit(1) DEFAULT NULL,\n `ORAL_HYGIENE` varchar(255) DEFAULT NULL,\n `POLIO` bit(1) DEFAULT NULL,\n `RECORD_DATE` date DEFAULT NULL,\n `REMARKS` varchar(255) DEFAULT NULL,\n `GLASSES_RT` varchar(255) DEFAULT NULL,\n `VISION_RIGHT` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `TETANUS` bit(1) DEFAULT NULL,\n `TYPHOID` bit(1) DEFAULT NULL,\n `WEIGHT` double DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`MEDICAL_DETAIL_ID`,`REVISION`),\n KEY `FKn2t8x5mvbjsbjnm15di7cxbo3` (`REVISION`),\n CONSTRAINT `FK6aaks2ea87ku8iuknsw4qyk5d` FOREIGN KEY (`REVISION`) REFERENCES `REVINFO` (`REV`),\n CONSTRAINT `FKn2t8x5mvbjsbjnm15di7cxbo3` FOREIGN KEY (`REVISION`) REFERENCES `REVINFO` (`REV`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `PARENT` (\n `PARENT_ID` binary(16) NOT NULL,\n `ANNUAL_INCOME` varchar(255) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DATE_OF_BIRTH` date DEFAULT NULL,\n `DESIGNATION` varchar(255) DEFAULT NULL,\n `EDUCATION` varchar(255) DEFAULT NULL,\n `EMPLOYEE_ID` varchar(255) DEFAULT NULL,\n `FIRST_NAME` varchar(255) DEFAULT NULL,\n `IMAGE_ID` binary(16) DEFAULT NULL,\n `LAST_NAME` varchar(255) DEFAULT NULL,\n `MARRIAGE_ANNIVERSARY_DATE` datetime DEFAULT NULL,\n `MIDDLE_NAME` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `MOTHER_TONGUE` binary(16) DEFAULT NULL,\n `ORGANISATION` varchar(255) DEFAULT NULL,\n `RELATIONSHIP` varchar(255) DEFAULT NULL,\n `SPECIALISATION` varchar(255) DEFAULT NULL,\n `ALUMNI_CLASS` binary(16) DEFAULT NULL,\n `PROFESSION_ID` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `ALUMNI_YEAR` int(11) DEFAULT NULL,\n `CONTACT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`PARENT_ID`),\n KEY `FKilycjf4r4elm24u4mnkc3sl9d` (`ALUMNI_CLASS`),\n KEY `FKhsvesfbvrhomh9618vp7kgl4i` (`PROFESSION_ID`),\n KEY `FKifjblcrfo0t2hj5h6h8g396j4` (`STUDENT_ID`),\n KEY `FKsv94gxy9wdy20itv869vk7gci` (`CONTACT_ID`),\n CONSTRAINT `FK11y4y1ri7ihcclxbu18uftkmc` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`),\n CONSTRAINT `FKhsvesfbvrhomh9618vp7kgl4i` FOREIGN KEY (`PROFESSION_ID`) REFERENCES `PARENT_PROFESSION` (`PARENT_PROFESSION_ID`),\n CONSTRAINT `FKifjblcrfo0t2hj5h6h8g396j4` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKilycjf4r4elm24u4mnkc3sl9d` FOREIGN KEY (`ALUMNI_CLASS`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FKsv94gxy9wdy20itv869vk7gci` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `PARENT_PROFESSION` (\n `PARENT_PROFESSION_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `PROFESSION` varchar(255) DEFAULT NULL,\n `RELATIONSHIP` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`PARENT_PROFESSION_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `PAST_ACADEMICS` (\n `PAST_ACADEMICS_ID` binary(16) NOT NULL,\n `YEAR` bigint(20) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `GRADES` varchar(255) DEFAULT NULL,\n `HIERARCHY_ID` bigint(20) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `REASON` varchar(255) DEFAULT NULL,\n `SCHOOL_BOARD` binary(16) DEFAULT NULL,\n `SCHOOL_LOCATION` varchar(255) DEFAULT NULL,\n `SCHOOL_NAME` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `PAST_CLASS` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`PAST_ACADEMICS_ID`),\n KEY `FKn3y64e8quj2onab0hb02x91qv` (`STUDENT_ID`),\n KEY `FKd05i0x5vm97qxfqcktxsj1icv` (`PAST_CLASS`),\n CONSTRAINT `FKn3y64e8quj2onab0hb02x91qv` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `PROMOTION` (\n `PROMOTION_ID` bigint(20) NOT NULL AUTO_INCREMENT,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `BULK_PROMOTION_ID` bigint(20) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `PRE_PROMOTION_ROLL_NO` bigint(20) DEFAULT NULL,\n `REFERENCE_ID` bigint(20) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `FROM_CLASS_ID` binary(16) DEFAULT NULL,\n `FROM_SECTION_ID` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `TO_CLASS_ID` binary(16) DEFAULT NULL,\n `TO_SECTION_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`PROMOTION_ID`),\n KEY `FK7shtx1mtqk51r482gfxjjqk1k` (`FROM_CLASS_ID`),\n KEY `FKjy04dsln4gk2hjj661hij7otq` (`FROM_SECTION_ID`),\n KEY `FK8k59haolifw6u08d47j6056mc` (`STUDENT_ID`),\n KEY `FKb47x3r7mdv7o84n82ula17c9g` (`TO_CLASS_ID`),\n KEY `FK3qiqysyby4a4vtmomxbcp2uh0` (`TO_SECTION_ID`),\n CONSTRAINT `FK3qiqysyby4a4vtmomxbcp2uh0` FOREIGN KEY (`TO_SECTION_ID`) REFERENCES `SECTION` (`SECTION_ID`),\n CONSTRAINT `FK7shtx1mtqk51r482gfxjjqk1k` FOREIGN KEY (`FROM_CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FK8k59haolifw6u08d47j6056mc` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKb47x3r7mdv7o84n82ula17c9g` FOREIGN KEY (`TO_CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FKjy04dsln4gk2hjj661hij7otq` FOREIGN KEY (`FROM_SECTION_ID`) REFERENCES `SECTION` (`SECTION_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `RELATIVE` (\n `RELATIVE_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `FIRST_NAME` varchar(255) DEFAULT NULL,\n `LAST_NAME` varchar(255) DEFAULT NULL,\n `MIDDLE_NAME` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `CONTACT_ID` binary(16) DEFAULT NULL,\n `RELATIONSHIP` tinyint(4) NOT NULL,\n `IMAGE_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`RELATIVE_ID`),\n KEY `FK5oqw1ai6vysso38ef7r7m4npj` (`STUDENT_ID`),\n KEY `FKajxyhfeuwbpea3cnudkuf3s9o` (`CONTACT_ID`),\n CONSTRAINT `FK5oqw1ai6vysso38ef7r7m4npj` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKajxyhfeuwbpea3cnudkuf3s9o` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`),\n CONSTRAINT `FKp7dku29ai4gge2aokywtnocm8` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `REVINFO` (\n `REV` int(11) NOT NULL AUTO_INCREMENT,\n `REVTSTMP` bigint(20) DEFAULT NULL,\n PRIMARY KEY (`REV`)\n) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `SECTION` (\n `SECTION_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `END_TIME` time DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `NAME` varchar(255) DEFAULT NULL,\n `PHYSICAL_LOCATION` varchar(255) DEFAULT NULL,\n `TEACHER_PRIMARY` binary(16) DEFAULT NULL,\n `ROOM_ID` binary(16) DEFAULT NULL,\n `SANCTIONED_STRENGTH` int(11) DEFAULT NULL,\n `TEACHER_SECONDARY` binary(16) DEFAULT NULL,\n `SEQ_NO` int(11) DEFAULT NULL,\n `START_TIME` time DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `CLASS_ID` binary(16) DEFAULT NULL,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`SECTION_ID`),\n KEY `FKiy5ojjt0ld5yvngi9cigxi1es` (`CLASS_ID`),\n CONSTRAINT `FKiy5ojjt0ld5yvngi9cigxi1es` FOREIGN KEY (`CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `SIBLINGS` (\n `SIBLINGS_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DATE_OF_BIRTH` datetime DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `NAME` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `SIB_STUDENT_ID` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`SIBLINGS_ID`),\n KEY `FK424qtuy8m2jsymqh8a1ok3x4f` (`SIB_STUDENT_ID`),\n KEY `FKg8u69n68tl707m0395qmtpqy4` (`STUDENT_ID`),\n CONSTRAINT `FK424qtuy8m2jsymqh8a1ok3x4f` FOREIGN KEY (`SIB_STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKg8u69n68tl707m0395qmtpqy4` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `SIBLINGS_OTHER_SCHOOLS` (\n `SIBLINGS_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `COURSE` varchar(100) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT CURRENT_TIMESTAMP,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT CURRENT_TIMESTAMP,\n `NAME` varchar(100) DEFAULT NULL,\n `ORGANIZATION` varchar(100) DEFAULT NULL,\n `SIBLING_BRANCH_ID` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `SIB_BRANCH_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`SIBLINGS_ID`),\n KEY `FKjh0an87wdio51xcfytlaicm1t` (`STUDENT_ID`),\n CONSTRAINT `FKjh0an87wdio51xcfytlaicm1t` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT` (\n `STUDENT_ID` binary(16) NOT NULL,\n `AADHAR_NUMBER` varchar(255) DEFAULT NULL,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n `ADMISSION_NO` varchar(255) DEFAULT NULL,\n `ADMISSION_STUDENT_ID` binary(16) DEFAULT NULL,\n `ADMISSION_YEAR` int(11) DEFAULT NULL,\n `ATTENDANCE_CODE` varchar(255) DEFAULT NULL,\n `BIOMETRIC_CODE` varchar(255) DEFAULT NULL,\n `BIRTH_PLACE` varchar(255) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CASTE_ID` binary(16) DEFAULT NULL,\n `CATEGORY_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DATE_OF_BIRTH` date DEFAULT NULL,\n `DEACTIVATED_DATE` datetime DEFAULT NULL,\n `DEACTIVATION_REASON` varchar(255) DEFAULT NULL,\n `FEE_CATEGORY_ID` binary(16) DEFAULT NULL,\n `FIRST_LANG_ID` binary(16) DEFAULT NULL,\n `FIRST_NAME` varchar(255) DEFAULT NULL,\n `GENDER` varchar(255) DEFAULT NULL,\n `IDENTIFICATION_ONE` varchar(255) DEFAULT NULL,\n `IMAGE_ID` binary(16) DEFAULT NULL,\n `JOINING_DATE` datetime DEFAULT NULL,\n `LAST_NAME` varchar(255) DEFAULT NULL,\n `MIDDLE_NAME` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `MOTHER_TONGUE_ID` binary(16) DEFAULT NULL,\n `NATIONALITY` varchar(255) DEFAULT NULL,\n `PRIMARY_CONTACT` varchar(255) DEFAULT NULL,\n `RELIGION_ID` binary(16) DEFAULT NULL,\n `REMARKS` varchar(255) DEFAULT NULL,\n `ROLL_NUM` bigint(20) DEFAULT NULL,\n `SECOND_LANG_ID` binary(16) DEFAULT NULL,\n `STAFF_AS_PARENT_ID` binary(16) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `SUBCASTE_ID` binary(16) DEFAULT NULL,\n `SUB_STATUS` bit(1) DEFAULT NULL,\n `ADMISSION_CLASS_ID` binary(16) DEFAULT NULL,\n `PARENT_STUDENT_ID` binary(16) DEFAULT NULL,\n `SECTION_ID` binary(16) DEFAULT NULL,\n `CLASS_ID` binary(16) DEFAULT NULL,\n `CONTACT_ID` binary(16) DEFAULT NULL,\n `FATHER_ID` binary(16) DEFAULT NULL,\n `MOTHER_ID` binary(16) DEFAULT NULL,\n `ID_CARD_ID` binary(16) DEFAULT NULL,\n `EVIDENCE_OF_DISABILITY` varchar(255) DEFAULT NULL,\n `SERIOUS_INCIDENT` varchar(255) DEFAULT NULL,\n `PREVIOUS_DISCIPLINARY_ISSUES` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`STUDENT_ID`),\n UNIQUE KEY `IDX__UNIQUE__BRANCH_ID__ADMISSION_NO__ACADEMIC_SESSION_ID` (`ACADEMIC_SESSION_ID`,`ADMISSION_NO`,`BRANCH_ID`),\n KEY `FKce8i0ieasadgj1p95xsc1ion7` (`PARENT_STUDENT_ID`),\n KEY `FK3k8t44jwkbk85c9lvbahv6ypq` (`SECTION_ID`),\n KEY `FK6o2awsmufrsttxjdwuefek7v5` (`CLASS_ID`),\n KEY `FKfcssas65o31illaxx1bpbikhf` (`ADMISSION_CLASS_ID`),\n KEY `FKt067nnq8i56s39p9sbng7v65b` (`CONTACT_ID`),\n KEY `IDX_FOREIGN_FATHER_PARENT` (`FATHER_ID`),\n KEY `IDX_FOREIGN_MOTHER_PARENT` (`MOTHER_ID`),\n CONSTRAINT `FK1gx0k9r62xjpnj08n4ka40tjh` FOREIGN KEY (`ADMISSION_CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FK3k8t44jwkbk85c9lvbahv6ypq` FOREIGN KEY (`SECTION_ID`) REFERENCES `SECTION` (`SECTION_ID`),\n CONSTRAINT `FK6o2awsmufrsttxjdwuefek7v5` FOREIGN KEY (`CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FKce8i0ieasadgj1p95xsc1ion7` FOREIGN KEY (`PARENT_STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKcejlerd6pwig6qnkgcuprwv2a` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`),\n CONSTRAINT `FKfcssas65o31illaxx1bpbikhf` FOREIGN KEY (`ADMISSION_CLASS_ID`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `IDX_FOREIGN_FATHER_PARENT` FOREIGN KEY (`FATHER_ID`) REFERENCES `PARENT` (`PARENT_ID`),\n CONSTRAINT `IDX_FOREIGN_MOTHER_PARENT` FOREIGN KEY (`MOTHER_ID`) REFERENCES `PARENT` (`PARENT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT_CONTACT` (\n `CONTACT_ID` binary(16) NOT NULL,\n `ALTERNATE_EMAIL` varchar(255) DEFAULT NULL,\n `ALTERNATE_PHONE` varchar(255) DEFAULT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `DEVICE_ID` varchar(255) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `PRIMARY_EMAIL` varchar(255) DEFAULT NULL,\n `PRIMARY_PHONE` varchar(255) DEFAULT NULL,\n `REGISTRATION_ID` varchar(255) DEFAULT NULL,\n `RELATION_TYPE` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `USER_PROFILE_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`CONTACT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT_CONTACT_ADDRESS` (\n `CONTACT_ADDRESS_ID` binary(16) NOT NULL,\n `ADDRESS_LINE_ONE` varchar(255) DEFAULT NULL,\n `ADDRESS_LINE_TWO` varchar(255) DEFAULT NULL,\n `CITY_ID` binary(16) DEFAULT NULL,\n `COUNTRY_ID` binary(16) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `IF_CURRENT` bit(1) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `PIN_CODE` varchar(255) DEFAULT NULL,\n `STATE_ID` binary(16) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `CONTACT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`CONTACT_ADDRESS_ID`),\n KEY `FKsh50b2qdu7he06j4t3961nahv` (`CONTACT_ID`),\n CONSTRAINT `FKonmm08o3ykia2ho28hlscua4s` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`),\n CONSTRAINT `FKsh50b2qdu7he06j4t3961nahv` FOREIGN KEY (`CONTACT_ID`) REFERENCES `STUDENT_CONTACT` (`CONTACT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT_GROUP` (\n `GROUP_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n `NAME` varchar(255) DEFAULT NULL,\n `REFERENCE_ID` bigint(20) DEFAULT NULL,\n `IMAGE_LOCATION` binary(16) DEFAULT NULL,\n `DESCRIPTION` varchar(255) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n PRIMARY KEY (`GROUP_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT_GROUP_MEMBER` (\n `STUDENT_GROUP_MEMBER_ID` binary(16) NOT NULL,\n `BRANCH_ID` binary(16) DEFAULT NULL,\n `GROUP_ID` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n PRIMARY KEY (`STUDENT_GROUP_MEMBER_ID`),\n UNIQUE KEY `UK_STUDENTGROUP_MEMBER_BRANCH_ID_GROUP_ID_STUDENT_ID` (`BRANCH_ID`,`GROUP_ID`,`STUDENT_ID`),\n KEY `IDX_STUDENT_GROUP_MEMBER_GROUP_ID` (`GROUP_ID`),\n KEY `IDX_STUDENT_GROUP_MEMBER_STUDENT_ID` (`STUDENT_ID`),\n CONSTRAINT `FK_STUDENT_GROUP_MEMBER_GROUP_ID` FOREIGN KEY (`GROUP_ID`) REFERENCES `STUDENT_GROUP` (`GROUP_ID`),\n CONSTRAINT `FK_STUDENT_GROUP_MEMBER_STUDENT_ID` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" } { "source" : { "server" : "Final" }, "position" : { "file" : "mysql-bin.000976", "pos" : 928321, "snapshot" : true }, "databaseName" : "NextStudent", "ddl" : "CREATE TABLE `STUDENT_TRANSFER` (\n `TRANSFER_ID` bigint(20) NOT NULL AUTO_INCREMENT,\n `ACADEMIC_SESSION_ID` binary(16) DEFAULT NULL,\n `COMMENTS` varchar(500) DEFAULT NULL,\n `CREATED_BY` binary(16) DEFAULT NULL,\n `CREATED_ON` datetime DEFAULT NULL,\n `EXACT_JOINING_DATE` datetime DEFAULT NULL,\n `FROM_BRANCH_ID` binary(16) DEFAULT NULL,\n `IF_JOINED` bit(1) DEFAULT NULL,\n `MODIFIED_BY` binary(16) DEFAULT NULL,\n `MODIFIED_ON` datetime DEFAULT NULL,\n `REASON` varchar(500) DEFAULT NULL,\n `REFERENCE_ID` bigint(20) DEFAULT NULL,\n `RELEASE_DATE` datetime DEFAULT NULL,\n `STATUS` varchar(255) DEFAULT NULL,\n `TENTATIVE_JOINING_DATE` datetime DEFAULT NULL,\n `TO_BRANCH_ID` binary(16) DEFAULT NULL,\n `CURRENT_CLASS` binary(16) DEFAULT NULL,\n `CURRENT_SECTION` binary(16) DEFAULT NULL,\n `FINAL_STUDENT_ID` binary(16) DEFAULT NULL,\n `JOINING_CLASS` binary(16) DEFAULT NULL,\n `JOINING_SECTION` binary(16) DEFAULT NULL,\n `STUDENT_ID` binary(16) DEFAULT NULL,\n PRIMARY KEY (`TRANSFER_ID`),\n KEY `FKs1sduxf8ing4j0qfuds8apgni` (`CURRENT_CLASS`),\n KEY `FK86pg1ds9tt4eiu9xqstbhxrh9` (`CURRENT_SECTION`),\n KEY `FKla4pm47n8vy8uv86gsxxjiw4w` (`FINAL_STUDENT_ID`),\n KEY `FKc4ccqrc8pbuh4utu4fq7ikkop` (`JOINING_CLASS`),\n KEY `FKsgvfa6mscsyavuewx0hi5rkhs` (`JOINING_SECTION`),\n KEY `FK371oq9h9i6en9ex7bsudbdhym` (`STUDENT_ID`),\n CONSTRAINT `FK371oq9h9i6en9ex7bsudbdhym` FOREIGN KEY (`STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FK86pg1ds9tt4eiu9xqstbhxrh9` FOREIGN KEY (`CURRENT_SECTION`) REFERENCES `SECTION` (`SECTION_ID`),\n CONSTRAINT `FKc4ccqrc8pbuh4utu4fq7ikkop` FOREIGN KEY (`JOINING_CLASS`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FKla4pm47n8vy8uv86gsxxjiw4w` FOREIGN KEY (`FINAL_STUDENT_ID`) REFERENCES `STUDENT` (`STUDENT_ID`),\n CONSTRAINT `FKs1sduxf8ing4j0qfuds8apgni` FOREIGN KEY (`CURRENT_CLASS`) REFERENCES `CLASS` (`CLASS_ID`),\n CONSTRAINT `FKsgvfa6mscsyavuewx0hi5rkhs` FOREIGN KEY (`JOINING_SECTION`) REFERENCES `SECTION` (`SECTION_ID`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8" }