Tables


SchemaSpy Analysis of oa_organizations

Generated on mar apr 27 08:22 CEST 2021

XML Representation
Insertion Order Deletion Order
TABLES 19
VIEWS 8
COLUMNS 185
Constraints 19
Anomalies 5
Routines 0

Database Properties

Database Type: PostgreSQL - 12.6

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
tmp_dedup_events 0 0 19 236350 Table
org_types 1 0 2 9 Table
oa_conflicts 0 2 8 31290 Table
countries 2 0 2 259 Table
urls 0 1 2 216098 Table
other_ids 0 2 3 361455 Table
journal 0 2 6 320 Table
acronyms 0 1 2 143307 Table
languages 1 0 2 114 Table
org_index_search 0 0 2 497619 Table
oa_duplicates 0 2 8 219046 Table
user_roles 2 0 1 5 Table
notes 0 1 4 6 Table
relationships 0 2 3 37572 Table
organizations 12 2 22 497617 Table
id_types 1 0 2 18 Table
other_names 0 2 3 146698 Table
user_countries 0 2 2 51 Table
users 3 1 5 26 Table
suggestions_info_by_country_view 0 0 5 0 View
organizations_info_view 0 0 9 0 View
duplicate_groups_view 0 0 5 0 View
conflict_groups_view 0 0 11 0 View
oa_duplicates_view 0 0 20 0 View
organizations_view 0 0 23 0 View
organizations_simple_view 0 0 8 0 View
users_view 0 2 6 0 View