quotations:

• id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
• id_format VARCHAR(64) NOT NULL
• id_value INT(10) UNSIGNED NOT NULL
• client_id INT(10) UNSIGNED NOT NULL
• staff_id INT(10) UNSIGNED NOT NULL
• title VARCHAR(255) NOT NULL
• status ENUM('draft', 'pending', 'approved', 'invoiced', 'expired', 'dead', 'lost') DEFAULT 'draft'
• subtotal DECIMAL(19, 4) NOT NULL DEFAULT 0.0000
• total DECIMAL(19, 4) NOT NULL DEFAULT 0.0000
• currency CHAR(3) NOT NULL DEFAULT 'USD'
• notes TEXT NOT NULL
• date_created DATETIME NOT NULL
• date_expires DATETIME NOT NULL

quotation_lines

• id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
• quotation_id INT(10) UNSIGNED NOT NULL
• description TEXT NOT NULL
• qty DECIMAL(19, 4) NOT NULL DEFAULT 0.0000
• amount DECIMAL(19, 4) NOT NULL DEFAULT 0.0000
• order SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0

quotation_line_taxes

• line_id INT(10) UNSIGNED NOT NULL
• tax_id INT(10) UNSIGNED NOT NULL
• cascade TINYINT(1) UNSIGNED NOT NULL DEFAULT 0
• subtract TINYINT(1) UNSIGNED NOT NULL DEFAULT 0

quotation_invoices

• quotation_id INT(10) UNSIGNED NOT NULL
• invoice_id INT(10) UNSIGNED NOT NULL

Company Settings