-------------------------------+----------------+
| TABLE_NAME                               | COLUMN_NAME           | column_order | COLUMN_TYPE   | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | IS_NULLABLE | COLUMN_DEFAULT    | COLUMN_KEY | EXTRA                                         | COLUMN_COMMENT |
+------------------------------------------+-----------------------+--------------+---------------+-----------+--------------------------+-------------------+---------------+-------------+-------------------+------------+-----------------------------------------------+----------------+
| airgens_action_log                       | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_action_log                       | user_id               |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_action_log                       | action_type           |            3 | varchar(20)   | varchar   |                       20 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_action_log                       | affected_table        |            4 | varchar(100)  | varchar   |                      100 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_action_log                       | affected_id           |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_action_log                       | description           |            6 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_action_log                       | tstam                 |            7 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_category                         | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_category                         | title                 |            2 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_category                         | status                |            3 | int           | int       |                     NULL |                10 |             0 | NO          | 1                 |            |                                               |                |
| airgens_category                         | tstam                 |            4 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_category_test                    | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_category_test                    | title                 |            2 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_category_test                    | tstam                 |            3 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_company_quotation                | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_company_quotation                | user_id               |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_company_quotation                | status                |            3 | int           | int       |                     NULL |                10 |             0 | NO          | 0                 |            |                                               |                |
| airgens_company_quotation                | branch_id             |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_company_quotation                | prefix_id             |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_company_quotation                | file_name             |            6 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_company_quotation                | file_path             |            7 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_company_quotation                | json_file_name        |            8 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_company_quotation                | json_file_path        |            9 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_company_quotation                | reference_code        |           10 | varchar(100)  | varchar   |                      100 |              NULL |          NULL | NO          | NULL              | MUL        |                                               |                |
| airgens_company_quotation                | customer_company_name |           11 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              | MUL        |                                               |                |
| airgens_company_quotation                | tstam                 |           12 | timestamp     | timestamp |                     NULL |              NULL |          NULL | YES         | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_company_quotation_status_history | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_company_quotation_status_history | quotation_id          |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_company_quotation_status_history | status                |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_company_quotation_status_history | uby                   |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_company_quotation_status_history | remark                |            5 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_company_quotation_status_history | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_customers                        | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_customers                        | customer_name         |            2 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_customers                        | customer_group        |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers                        | customer_status       |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers                        | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_customers_detail                 | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_customers_detail                 | customer_id           |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers_detail                 | detid                 |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers_detail                 | valstr                |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_customers_detail                 | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers_detail                 | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_customers_key                    | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_customers_key                    | detid                 |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers_key                    | item_desc             |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_customers_key                    | status                |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_customers_key                    | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_item_detail                      | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_item_detail                      | category_id           |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_item_detail                      | detid                 |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_item_detail                      | valstr                |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_item_detail                      | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | 1                 |            |                                               |                |
| airgens_item_detail                      | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_item_detail_test                 | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_item_detail_test                 | category_id           |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_item_detail_test                 | detid                 |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_item_detail_test                 | valstr                |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_item_detail_test                 | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_item_key                         | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_item_key                         | detid                 |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | MUL        |                                               |                |
| airgens_item_key                         | item_desc             |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_item_key                         | status                |            4 | int           | int       |                     NULL |                10 |             0 | NO          | 1                 |            |                                               |                |
| airgens_item_key                         | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_item_key_test                    | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_item_key_test                    | detid                 |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_item_key_test                    | item_desc             |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_item_key_test                    | tstam                 |            4 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product                          | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product                          | name                  |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_product                          | category_id           |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product                          | brand_id              |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product                          | model_id              |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product                          | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product                          | status                |            7 | int           | int       |                     NULL |                10 |             0 | NO          | 1                 |            |                                               |                |
| airgens_product_brand                    | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product_brand                    | name                  |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_product_brand                    | tstam                 |            3 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product_categories               | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product_categories               | name                  |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_product_categories               | parent_id             |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_categories               | level                 |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_categories               | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product_detail                   | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product_detail                   | product_id            |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_detail                   | detid                 |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_detail                   | valstr                |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_product_detail                   | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_detail                   | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product_model                    | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product_model                    | name                  |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_product_model                    | tstam                 |            3 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_product_price_history            | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_product_price_history            | product_id            |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_price_history            | price_type            |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_price_history            | valstr                |            4 | decimal(10,2) | decimal   |                     NULL |                10 |             2 | NO          | NULL              |            |                                               |                |
| airgens_product_price_history            | uby                   |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_product_price_history            | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_salesperson_detail               | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_salesperson_detail               | login_id              |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_salesperson_detail               | detid                 |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_salesperson_detail               | valstr                |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_salesperson_detail               | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_salesperson_detail               | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_salesperson_key                  | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        |                                               |                |
| airgens_salesperson_key                  | detid                 |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_salesperson_key                  | item_desc             |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_salesperson_key                  | status                |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_salesperson_key                  | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_template_category                | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_template_category                | category_name         |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_template_category                | status                |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_template_category                | cby                   |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_template_category                | cdt                   |            5 | datetime      | datetime  |                     NULL |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_template_category                | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| airgens_template_category_detail         | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| airgens_template_category_detail         | category_id           |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_template_category_detail         | category_title        |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_template_category_detail         | category_text         |            4 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_template_category_detail         | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | 1                 |            |                                               |                |
| airgens_template_category_detail         | cby                   |            6 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| airgens_template_category_detail         | cdt                   |            7 | datetime      | datetime  |                     NULL |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| airgens_template_category_detail         | tstam                 |            8 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED                             |                |
| company_branch                           | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| company_branch                           | prefix_id             |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_branch                           | branch_name           |            3 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| company_branch                           | status                |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_branch                           | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| company_detail                           | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| company_detail                           | branch_id             |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_detail                           | prefix_id             |            3 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_detail                           | detid                 |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_detail                           | detail                |            5 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| company_detail                           | tstam                 |            6 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| company_item_key                         | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| company_item_key                         | detid                 |            2 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_item_key                         | item_desc             |            3 | text          | text      |                    65535 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| company_item_key                         | status                |            4 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_item_key                         | tstam                 |            5 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| company_login                            | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| company_login                            | username              |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| company_login                            | password              |            3 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| company_login                            | is_main               |            4 | int           | int       |                     NULL |                10 |             0 | NO          | 0                 |            |                                               |                |
| company_login                            | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_login                            | prefix_id             |            6 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              |            |                                               |                |
| company_login                            | tstam                 |            7 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| quotation_prefix                         | rowid                 |            1 | int           | int       |                     NULL |                10 |             0 | NO          | NULL              | PRI        | auto_increment                                |                |
| quotation_prefix                         | company_name          |            2 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| quotation_prefix                         | prefix_value          |            3 | varchar(255)  | varchar   |                      255 |              NULL |          NULL | NO          | NULL              |            |                                               |                |
| quotation_prefix                         | tstam                 |            4 | timestamp     | timestamp |                     NULL |              NULL |          NULL | NO          | CURRENT_TIMESTAMP |            | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |                |
| quotation_prefix                         | status                |            5 | int           | int       |                     NULL |                10 |             0 | NO          | 0                 |            |                                               |                |
+------------------------------------------+-----------------------+-------