Sample table: Shop transaction

gistfile1.txt

+-------------------+-----------+----------+-------------------------+
|    Field name     |   Type    |   Mode   |       Description       |
+-------------------+-----------+----------+-------------------------+
| id                | INTEGER   | REQUIRED | Transaction ID          |
| shop_name         | STRING    | NULLABLE |                         |
| customers         | INTEGER   | NULLABLE | Number of customers     |
| sales             | NUMERIC   | NULLABLE | Total sales             |
| tax               | NUMERIC   | NULLABLE | VAT tax paid            |
| cost              | NUMERIC   | NULLABLE | Total costs             |
| discount          | NUMERIC   | NULLABLE | Total discount          |
| invoiced_at       | TIMESTAMP | NULLABLE | Transaction time in UTC |
| local_invoiced_at | DATETIME  | NULLABLE | In local time           |
+-------------------+-----------+----------+-------------------------+