We need a web based lead generation system created. I have included a schematic of the necessary tables and functionality needed.
Super Administrator has the ability to add new dental practices, delete records and access ALL tables.
Administrator has the ability to add new employees, have access to tables within their practice, cannot delete records
Functionality will allow users to log in under a specific practice, create new records, search, print, send texts and emails.
Web form will send name (F &L) Email and Phone - to database
Please review the data flow structure in the attached document.