Description:
Stores metadata for files uploaded to the platform. Files may be linked to various entities such as damages, fines, issues, rentals, users, or vehicles. Tracks ownership, visibility, and file details.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER |
Unique identifier for the file. |
created_at |
TIMESTAMP_TZ |
Timestamp when the file record was created. |
file_name |
TEXT |
Original name of the uploaded file. |
file_size |
NUMBER |
Size of the file in bytes. |
media_type |
TEXT |
MIME type of the file. |
updated_at |
TIMESTAMP_TZ |
Timestamp when the file record was last updated. |
fine_id |
NUMBER |
Identifier of the fine associated with this file. |
is_public |
BOOLEAN |
Indicates whether the file is publicly accessible. |
issue_comment_id |
NUMBER |
Identifier of the issue comment linked to this file. |
rental_id |
NUMBER |
Identifier of the rental associated with this file. |
guser_id |
NUMBER |
Identifier of the user associated with this file. |
vehicle_id |
NUMBER |
Identifier of the vehicle associated with this file. |
state |
NUMBER |
Current state of the file. (0 => ACTIVE. 1 => INACTIVE) |
state_name |
TEXT |
String label for state. |
created_by |
NUMBER |
Identifier of the user who created the file record. |
updated_by |
NUMBER |
Identifier of the user who last updated the file record. |
damage_id |
NUMBER |
Identifier of the damage record linked to this file. |
_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. |