Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-2401 Quotation System
  3. CORE-4793

Quotation System: Database

        Details

        • Type: Sub-task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 5.7.0-b1
        • Component/s: None
        • Labels:
          None

          Description

          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

          Key Value
          default_quotation_valid_days 30
          default_quotation_dead_days 10
          default_quotation_deposit_percentage 50
          default_quotation_notes  

            Activity

            Ascending order - Click to sort in descending order
            jonathan Jonathan Reissmueller created issue -
            jonathan Jonathan Reissmueller made changes -
            Field Original Value New Value
            Fix Version/s 5.7.0-b1 [ 11737 ]
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'dead') 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'
            * date_created DATETIME NOT NULL
            * valid_until 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
            * line_id INT(10) UNSIGNED NOT NULL             		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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'dead') 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'
            * date_created DATETIME NOT NULL
            * valid_until 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'dead') 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'
            * date_created DATETIME NOT NULL
            * valid_until 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'dead') 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'dead') 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'expired') 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * status ENUM('draft', 'pending', 'approved', 'invoiced', 'lost', 'expired') 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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
            * 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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
            * 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_dead_days|10|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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
            * 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_dead_days|10|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_dead_days|10|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            jonathan Jonathan Reissmueller made changes -
            Description 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'
            * 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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_dead_days|10|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            		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

            ||Key||Value||
            |default_quotation_valid_days|30|
            |default_quotation_dead_days|10|
            |default_quotation_deposit_percentage|50|
            |default_quotation_notes| |
            abdy Abdy Franco made changes -
            Assignee Abdy Franco [ abdy ]
            abdy Abdy Franco made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            abdy Abdy Franco made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 37 minutes [ 2220 ]
            Worklog Id 16066 [ 16066 ]
            abdy Abdy Franco made changes -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            abdy Abdy Franco made changes -
            Status In Review [ 5 ] Closed [ 6 ]

              People

              • Assignee:
                abdy Abdy Franco
                Reporter:
                jonathan Jonathan Reissmueller
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  4/May/23

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 37 minutes
                  37m

                    Agile