Tables


SchemaSpy Analysis of dspace.public

Generated on Mon Dec 30 18:18 ART 2024

XML Representation
Insertion Order Deletion Order
TABLES 41
VIEWS 0
COLUMNS 213
Constraints 67
Anomalies 4
Routines 37

Database Properties

Database Type: PostgreSQL - 9.6.24

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
community2community 0 2 2 0 Table
collection 8 6 9 0 Table
checksum_history 0 2 7 0 Table
epersongroup 13 1 4 0 Table
metadataschemaregistry 1 0 3 0 Table
bitstreamformatregistry 2 0 6 0 Table
schema_version 0 0 10 0 Table
resourcepolicy 0 3 12 0 Table
community 3 3 4 0 Table
dspaceobject 12 0 1 0 Table
community2collection 0 2 2 0 Table
eperson 7 1 12 0 Table
harvested_collection 0 1 10 0 Table
doi 0 1 6 0 Table
site 0 1 1 0 Table
fileextension 0 1 3 0 Table
bitstream 6 2 10 0 Table
bundle2bitstream 0 2 4 0 Table
versionitem 0 3 7 0 Table
group2group 0 2 2 0 Table
item2bundle 0 2 2 0 Table
metadatavalue 0 2 8 0 Table
subscription 0 2 3 0 Table
requestitem 0 2 12 0 Table
registrationdata 0 0 4 0 Table
tasklistitem 0 2 3 0 Table
versionhistory 1 0 1 0 Table
epersongroup2workspaceitem 0 2 2 0 Table
webapp 0 0 5 0 Table
workspaceitem 1 3 8 0 Table
epersongroup2eperson 0 2 2 0 Table
metadatafieldregistry 1 1 5 0 Table
bundle 2 2 3 0 Table
item 7 3 8 0 Table
collection2item 0 2 2 0 Table
harvested_item 0 1 4 0 Table
handle 0 1 5 0 Table
checksum_results 2 0 2 0 Table
group2groupcache 0 2 2 0 Table
most_recent_checksum 0 2 9 0 Table
workflowitem 1 3 8 0 Table