tenants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tenants_id_seq'::regclass)
assignment_insights.tenant_id assignment_insights_tenant_id_fkey R
audit_logs.tenant_id audit_logs_tenant_id_fkey R
hubs.tenant_id hubs_tenant_id_fkey R
package_events.tenant_id package_events_tenant_id_fkey R
packages.tenant_id packages_tenant_id_fkey R
routes.tenant_id routes_tenant_id_fkey R
shipments.tenant_id shipments_tenant_id_fkey R
stops.tenant_id stops_tenant_id_fkey R
task_package_links.tenant_id task_package_links_tenant_id_fkey R
tasks.tenant_id tasks_tenant_id_fkey R
user_tenants.tenant_id user_tenants_tenant_id_fkey R
vehicle_position_logs.tenant_id vehicle_position_logs_tenant_id_fkey R
vehicle_tracking_statuses.tenant_id vehicle_tracking_statuses_tenant_id_fkey R
vehicles.tenant_id vehicles_tenant_id_fkey R
slug varchar 2147483647 null
name varchar 2147483647 null
auth0_org_id varchar 2147483647 √ null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
deleted_at timestamp 29,6 √ null
uuid varchar 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
tenants_pkey Primary key Asc id
ix_tenants_auth0_org_id Performance Asc auth0_org_id
ix_tenants_slug Must be unique Asc slug
ix_tenants_uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation