# Tables

#### SchemaSpy Analysis of oa_organizations

Generated on mer mag 05 11:42 CEST 2021

XML Representation
Insertion Order Deletion Order
TABLES 19
VIEWS 8
COLUMNS 189
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 | 236394 | 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 | 216223 | Table |
other_ids | 0 | 2 | 3 | 344848 | Table |
journal | 0 | 2 | 6 | 336 | Table |
acronyms | 0 | 1 | 2 | 143341 | Table |
languages | 1 | 0 | 2 | 114 | Table |
org_index_search | 0 | 0 | 2 | 497675 | Table |
oa_duplicates | 0 | 2 | 8 | 219113 | Table |
user_roles | 2 | 0 | 1 | 5 | Table |
notes | 0 | 1 | 4 | 6 | Table |
relationships | 0 | 2 | 3 | 37572 | Table |
organizations | 12 | 2 | 22 | 497673 | 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 | 12 | 0 | View |
users_view | 0 | 2 | 6 | 0 | View |