Dispatch
Tables (33)
app_forms
- id — character — Primary key — NOT NULL
- name — character
- description — character
app_forms_fields
- id — character — Primary key — NOT NULL
- id (app_forms_id) — character — Foreign key → app_forms.id — NOT NULL
- name — character
- action — character
- type — character
- required — boolean
- checklist_fields — jsonb
audit_logs
- id — character — Primary key — NOT NULL
- operation_name — character
- operation_time — timestamp
- table_name — character
- log_type — character
- entity_id — character
- user_id — character
- before — character
- after — character
auth_clients
- id — character — Primary key — NOT NULL
- client_id — character — NOT NULL
- client_secret — character — NOT NULL
- redirect_url — character
- access_token_expiration — integer
- refresh_token_expiration — integer
- auth_code_expiration — integer
- secret — character
- created_on — timestamp
- modified_on — timestamp
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
auth_clients_user
- id — character — Primary key — NOT NULL
- id (auth_clients_id) — character — Foreign key → auth_clients.id — NOT NULL
- user_id — character
- created_on — timestamp
- modified_on — timestamp
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
backoffice_user_credentials
- id — character — Primary key — NOT NULL
- email — character
- username — character
- password — character
- user_id — character
backoffice_users
- id — character — Foreign key → backoffice_user_credentials.id — NOT NULL
- role — character
- firstname — character
- lastname — character
- rut — character
- email — character
- origin — character
- status — character
company
- id — integer — Primary key — NOT NULL
- name — character
- rut — character
- status — character
- is_mobile — boolean
- realm — character
- tenant_id — character
- is_gps — boolean
- is_router — boolean
- webhook_stop — character
- webhook_service — character
- webhook_pickup — character
- webhook_service_finish — character
company_config
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- photo_signature — boolean
- qr_signature — boolean
- local_signature — boolean
- detection_radio — double
- presentation_time — double
- geotime_interval — double
crew_order
- id — character — Primary key — NOT NULL
- id (crew_id) — character — Foreign key → crews.id — NOT NULL
- id (id2) — integer — Foreign key → crews.id — NOT NULL
- id (id22) — character — Foreign key → crews.id — NOT NULL
- id (company_id2) — integer — Foreign key → crews.id — NOT NULL
- service_order_id — character
- name — character
- charge — character
- rut — character
crews
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- id (vehicle_id) — character — Foreign key → vehicles.id — NOT NULL
- id (company_id2) — integer — Foreign key → vehicles.id — NOT NULL
- redd_id — integer
- role — integer
- username — character
- first_name — character
- last_name — character
- reference — character
- rut — character
- phone — character
- email — character
- realm — character
- origin — character
- status — character
- roles — jsonb
customer
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- name — character
- reference — character
- realm — character
data_stop_mobile
- id — character — Primary key — NOT NULL
- Key (error_delivery_id) — Foreign key → error_delivery.Key — NOT NULL
- service_order_id — character
- stop_id — character
- vehicle_id — character
- name_contact — character
- phone_contact — character
- note_contact — character
- coordinates_delivery — point
- description_delivery — character
- rut_delivery — character
- name_delivery — character
- status — character
- date_timestamp — timestamp
- user_id — character
- delivery_index — character
- error_delivery — character
- service_order — character
devices
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- model — character
- app_version — character
- os — character
- version_so — character
- date_creation — timestamp
- date_modification — timestamp
- date_last — timestamp
- fcm_token — character
- user_id — character
- enabled — boolean
- vehicle_id — character
error_delivery
- Key (id) — Primary key — NOT NULL
- name — character
- status — character
event_gps
- id — character — Primary key — NOT NULL
- id (device_id) — character — Foreign key → devices.id — NOT NULL
- id (company_id) — integer — Foreign key → devices.id — NOT NULL
- id (vehicle_id) — character — Foreign key → vehicles.id — NOT NULL
- id (company_id2) — integer — Foreign key → vehicles.id — NOT NULL
- id (user_id) — character — Foreign key → users_dispatch.id — NOT NULL
- event_id — integer
- date_utc — timestamp
- date_creation — timestamp
- coordinates — point
last_state
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- modem_id — character
- date_timestamp — timestamp
- plate_number — character
- event_id — integer
- event_name — character
- speed — real
- azimuth — real
- altitude — real
- longitude — real
- latitude — real
- odometer — real
- hourmeter — real
- data_json — jsonb
picture_stop
- id — character — Primary key — NOT NULL
- id (user_id) — character — Foreign key → users_dispatch.id — NOT NULL
- original_name — character
- bucket — character
- keys3 — character
- locations3 — character
- etag — character
- encoding — character
- mimetype — character
- size — integer
- order_picture — integer
- stop_id — character
- data_stop_mobile_id — character
- gps_coordinates — point
roles
- id — character — Primary key — NOT NULL
- name — character
- created_on — timestamp
- modified_on — timestamp
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
- permissions — character
- role_key — integer
route_request
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- created_at — timestamp
- status — character
- vehicle_cant — integer
- stops_cant — integer
- communes_cant — integer
- routes_cant — integer
- response_at — timestamp
- publish_at — timestamp
- external_router_id — character
- start_date — timestamp
- request_object — jsonb
- response_object — jsonb
- publish_object — jsonb
route_request_points
- id — character — Primary key — NOT NULL
- id (route_request_id) — character — Foreign key → route_request.id — NOT NULL
- id (company_id) — integer — Foreign key → route_request.id — NOT NULL
- external_router_id — character
- delivery_index — integer
- plate_number — character
- points_object — jsonb
- waypoints_object — jsonb
routes_name
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- name — text
- reference — text
service_order_xml_records
- id — character — Primary key — NOT NULL
- id (service_order_id) — character — Foreign key → services.id — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- id (route_id) — character — Foreign key → routes_name.id — NOT NULL
- id (company_id2) — integer — Foreign key → routes_name.id — NOT NULL
- reference — character
- route — character
- service_order_id2 — character
- date_service — timestamp
- driver_dni — character
- driver_firstname — character
- driver_lastname — character
- xml_type — character
- cant_stops — integer
- keys3 — character
- created_at — timestamp
- plate_number — character
- route_id (rutaid2) — character
- updated_external — timestamp
- so_updated_external — timestamp
- observation — text
- cant_so — integer
- executed_at — timestamp
services
- id — character — Primary key — NOT NULL
- reference — character
- company_id — integer
- customer_id — character
- customer_name — character
- vehicle_id — character
- modem_id — character
- plate_number — character
- route_id — character
- route — character
- driver_id — character
- driver_firstname — character
- driver_lastname — character
- date_service — timestamp
- present — character
- present_date — timestamp
- present_real_date — timestamp
- start_date — timestamp
- start_real_date — timestamp
- end_date — timestamp
- end_real_date — timestamp
- status — character
- time_status — character
- delay — integer
- eta — timestamp
- closed — boolean
- open_door — integer
- comercial_km — double
- app_status — character
- route_name — character
- time_status_present_date — character
- time_status_start_date — character
- time_status_end_date — character
- keys3 — character
- id2 — character
- nmovil — character
- delivery_index — integer
- route_request_id — character
- realm — character
- user_mobile_id — character
- user_tetris_id — integer
- tetris_user_id — character
- rutaid — integer
- created_at — timestamp
- to_recalculate — boolean
- updated_at — timestamp
- updated_external — timestamp
stops
- id — character — Primary key — NOT NULL
- id (service_order_id) — character — Foreign key → services.id — NOT NULL
- route_order — character
- coordinates — point
- description — character
- address — character
- locality — character
- province — character
- detail — character
- order_stop — integer
- radius — integer
- gps_status — character
- gps_status_code — integer
- gps_status_detail — character
- app_status — character
- app_status_code — integer
- app_status_detail — character
- schedule_geo_timestamp — timestamp
- schedule_start_timestamp — timestamp
- schedule_end_timestamp — timestamp
- schedule_coordinates — point
- gps_geo_timestamp — timestamp
- gps_start_timestamp — timestamp
- gps_end_timestamp — timestamp
- gps_coordinates — point
- modem_id — character
- event_id — character
- speed — real
- odometer — real
- hourmeter — real
- app_geo_timestamp — timestamp
- app_start_timestamp — timestamp
- app_end_timestamp — timestamp
- app_coordinates — point
- service_order_id2 — character
- is_origin — boolean
- commune — character
- region — character
tenants
- id — character — Primary key — NOT NULL
- name — character
- type_tenants — character
- realm — character
- created_on — timestamp
- modified_on — timestamp
- created_by — character
- modified_by — character
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
- status — character
tracking_package_stop
- id — character — Primary key — NOT NULL
- id (stop_id) — character — Foreign key → stops.id — NOT NULL
- id (service_order_id) — character — Foreign key → stops.id — NOT NULL
- id (data_stop_mobile_id) — character — Foreign key → data_stop_mobile.id — NOT NULL
- Key (error_delivery_id) — Foreign key → data_stop_mobile.Key — NOT NULL
- date_read_timestamp — timestamp
- code — character
- create_timestamp — timestamp
- origin — character
- pickup_timestamp — timestamp
- status — character
- order — integer
- service_order — text
user_credentials
- id — character — Primary key — NOT NULL
- id (vehicle_id) — character — Foreign key → vehicles.id — NOT NULL
- id (company_id) — integer — Foreign key → vehicles.id — NOT NULL
- email — character
- username — character
- password — character
- user_id — character
- patent — character
user_credentials_dis
- id — character — Primary key — NOT NULL
- id (user_id) — character — Foreign key → users_dispatch.id — NOT NULL
- auth_provider — character
- auth_id — character
- auth_token — character
- password — character
- created_on — timestamp
- modified_on — timestamp
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
user_tenant_permissions
- id — character — Primary key — NOT NULL
- id (user_tenant_id) — character — Foreign key → user_tenants.id — NOT NULL
- id (user_id) — character — Foreign key → user_tenants.id — NOT NULL
- id (role_id) — character — Foreign key → user_tenants.id — NOT NULL
- id (id2) — character — Foreign key → user_tenants.id — NOT NULL
- created_on — timestamp
- modified_on — timestamp
- created_by — character
- modified_by — character
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
- permission — character
- allowed — boolean
user_tenants
- id — character — Primary key — NOT NULL
- id (user_id) — character — Foreign key → users_dispatch.id — NOT NULL
- id (role_id) — character — Foreign key → roles.id — NOT NULL
- id (tenant_id) — character — Foreign key → tenants.id — NOT NULL
- created_on — timestamp
- modified_on — timestamp
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
- status — character
users_dispatch
- id — character — Primary key — NOT NULL
- first_name — character
- middle_name — character
- last_name — character
- username — character
- email — character
- rut — character
- vehicle_id — character
- is_mobile — boolean
- phone — character
- created_on — timestamp
- modified_on — timestamp
- created_by — character
- modified_by — character
- deleted — boolean
- deleted_on — timestamp
- deleted_by — character
- default_tenant — character
- last_login — timestamp
- redd_id — integer
- redd_company_id — integer
- redd_token — character
- redd_origin — character
- redd_realm — character
- redd_status — character
- user_mobile_id — character
vehicles
- id — character — Primary key — NOT NULL
- id (company_id) — integer — Foreign key → company.id — NOT NULL
- redd_id — integer
- company — character
- plate_number — character
- status — boolean
- name — character
- vin — character
- modem_id — character
- simcard — character
- engine_type_name — character
- device_type_id — integer
- device_type_name — character
- realm — character
- created_at — timestamp