i have been creating tables for sending attendance report and other event information to parents and some event information for staff.
It contain details with student_id as primary key
It contain detail with contact_id as primary key
It contain details with staff_id as primary key
It contain details with student_id as foreign key
please give me some suggestion about further table creation for sending sms automatically whenever student enter their attandance through finger print device and creating and sending other message through manually.
thank you advance