search

yudisentosa / SBDProjectSchool

0 stars 0 forks source link

Table - subject_teacher #31

Closed yudisentosa closed 3 years ago

yudisentosa commented 3 years ago

DROP TABLE IF EXISTS subject_teacher; CREATE TABLE subject_teacher( subject_class_id VARCHAR(12) NOT NULL ,teacher_id INTEGER NOT NULL ,effective_date DATE NOT NULL, PRIMARY KEY(subject_class_id, teacher_id, effective_year), FOREIGN KEY (subject_class_id) REFERENCES subject_class(subject_class_id), FOREIGN KEY (teacher_id) REFERENCES employee(employee_id) ); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10A011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10A011920',1002,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10A011920',1012,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10A011920',1006,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10A011920',1007,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10A011920',1003,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10A011920',1005,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK10A011920',1009,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO10A011920',1008,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM10A011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS10A011920',1004,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10S011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10S011920',1002,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10S011920',1012,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10S011920',1006,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10S011920',1007,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10S011920',1003,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10S011920',1005,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO10S011920',1011,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ10S011920',1011,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO10S011920',1001,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11A011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11A011920',1002,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11A011920',1012,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11A011920',1006,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11A011920',1007,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11A011920',1003,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11A011920',1005,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK11A011920',1009,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO11A011920',1008,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM11A011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS11A011920',1004,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11S011920',1010,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11S011920',1002,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11S011920',1012,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11S011920',1006,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11S011920',1007,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11S011920',1003,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11S011920',1005,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO11S011920',1011,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ11S011920',1011,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO11S011920',1001,'2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10A012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10A012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10A012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10A012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10A012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10A012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK10A012021',1009,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO10A012021',1008,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM10A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS10A012021',1004,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10S012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10S012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10S012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10S012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10S012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10S012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10S012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO10S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ10S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO10S012021',1001,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11A012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11A012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11A012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11A012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11A012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11A012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK11A012021',1009,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO11A012021',1008,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM11A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS11A012021',1004,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11S012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11S012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11S012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11S012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11S012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11S012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11S012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO11S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ11S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO11S012021',1001,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN12A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG12A012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN12A012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN12A012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK12A012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG12A012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS12A012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK12A012021',1009,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO12A012021',1008,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM12A012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS12A012021',1004,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN12S012021',1010,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG12S012021',1002,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN12S012021',1012,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN12S012021',1006,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK12S012021',1007,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG12S012021',1003,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS12S012021',1005,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO12S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ12S012021',1011,'2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO12S012021',1001,'2020-06-29');

yudisentosa commented 3 years ago

DROP TABLE IF EXISTS subject_teacher; CREATE TABLE subject_teacher( subject_class_id VARCHAR(12) NOT NULL ,teacher_id VARCHAR(4) NOT NULL ,effective_date DATE NOT NULL, PRIMARY KEY(subject_class_id, teacher_id, effective_date), FOREIGN KEY(subject_class_id) REFERENCES subject_class(subject_class_id), FOREIGN KEY(teacher_id) REFERENCES employee(employee_id) ); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10A011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10A011920','1002','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10A011920','1012','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10A011920','1006','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10A011920','1007','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10A011920','1003','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10A011920','1005','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK10A011920','1009','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO10A011920','1008','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM10A011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS10A011920','1004','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10S011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10S011920','1002','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10S011920','1012','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10S011920','1006','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10S011920','1007','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10S011920','1003','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10S011920','1005','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO10S011920','1011','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ10S011920','1011','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO10S011920','1001','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11A011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11A011920','1002','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11A011920','1012','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11A011920','1006','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11A011920','1007','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11A011920','1003','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11A011920','1005','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK11A011920','1009','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO11A011920','1008','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM11A011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS11A011920','1004','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11S011920','1010','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11S011920','1002','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11S011920','1012','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11S011920','1006','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11S011920','1007','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11S011920','1003','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11S011920','1005','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO11S011920','1011','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ11S011920','1011','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO11S011920','1001','2019-07-01'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10A012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10A012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10A012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10A012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10A012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10A012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK10A012021','1009','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO10A012021','1008','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM10A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS10A012021','1004','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN10S012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG10S012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN10S012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN10S012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK10S012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG10S012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS10S012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO10S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ10S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO10S012021','1001','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11A012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11A012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11A012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11A012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11A012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11A012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK11A012021','1009','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO11A012021','1008','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM11A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS11A012021','1004','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN11S012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG11S012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN11S012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN11S012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK11S012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG11S012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS11S012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO11S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ11S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO11S012021','1001','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN12A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG12A012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN12A012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN12A012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK12A012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG12A012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS12A012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MTK12A012021','1009','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIO12A012021','1008','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('KIM12A012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('FIS12A012021','1004','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIN12S012021','1010','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('BIG12S012021','1002','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MAN12S012021','1012','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PKN12S012021','1006','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('PAK12S012021','1007','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('OLG12S012021','1003','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('MDS12S012021','1005','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('EKO12S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('SEJ12S012021','1011','2020-06-29'); INSERT INTO subject_teacher(subject_class_id,teacher_id,effective_date) VALUES ('GEO12S012021','1001','2020-06-29');