CREATE TABLE bpitattendance.attendance (
    enroll_num BIGINT(20) NOT NULL,
    attendance_date DATE NOT NULL DEFAULT CURRENT_DATE,
    latitude DECIMAL(10,8) NOT NULL,
    longitude DECIMAL(11,8) NOT NULL,
    is_present TINYINT(1) DEFAULT 0,
    PRIMARY KEY (enroll_num, attendance_date),
    CONSTRAINT FK_enroll_num FOREIGN KEY (enroll_num) 
       REFERENCES main_bpitattendance_db.student_record(enrollment_no) 
       ON DELETE CASCADE
);