hubs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
package_events.hub_id package_events_hub_id_fkey R
packages.current_hub_id packages_current_hub_id_fkey R
routes.hub_id routes_hub_id_fkey R
shipments.current_hub_id shipments_current_hub_id_fkey R
shipments.hub_id shipments_hub_id_fkey R
tasks.hub_id tasks_hub_id_fkey R
vehicles.hub_id vehicles_hub_id_fkey R
uuid text 2147483647 √ null
name text 2147483647 √ null
address text 2147483647 √ null
place_id text 2147483647 √ null
lat float8 17,17 √ null
lng float8 17,17 √ null
storage_capacity int8 19 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
default_shift_start_time time 15,6 √ '08:00:00'::time without time zone
default_shift_end_time time 15,6 √ '18:00:00'::time without time zone
timezone text 2147483647 √ 'America/Caracas'::text
tenant_id int4 10 null
tenants.id hubs_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269256_hubs_pkey Primary key Asc id
idx_269256_ix_hubs_place_id Performance Asc place_id
idx_269256_ix_hubs_uuid Must be unique Asc uuid
ix_hubs_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation