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