Appointment and service status tablethis table holds status the appointments
Language and language service requested (language=Spanish, service = face2face Interpreting)
Clients-ID, full name, address, business type and service delivery address.
Booking Table
Clients Table holds personal information about the business or individual requesting the service. Client table is related to both contact details and venue’s tables in one to many relationships. Contact-details ID and Venue-ID are both foreign keys inside clients table.
Qualification tables holds list of most language qualifications available internationally. It is related with the Employees table by having qualification-id field as a foreign key.
Employee Occupancy table holds the start time and end time for each job offered to employees.
Employee qualification table hold a list of qualification each employees have. This table is related in many to many relationships with both qualification and the employee’s tables. Each employee can have multiple qualifications and one qualification can be for many employees.
Languages table hold list of most languages spoken across the world. Each language will have a unique id which helps uniquely identified with in the table. It is also related in many to one relationship with both Appointments and Employee-Language tables using a language id (foreign key).
Invoice status table holds list of invoices for jobs done and the pending invoices.
Employee-Qualification table is a linking table between employees and Qualifications tables. The relationship between Qualifications and Employees table is many to many. Both tables are linked together in Employee qualification table using their foreign keys employee_employeesID and Qulification_qulificationID’s.
Venue table holds alternative contact details for clients if they wish to request a service in different place than the registered address. It is related to contact details using Contact-detialsID foreign key.
