local_units_externallymanagedlocalunit

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
enabled bool 1 null
country_id int4 10 null
api_country.id local_units_external_country_id_ee34f26d_fk_api_countR
created_by_id int4 10 √ null
auth_user.id local_units_external_created_by_id_7c6ae11c_fk_auth_userR
local_unit_type_id int8 19 null
local_units_localunittype.id local_units_external_local_unit_type_id_2fd5f599_fk_local_uniR
updated_by_id int4 10 √ null
auth_user.id local_units_external_updated_by_id_47689aac_fk_auth_userR

Indexes

Constraint Name Type Sort Column(s)
local_units_externallymanagedlocalunit_pkey Primary key Asc id
local_units_externallymana_local_unit_type_id_2fd5f599 Performance Asc local_unit_type_id
local_units_externallymanagedlocalunit_country_id_ee34f26d Performance Asc country_id
local_units_externallymanagedlocalunit_created_by_id_7c6ae11c Performance Asc created_by_id
local_units_externallymanagedlocalunit_updated_by_id_47689aac Performance Asc updated_by_id
unique_country_local_unit_type Must be unique Asc/Asc country_id + local_unit_type_id

Relationships

Close relationships within degrees of separation