tenants

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
attachments.tenant_id FK_attachments_tenants_tenant_id C
attributes.tenant_id FK_attributes_tenants_tenant_id C
baselayers.tenant_id FK_baselayers_tenants_tenant_id C
basemaps.tenant_id FK_basemaps_tenants_tenant_id C
constraints.tenant_id FK_constraints_tenants_tenant_id C
constraints_members.tenant_id FK_constraints_members_tenants_tenant_id C
domains.tenant_id FK_domains_tenants_tenant_id C
domains_elements.tenant_id FK_domains_elements_tenants_tenant_id C
elements.tenant_id FK_elements_tenants_tenant_id C
features.tenant_id FK_features_tenants_tenant_id C
features_locks.tenant_id FK_features_locks_tenants_tenant_id C
features_versions.tenant_id FK_features_versions_tenants_tenant_id C
groups.tenant_id FK_groups_tenants_tenant_id C
groups_users.tenant_id FK_groups_users_tenants_tenant_id C
jobs.tenant_id FK_jobs_tenants_tenant_id C
jobs_tasks.tenant_id FK_jobs_tasks_tenants_tenant_id C
layers.tenant_id FK_layers_tenants_tenant_id C
layers_groups.tenant_id FK_layers_groups_tenants_tenant_id C
layers_styles.tenant_id FK_layers_styles_tenants_tenant_id C
maps.tenant_id FK_maps_tenants_tenant_id C
roles.tenant_id FK_roles_tenants_tenant_id C
roles_components.tenant_id FK_roles_components_tenants_tenant_id C
schemas.tenant_id FK_schemas_tenants_tenant_id C
sms_category.tenant_id FK_sms_category_tenants_tenant_id C
sms_dozer_parameters.tenant_id FK_sms_dozer_parameters_tenants_tenant_id C
sms_fixed_zone_algo_machine_parameters.tenant_id FK_sms_fixed_zone_algo_machine_parameters_tenants_tenant_id C
sms_fixed_zone_algo_result.tenant_id FK_sms_fixed_zone_algo_result_tenants_tenant_id C
sms_hiboo_daily_data.tenant_id FK_sms_hiboo_daily_data_tenants_tenant_id C
sms_hiboo_equipment.tenant_id FK_sms_hiboo_equipment_tenants_tenant_id C
sms_kpi_machines_cycles.tenant_id FK_sms_kpi_machines_cycles_tenants_tenant_id C
sms_kpi_sites.tenant_id FK_sms_kpi_sites_tenants_tenant_id C
sms_kpi_sites_machines.tenant_id FK_sms_kpi_sites_machines_tenants_tenant_id C
sms_loader_daily_zone.tenant_id FK_sms_loader_daily_zone_tenants_tenant_id C
sms_loader_move.tenant_id FK_sms_loader_move_tenants_tenant_id C
sms_loader_parameters.tenant_id FK_sms_loader_parameters_tenants_tenant_id C
sms_machine.tenant_id FK_sms_machine_tenants_tenant_id C
sms_machine_site_association.tenant_id FK_sms_machine_site_association_tenants_tenant_id C
sms_machine_teltonika_tracker.tenant_id FK_sms_machine_teltonika_tracker_tenants_tenant_id C
sms_machine_type.tenant_id FK_sms_machine_type_tenants_tenant_id C
sms_mobile_events.tenant_id FK_sms_mobile_events_tenants_tenant_id C
sms_other_parameters.tenant_id FK_sms_other_parameters_tenants_tenant_id C
sms_scraper_cycle.tenant_id FK_sms_scraper_cycle_tenants_tenant_id C
sms_scraper_daily_zone.tenant_id FK_sms_scraper_daily_zone_tenants_tenant_id C
sms_scraper_move.tenant_id FK_sms_scraper_move_tenants_tenant_id C
sms_scraper_parameters.tenant_id FK_sms_scraper_parameters_tenants_tenant_id C
sms_shift.tenant_id FK_sms_shift_tenants_tenant_id C
sms_shift_day.tenant_id FK_sms_shift_day_tenants_tenant_id C
sms_site.tenant_id FK_sms_site_tenants_tenant_id C
sms_site_parameters.tenant_id FK_sms_site_parameters_tenants_tenant_id C
sms_state.tenant_id FK_sms_state_tenants_tenant_id C
sms_teltonika_gps_data.tenant_id FK_sms_teltonika_gps_data_tenants_tenant_id C
sms_teltonika_scraper_gps_data.tenant_id FK_sms_teltonika_scraper_gps_data_tenants_tenant_id C
sms_teltonika_tracker.tenant_id FK_sms_teltonika_tracker_tenants_tenant_id C
sms_tgd_computed_info.tenant_id FK_sms_tgd_computed_info_tenants_tenant_id C
sms_truck_cycle.tenant_id FK_sms_truck_cycle_tenants_tenant_id C
sms_truck_daily_zone.tenant_id FK_sms_truck_daily_zone_tenants_tenant_id C
sms_truck_move.tenant_id FK_sms_truck_move_tenants_tenant_id C
sms_truck_parameters.tenant_id FK_sms_truck_parameters_tenants_tenant_id C
sms_zone.tenant_id FK_sms_zone_tenants_tenant_id C
sms_zone_attributes.tenant_id FK_sms_zone_attributes_tenants_tenant_id C
users.tenant_id FK_users_tenants_tenant_id C

Unique identifier.
name varchar 63 null
organization varchar 256 null
fullname varchar 256 √ null
email varchar 256 null
url text 2147483647 √ null
bytea 2147483647 √ null
smtp_host text 2147483647 √ null
smtp_port int4 10 √ null
smtp_username text 2147483647 √ null
smtp_password text 2147483647 √ null
smtp_security int4 10 √ null
db_username text 2147483647 √ null
db_password text 2147483647 √ null
srid int4 10 null
spatial_ref_sys.srid Implied Constraint R
locale text 2147483647 null
time_zone text 2147483647 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null

User who create the record. Null if System.
updated_at timestamptz 35,6 √ null

DateTime the record was last updated.
updated_by uuid 2147483647 √ null

User who last updated the record.
is_system bool 1 false

A system-generated record. Default = false

Indexes

Constraint Name Type Sort Column(s)
PK_tenants Primary key Asc id
IX_tenants_created_at Performance Asc created_at
IX_tenants_id Must be unique Asc id
IX_tenants_is_system Performance Asc is_system
IX_tenants_name Must be unique Asc name

Relationships

Close relationships within degrees of separation