CREATE TABLE wp_ip_client ( client_id INT NOT NULL AUTO_INCREMENT, client_name NVARCHAR(128) NOT NULL, invoice_address NVARCHAR(512) NULL, PRIMARY KEY (client_id), UNIQUE INDEX client_name (client_name ASC)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ciCREATE TABLE wp_ip_project ( project_code NVARCHAR(45) NOT NULL, client_id INT NOT NULL, UNIQUE INDEX project_code_UNIQUE (project_code ASC), PRIMARY KEY (project_code)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ciCREATE TABLE wp_ip_invoice_item ( item_id INT NOT NULL AUTO_INCREMENT, project_code NVARCHAR(45) NOT NULL, sub_invoice_id INT NULL, sub_item_code NVARCHAR(45) NULL, sub_description NVARCHAR(512) NULL, sub_units DOUBLE NULL, sub_rate DOUBLE NULL, client_invoice_id INT NULL, client_item_code NVARCHAR(45) NULL, client_description NVARCHAR(512) NULL, client_units DOUBLE NULL, client_rate DOUBLE NULL, PRIMARY KEY (item_id), UNIQUE INDEX item_id_UNIQUE (item_id ASC)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci WEF Invoice Portal – Shared | smeans

WEF Invoice Portal – Shared