organisation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
organisation_representative.organisation_id organisation_represe_organisation_id_193faa53_fk_organisatR
organisation_user.organisation_id organisation_user_organisation_id_fc223d75_fk_organisation_idR
OrganisationInvites.organisation_id OrganisationInvites_organisation_id_b73b3468_fk_organisation_idR
property.organisation_id property_organisation_id_80655533_fk_organisation_idR
Reminders.organisation_id Reminders_organisation_id_89663faf_fk_organisation_idR
user_profile.current_organisation_id user_profile_current_organisation_46e2d249_fk_organisatR
name varchar 250 null
data_use_permission_id int8 19 null
data_use_permission.id organisation_data_use_permission__df588176_fk_data_use_R
national bool 1 √ null
province_id int8 19 √ null
province.id organisation_province_id_58368a67_fk_province_idR

Indexes

Constraint Name Type Sort Column(s)
organisation_pkey Primary key Asc id
organisation_data_use_permission_id_df588176 Performance Asc data_use_permission_id
organisation_name_359ed331_like Performance Asc name
organisation_name_key Must be unique Asc name
organisation_province_id_58368a67 Performance Asc province_id

Relationships

Close relationships within degrees of separation