Description:
Stores issues raised in the system, including links to users, vehicles, rentals, bookings, invoices, and metadata such as category and state.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the issue. |
title |
TEXT | Title of the issue. |
description |
TEXT | Descriptive text or notes about the issue. |
category |
NUMBER | Category of the issue: 0 => FINE, 1 => ACCIDENT, 2 => VEHICLE_PARTS_MISSING, 3 => VEHICLE_NEEDS_SERVICE, 4 => VEHICLE_NEEDS_INSPECTION, 5 => VEHICLE_NOT_READY, 6 => VEHICLE_DAMAGED, 7 => VEHICLE_COMMUNICATION, 8 => PARKING_PROBLEM, 9 => PURCHASE, 10 => TOLL, 11 => INSURANCE, 12 => DELIVERY, 13 => CORRECTION. |
category_name |
TEXT | String label for category. |
state |
NUMBER | State of the issue: 0 => CREATED, 1 => CLOSED, 2 => WAITING, 3 => IN_REPAIR. |
state_name |
TEXT | String label for state. |
created_at |
TIMESTAMP_TZ | Timestamp when the issue was created. |
updated_at |
TIMESTAMP_TZ | Timestamp of the last update to the issue. |
created_by |
NUMBER | User or system ID that initially created the issue. |
updated_by |
NUMBER | User or system that last modified the issue. |
branch_id |
NUMBER | Branch where the issue originated. |
invoice_id |
NUMBER | Invoice ID linked to the issue. |
rental_id |
NUMBER | Rental ID associated with the issue, if applicable. |
booking_id |
NUMBER | Booking associated with the issue. |
vehicle_id |
NUMBER | Vehicle associated with this issue. |
affected_guser_id |
NUMBER | Internal identifier for the user affected by the issue. |
group_id |
NUMBER | If part of a group or fleet booking, the group identifier. |
cost_center_id |
NUMBER | ID for cost center allocation (for business accounting). |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |