TABLES
57
VIEWS
0
COLUMNS
305
Constraints
89
Anomalies
3
Routines
0
Database Properties
Database Type: PostgreSQL - 15.10 (Debian 15.10-1.pgdg120+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| community2community | 0 | 2 | 2 | -1 | Table | |
| collection | 8 | 3 | 6 | -1 | Table | |
| epersongroup | 14 | 1 | 4 | -1 | Table | |
| process2bitstream | 0 | 2 | 2 | -1 | Table | |
| schema_version | 0 | 0 | 10 | -1 | Table | |
| resourcepolicy | 0 | 3 | 12 | -1 | Table | |
| community | 3 | 3 | 4 | -1 | Table | |
| orcid_queue | 0 | 2 | 9 | -1 | Table | |
| process | 2 | 0 | 8 | -1 | Table | |
| community2collection | 0 | 2 | 2 | -1 | Table | |
| doi | 0 | 1 | 6 | -1 | Table | |
| versionitem | 0 | 3 | 7 | -1 | Table | |
| group2group | 0 | 2 | 2 | -1 | Table | |
| item2bundle | 0 | 2 | 2 | -1 | Table | |
| metadatavalue | 0 | 2 | 8 | -1 | Table | |
| versionhistory | 1 | 0 | 1 | -1 | Table | |
| webapp | 0 | 0 | 5 | -1 | Table | |
| cwf_pooltask | 0 | 3 | 7 | -1 | Table | |
| systemwidealert | 0 | 0 | 5 | -1 | Table | |
| subscription_parameter | 0 | 1 | 4 | -1 | Table | |
| cwf_workflowitem | 4 | 2 | 6 | -1 | Table | |
| item | 15 | 3 | 8 | -1 | Table | |
| orcid_token | 0 | 2 | 4 | -1 | Table | |
| relationship_type | 1 | 2 | 12 | -1 | Table | |
| cwf_workflowitemrole | 0 | 3 | 5 | -1 | Table | |
| relationship | 0 | 3 | 9 | -1 | Table | |
| handle | 0 | 1 | 5 | -1 | Table | |
| checksum_results | 2 | 0 | 2 | -1 | Table | |
| group2groupcache | 0 | 2 | 2 | -1 | Table | |
| checksum_history | 0 | 2 | 7 | -1 | Table | |
| metadataschemaregistry | 1 | 0 | 3 | -1 | Table | |
| bitstreamformatregistry | 2 | 0 | 6 | -1 | Table | |
| cwf_in_progress_user | 0 | 2 | 4 | -1 | Table | |
| cwf_claimtask | 0 | 2 | 6 | -1 | Table | |
| dspaceobject | 13 | 0 | 1 | -1 | Table | |
| eperson | 10 | 1 | 13 | -1 | Table | |
| harvested_collection | 0 | 1 | 10 | -1 | Table | |
| site | 0 | 1 | 1 | -1 | Table | |
| fileextension | 0 | 1 | 3 | -1 | Table | |
| process2group | 0 | 2 | 2 | -1 | Table | |
| bitstream | 7 | 2 | 10 | -1 | Table | |
| bundle2bitstream | 0 | 2 | 4 | -1 | Table | |
| requestitem | 0 | 2 | 12 | -1 | Table | |
| subscription | 1 | 2 | 4 | -1 | Table | |
| registrationdata | 0 | 0 | 4 | -1 | Table | |
| entity_type | 2 | 0 | 2 | -1 | Table | |
| workspaceitem | 0 | 3 | 8 | -1 | Table | |
| epersongroup2eperson | 0 | 2 | 2 | -1 | Table | |
| metadatafieldregistry | 1 | 1 | 5 | -1 | Table | |
| bundle | 2 | 2 | 3 | -1 | Table | |
| cwf_collectionrole | 0 | 2 | 4 | -1 | Table | |
| openurltracker | 0 | 0 | 3 | -1 | Table | |
| collection2item | 0 | 2 | 2 | -1 | Table | |
| supervision_orders | 0 | 2 | 3 | -1 | Table | |
| harvested_item | 0 | 1 | 4 | -1 | Table | |
| orcid_history | 0 | 2 | 11 | -1 | Table | |
| most_recent_checksum | 0 | 2 | 9 | -1 | Table |