CREATE TABLE wp_clients (client_id, company_name, siren, tva, email, phone, status...);
CREATE TABLE wp_contacts (contact_id, client_id, first_name, last_name, email, phone...);
CREATE TABLE wp_deals (deal_id, client_id, amount, probability, stage, close_date...);
CREATE TABLE wp_projects (project_id, client_id, name, start_date, end_date, budget...);
CREATE TABLE wp_tasks (task_id, project_id, title, assigned_to, status, deadline...);
CREATE TABLE wp_invoices (invoice_id, client_id, number, date, amount, status...);
CREATE TABLE wp_client_tags (client_id, tag_id);
CREATE TABLE wp_deal_activities (deal_id, activity_id);
CREATE TABLE wp_project_members (project_id, user_id);
CREATE TABLE wp_invoice_items (invoice_id, item_id, quantity, price...);