Description:
Captures notes within the platform. Notes can be linked to multiple entities such as branches, users, rentals, vehicles, bookings, or damages. Tracks authorship, updates, and lifecycle state.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER |
Unique identifier for the note. |
created_at |
TIMESTAMP_TZ |
Timestamp when the note was created. |
updated_at |
TIMESTAMP_TZ |
Timestamp when the note was last updated. |
title |
TEXT |
Title or short summary of the note. |
content |
TEXT |
Detailed text content of the note. |
state |
NUMBER |
Current state of the note. (0 => ACTIVE. 1 => INACTIVE) |
state_name |
TEXT |
String label for state. |
created_by |
NUMBER |
Identifier of the user who created the note. |
branch_id |
NUMBER |
Identifier of the branch associated with the note (if applicable). |
guser_id |
NUMBER |
Identifier of the user the note refers to (if applicable). |
rental_id |
NUMBER |
Identifier of the rental associated with the note (if applicable). |
vehicle_id |
NUMBER |
Identifier of the vehicle associated with the note (if applicable). |
updated_by |
NUMBER |
Identifier of the user who last updated the note. |
booking_id |
NUMBER |
Identifier of the booking associated with the note (if applicable). |
damage_id |
NUMBER |
Identifier of the damage record associated with the note (if applicable). |
_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. |