Tables


SchemaSpy Analysis of sanbi

Generated on Tue Sept 12 11:24 SAST 2023

XML Representation
Insertion Order Deletion Order
TABLES 79
VIEWS 4
COLUMNS 498
Constraints 83
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 15.4

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
survey_method 2 0 3 -1 Table
otp_static_statictoken 0 1 3 -1 Table
django_celery_results_taskresult 0 0 15 -1 Table
frontend_contextlayerlegend 0 1 4 -1 Table
organisation_representative 0 2 3 -1 Table
socialaccount_socialapp_sites 0 2 3 -1 Table
frontend_contextlayer 2 0 4 -1 Table
annual_population 0 9 29 -1 Table
taxon 5 2 13 -1 Table
frontend_uploadspeciescsv 0 2 14 -1 Table
frontend_draftspeciesupload 0 3 10 -1 Table
socialaccount_socialapp 2 0 6 -1 Table
socialaccount_socialaccount 1 1 7 -1 Table
activity_activitytype 1 0 3 -1 Table
otp_totp_totpdevice 0 1 13 -1 Table
django_celery_beat_periodictasks 0 0 2 -1 Table
auth_group 3 0 2 -1 Table
user_title 1 0 2 -1 Table
django_content_type 4 0 3 -1 Table
frontend_statisticalmodel 1 1 4 -1 Table
property 5 4 11 -1 Table
user_login 0 2 5 -1 Table
OrganisationInvites 0 2 6 0 Table
parcel_type 1 0 2 -1 Table
django_session 0 0 3 -1 Table
frontend_boundarysearchrequest 0 1 13 -1 Table
django_site 2 0 3 -1 Table
organisation 6 2 5 -1 Table
easyaudit_requestevent 0 0 7 -1 Table
open_close_system 1 0 2 -1 Table
account_emailconfirmation 0 1 5 -1 Table
django_celery_beat_crontabschedule 1 0 7 -1 Table
data_use_permission 1 0 3 -1 Table
auth_user_groups 0 2 3 -1 Table
parcel 0 2 8 -1 Table
login_status 1 0 2 -1 Table
django_celery_results_groupresult 0 0 7 -1 Table
django_celery_beat_intervalschedule 1 0 3 -1 Table
django_celery_beat_solarschedule 1 0 4 -1 Table
django_celery_beat_periodictask 0 4 23 -1 Table
account_emailaddress 1 1 5 -1 Table
frontend_boundaryfile 0 1 8 -1 Table
spatial_ref_sys 3 0 5 8500 Table
count_method 1 0 2 -1 Table
taxon_rank 1 0 2 -1 Table
django_admin_log 0 2 8 -1 Table
population_estimate_category 1 0 2 -1 Table
sampling_effort_coverage 1 0 2 -1 Table
frontend_contextlayertilingtask 0 0 10 -1 Table
species_taxonsurveymethod 0 2 3 -1 Table
otp_static_staticdevice 1 1 6 -1 Table
notification_reminder 0 0 5 -1 Table
user_profile 0 4 11 -1 Table
django_migrations 0 0 4 -1 Table
property_type 1 0 2 -1 Table
frontend_statisticalmodeloutput 0 1 3 -1 Table
frontend_spatialdatamodel 1 2 3 -1 Table
certainty 1 0 3 -1 Table
easyaudit_crudevent 0 0 10 -1 Table
auth_user_user_permissions 0 2 3 -1 Table
django_celery_results_chordcounter 0 0 4 -1 Table
django_redirect 0 1 4 -1 Table
auth_user 19 0 11 -1 Table
socialaccount_socialtoken 0 2 6 -1 Table
annual_population_per_activity 0 2 15 -1 Table
population_status 1 0 2 -1 Table
guardian_groupobjectpermission 0 3 5 -1 Table
organisation_user 0 2 3 -1 Table
sampling_size_unit 1 0 2 -1 Table
easyaudit_loginevent 0 0 6 -1 Table
guardian_userobjectpermission 0 3 5 -1 Table
auth_group_permissions 0 2 3 -1 Table
Reminders 0 2 11 0 Table
owned_species 2 3 5 -1 Table
django_celery_beat_clockedschedule 1 0 2 -1 Table
auth_permission 4 1 4 -1 Table
province 2 0 2 -1 Table
user_role 2 0 3 -1 Table
frontend_spatialdatavaluemodel 0 1 3 -1 Table
geography_columns 0 1 7 0 View
geometry_columns 0 1 7 0 View
raster_columns 0 1 17 0 View
raster_overviews 0 0 9 0 View