sms_site

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_machine_site_association.site_id FK_sms_machine_site_association_sms_site_site_id C
sms_shift.site_id FK_sms_shift_sms_site_site_id C
sms_site_parameters.site_id FK_sms_site_parameters_sms_site_site_id C
sms_zone.site_id FK_sms_zone_sms_site_site_id N

Unique identifier.
tenant_id uuid 2147483647 null
tenants.id FK_sms_site_tenants_tenant_id C

Tenant identifier.
name varchar 256 null
geo_center geometry 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
deleted_at timestamptz 35,6 √ null
description text 2147483647 √ null
reports_email text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_sms_site Primary key Asc id
IX_sms_site_created_at Performance Asc created_at
IX_sms_site_id Must be unique Asc id
IX_sms_site_is_system Performance Asc is_system
IX_sms_site_name Performance Asc name
IX_sms_site_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation