Clients and Fees

The "Clients" table stores information about the company's clients, including their name, the date they became a client, address, and other details that might be relevant to the company's interactions with them.

The "Invoices" table tracks information about invoices sent to clients, including a unique reference number, the status of the invoice (such as whether it has been paid or is overdue), the date it was issued, the date it was paid, any discounts applied, and other details that may be relevant to the invoice.

The "Projects" table records information about projects that the company is working on for clients, including the name of the project, the client it is for, the start and end dates, a description of the project, other relevant details, and a reference to the invoice that will be used to bill the client for the work.

The "Staff" table stores information about the company's employees, including their name, a photo, their job type, phone number, email address, address, and other details that might be relevant to their employment.

The "Staff On Projects" table links staff members to the projects they are working on, along with their role on the project, the dates they are working on it, and their hourly rate for the work.

The "Staff Skills" table records information about the skills that each staff member possesses, along with their level of expertise in each skill. This table can be used to help assign staff members to projects that require specific skills.