property

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
frontend_draftspeciesupload.property_id frontend_draftspeciesupload_property_id_0076ca92_fk_property_idR
frontend_spatialdatamodel.property_id frontend_spatialdatamodel_property_id_e7876a3a_fk_property_idR
frontend_uploadspeciescsv.property_id frontend_uploadspeciescsv_property_id_73bb6ef4_fk_property_idR
owned_species.property_id owned_species_property_id_0a341d83_fk_property_idR
parcel.property_id parcel_property_id_1ea05422_fk_property_idR
name varchar 300 null
owner_email varchar 254 √ null
property_size_ha int4 10 √ null
geometry geometry 2147483647 √ null
created_at timestamptz 35,6 null
created_by_id int4 10 null
auth_user.id property_created_by_id_b7197b07_fk_auth_user_idR
organisation_id int8 19 null
organisation.id property_organisation_id_80655533_fk_organisation_idR
property_type_id int8 19 null
property_type.id property_property_type_id_137d71ff_fk_property_type_idR
province_id int8 19 null
province.id property_province_id_70166351_fk_province_idR
open bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
property_pkey Primary key Asc id
property_created_by_id_b7197b07 Performance Asc created_by_id
property_geometry_18a8d6b8_id Performance Asc geometry
property_name_ed6eb277_like Performance Asc name
property_name_key Must be unique Asc name
property_organisation_id_80655533 Performance Asc organisation_id
property_property_type_id_137d71ff Performance Asc property_type_id
property_province_id_70166351 Performance Asc province_id

Relationships

Close relationships within degrees of separation