# Appointment

| Attribute         | Type    | Description                                                                       |
| ----------------- | ------- | --------------------------------------------------------------------------------- |
| id                | integer | ID of the sale                                                                    |
| sale\_id          | integer | Sale unique identifier                                                            |
| sale\_product\_id | integer | Sale product unique identifier                                                    |
| client\_id        | integer | Client unique identifier                                                          |
| vehicle\_id       | integer | Vehicle unique identifier                                                         |
| bay\_id           | integer | Bay unique identifier                                                             |
| workflow\_id      | integer | Workflow step unique identifier                                                   |
| date\_at          | date    | Date of the start of the appointment                                              |
| time\_at          | time    | Time of the start of the appointment                                              |
| date\_end         | date    | Date of the end of the appointment                                                |
| time\_end         | time    | Time of the end of the appointment                                                |
| duration          | float   | Duration of the appointment excluding diner and optionally out of business hours. |
| description       | text    | Optional description for the appointment                                          |
| title             | text    | Optional title for the appointment                                                |
| notes             | text    | Optional notes for the appointment                                                |
| color             | text    | Color displayed in the agenda                                                     |