Closed licyawatidewi closed 3 years ago
DROP TABLE IF EXISTS employee_attandance; CREATE TABLE employee_attandance( employee_id VARCHAR(4) NOT NULL ,date VARCHAR(10) NOT NULL ,attandance_detail VARCHAR(9) NOT NULL ,INDEX(employee_id,date), FOREIGN KEY(employee_id) REFERENCES employee(employee_id) ); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2014','04/02/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2015','13/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1005','17/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1003','27/02/2020','Alfa'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1001','28/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3017','16/03/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1005','31/03/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1009','29/04/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1006','22/05/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1002','27/05/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1001','29/05/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3020','20/07/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3018','21/07/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1003','27/08/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1008','14/09/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1011','18/09/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1013','21/09/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1004','30/09/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1002','02/10/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1012','26/10/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2016','05/11/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1004','12/11/2020','Alfa'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1010','20/11/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1007','04/12/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3019','15/12/2020','Terlambat');
DROP TABLE IF EXISTS employee_attandance; CREATE TABLE employee_attandance( employee_id VARCHAR(4) NOT NULL ,date VARCHAR(10) NOT NULL ,attandance_detail VARCHAR(9) NOT NULL ,INDEX(employee_id,date), FOREIGN KEY(employee_id) REFERENCES employee(employee_id) ); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2014','04/02/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2015','13/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1005','17/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1003','27/02/2020','Alfa'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1001','28/02/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3017','16/03/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1005','31/03/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1009','29/04/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1006','22/05/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1002','27/05/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1001','29/05/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3020','20/07/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3018','21/07/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1003','27/08/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1008','14/09/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1011','18/09/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1013','21/09/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1004','30/09/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1002','02/10/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1012','26/10/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('2016','05/11/2020','Sakit'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1004','12/11/2020','Alfa'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1010','20/11/2020','Izin'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('1007','04/12/2020','Terlambat'); INSERT INTO employee_attandance(employee_id,date,attandance_detail) VALUES ('3019','15/12/2020','Terlambat');