Clickatell Web Interface and Database

Clickatel for a school. Database can be Access (preferable) or MS SQL Create a database with parent/guardian contact mobile numbers for each pupil Each student can have more than one parent/guardian (max 4) There can be more than one stuent for each parent/guardian - eg a family (max 10) Link Pupil & Parents so that only one SMS is sent for a family Group students based on class or by teacher Web page to allow parents/guardians to input contact detals on a per family basis Admin pages to allow add/delete/modify students, teachers, groups Admin pages to allow assignment to teacher and group Admin page to change cliclatel connection settings for ftp & http Send SMS to particular parent based on student name or parent name or input number Send SMS to a group (clickatel ftp api) or to all Keep a log of messages sent Simple design to allow for use with a PC as part of a larger site or use with mobile