Tables


SchemaSpy Analysis of oa_organizations

Generated on mer giu 23 08:32 CEST 2021

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

Database Properties

Database Type: PostgreSQL - 12.7

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
tmp_dedup_events 0 0 19 415560 Table
org_types 1 0 2 9 Table
oa_conflicts 0 2 8 26380 Table
countries 2 0 2 259 Table
urls 0 1 2 319561 Table
other_ids 0 2 3 449858 Table
journal 0 2 6 96434 Table
acronyms 0 1 2 248275 Table
languages 1 0 2 114 Table
org_index_search 0 0 2 602591 Table
oa_duplicates 0 2 8 319618 Table
user_roles 2 0 1 5 Table
notes 0 1 4 6 Table
relationships 0 2 3 37646 Table
organizations 12 2 22 602591 Table
id_types 1 0 2 18 Table
other_names 0 2 3 146791 Table
user_countries 0 2 2 58 Table
users 3 1 5 32 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 11 0 View
users_view 0 2 6 0 View