frontend_draftspeciesupload

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
name varchar 256 null
upload_date timestamptz 35,6 null
uuid uuid 2147483647 null
year int4 10 √ null
last_step int4 10 √ null
form_data jsonb 2147483647 √ null
property_id int8 19 null
property.id frontend_draftspeciesupload_property_id_0076ca92_fk_property_idR
taxon_id int8 19 √ null
taxon.id frontend_draftspeciesupload_taxon_id_1a354749_fk_taxon_idR
upload_by_id int4 10 null
auth_user.id frontend_draftspecie_upload_by_id_1570b9a9_fk_auth_userR

Indexes

Constraint Name Type Sort Column(s)
frontend_draftspeciesupload_pkey Primary key Asc id
frontend_draftspeciesupload_property_id_0076ca92 Performance Asc property_id
frontend_draftspeciesupload_taxon_id_1a354749 Performance Asc taxon_id
frontend_draftspeciesupload_upload_by_id_1570b9a9 Performance Asc upload_by_id

Check Constraints

Constraint Name Constraint
frontend_draftspeciesupload_year_check ((year >= 0))
frontend_draftspeciesupload_last_step_check ((last_step >= 0))

Relationships

Close relationships within degrees of separation