Description:
Represents physical and virtual station locations where vehicles can be picked up or returned. Includes the station’s geographic position, service area, capacity, type, and operational state.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the station. |
name |
TEXT | Human-readable name of the station. |
type |
NUMBER | Station type (0 => VIRTUAL. 1 => DOCKING. 2 => RECOMMENDED. 3 => PROMOTION). |
type_name |
TEXT | String label for type. |
capacity |
NUMBER | Maximum number of vehicles the station can hold. |
position |
GEOMETRY | Geolocation of the station. |
area |
GEOMETRY | Geographic service area / boundary of the station. |
visibility |
NUMBER | Bitmap-encoded visibility flags (EnumSet<StationVisibility>, OR-ed 1 << N), persisted as a raw integer rather than a single ordinal. |
state |
NUMBER | Operational state of the station (0 => ACTIVE. 1 => INACTIVE). |
state_name |
TEXT | String label for state. |
valid_until |
TIMESTAMP_TZ | Timestamp until which the station is valid. |
branch_id |
NUMBER | Foreign key to the branch the station belongs to. |
created_at |
TIMESTAMP_TZ | Creation timestamp. |
updated_at |
TIMESTAMP_TZ | Last update timestamp. |
created_by |
NUMBER | Identifier of the user who created the station. |
updated_by |
NUMBER | Identifier of the user who last updated the station. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | Timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | Timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |