Description:
Represents connectivity modules associated with vehicles or branches in the platform. Each module includes identifiers, metadata, connection status, and location context.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the module. |
created_at |
TIMESTAMP_TZ | Timestamp when the module record was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the module record was last updated. |
external_id |
TEXT | External identifier from an integration or third-party system. |
iccid |
TEXT | Integrated Circuit Card Identifier (SIM). |
last_online_at |
TIMESTAMP_TZ | The last known time the module was connected or online. |
name |
TEXT | Human-readable name of the module. |
state |
NUMBER | Current operational state of the module (0 => UNASSIGNED, 1 => ASSIGNED, 2 => RETIRED, 3 => NOT_READY, 4 => NEW). |
state_name |
TEXT | String label for state. |
type |
NUMBER | Numeric code representing the type/category of the module (0 => NIU, 1 => NIU_MC, 2 => DUMMY, 3 => NIU_PRTCL, 4 => NINEBOT_ES2, 5 => CUCA_BIKE, 6 => TRACKER, 7 => COMODULE_NINEBOT_ES2, 8 => GOVECS_GOT, 9 => NINEBOT_ES2_TLT, 10 => MANUAL_KICKSCOOTER, 11 => MANUAL_BICYCLE, 12 => NIU_TLT, 13 => SUPER_SOCO_TLT_125, 14 => CAR_TLT, 15 => SEGWAY_V1, 16 => NIU_V2, 17 => CAR_TLT_RELAIS, 18 => LANNMARKER_ZIMO, 19 => INVERS_CAR, 20 => DEVICE_CLOUD, 21 => NIU_V2_READ, 22 => FITRIDER, 23 => STANDARD_FLEET, 24 => JAVA_DEVICE_CLOUD). |
type_name |
TEXT | String label for type. |
created_by |
NUMBER | ID of the user or system that created the record. |
updated_by |
NUMBER | ID of the user or system that last updated the record. |
branch_id |
NUMBER | Foreign key to the branch this module is assigned to. |
secondary_external_id |
TEXT | Optional second external identifier used for extended integrations. |
mac_address |
TEXT | Media Access Control address for network identification. |
_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. |