Tables


SchemaSpy Analysis of vagrantdb.public

Generated on Wed Mar 19 12:25 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 116
VIEWS 0
COLUMNS 740
Constraints 149
Anomalies 5
Routines 0

Database Properties

Database Type: PostgreSQL - 16.8

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
bannermessage 2 0 3 -1 Table
oairecord 0 0 5 -1 Table
variablerangeitem 0 1 3 -1 Table
dataverse 0 3 22 -1 Table
builtinuser 1 0 4 -1 Table
flyway_schema_history 0 0 10 90 Table
ingestreport 0 1 7 -1 Table
datasetversion 5 2 17 -1 Table
metadatablock 4 1 5 -1 Table
fileaccessrequests 0 3 6 -1 Table
filemetadata_datafilecategory 0 2 2 -1 Table
datafilecategory 1 1 3 -1 Table
foreignmetadataformatmapping 1 0 5 -1 Table
passwordresetdata 0 1 6 -1 Table
setting 0 0 4 -1 Table
workflowstepdata_stepparameters 0 1 3 -1 Table
actionlogrecord 0 0 8 -1 Table
customfieldmap 0 0 4 -1 Table
shibgroup 0 0 4 -1 Table
storagesite 0 0 5 -1 Table
customzipservicerequest 0 0 4 -1 Table
dataversetheme 0 1 15 -1 Table
roleassignment 0 2 6 -1 Table
dataverse_citationdatasetfieldtypes 0 2 2 -1 Table
explicitgroup_authenticateduser 0 2 2 -1 Table
bannermessagetext 0 1 4 -1 Table
datasetmetrics 0 1 12 -1 Table
dataverserole 2 1 6 -1 Table
datasetfielddefaultvalue 1 3 6 -1 Table
embargo 1 0 3 -1 Table
makedatacountprocessstate 0 0 5 -1 Table
workflowstepdata_stepsettings 0 1 3 -1 Table
datasetversionuser 0 2 4 -1 Table
storagequota 0 1 3 -1 Table
confirmemaildata 0 1 5 -1 Table
userbannermessage 0 2 4 -1 Table
dataversecontact 0 1 4 -1 Table
datafiletag 0 1 3 -1 Table
datasetfieldcompoundvalue 1 1 3 -1 Table
dataversesubjects 0 2 2 -1 Table
explicitgroup_containedroleassignees 0 1 2 -1 Table
summarystatistic 0 1 4 -1 Table
storageuse 0 1 3 -1 Table
variablerange 0 1 6 -1 Table
dataversemetadatablockfacet 0 2 3 -1 Table
alternativepersistentidentifier 0 1 8 -1 Table
termsofuseandaccess 2 2 18 -1 Table
ingestrequest 0 1 6 -1 Table
datasetfieldvalue 0 1 4 -1 Table
dataversefieldtypeinputlevel 0 2 6 -1 Table
apitoken 0 1 6 -1 Table
dataversefeatureditem 0 1 5 -1 Table
variablecategory 1 1 7 -1 Table
globustaskinprogress 0 2 8 -1 Table
harvestingclient 2 1 21 -1 Table
externaltool 1 0 10 -1 Table
customquestionresponse 0 2 4 -1 Table
datafile 0 3 12 -1 Table
externalvocabularyvalue 0 0 4 -1 Table
filemetadata 3 2 9 -1 Table
datasetexternalcitations 0 1 3 -1 Table
ipv6range 0 1 10 -1 Table
controlledvocabalternate 0 2 4 8229 Table
workflow 2 0 2 -1 Table
pendingworkflowinvocation_localdata 0 1 3 -1 Table
persistedglobalgroup 2 0 7 -1 Table
controlledvocabularyvalue 3 1 5 8595 Table
dataset 0 8 17 -1 Table
foreignmetadatafieldmapping 1 2 6 -1 Table
guestbook 3 1 9 -1 Table
explicitgroup 4 1 6 -1 Table
externalfileuploadinprogress 0 0 3 -1 Table
clientharvestrun 0 1 8 -1 Table
datasetlinkingdataverse 0 2 4 -1 Table
template 4 2 7 -1 Table
dataverselinkingdataverse 0 2 4 -1 Table
auxiliaryfile 0 1 10 -1 Table
license 2 0 12 1 Table
datasetfield 3 4 5 -1 Table
authenticateduserlookup 0 1 4 -1 Table
datasettype 2 0 2 -1 Table
dataverse_metadatablock 0 2 2 -1 Table
datasettype_metadatablock 0 2 2 -1 Table
retention 1 0 3 -1 Table
customquestionvalue 0 1 4 -1 Table
datasetlock 0 2 6 -1 Table
oaiset 0 0 8 -1 Table
vargroup 1 1 3 -1 Table
ipv4range 0 1 4 -1 Table
pendingworkflowinvocation 1 2 11 -1 Table
defaultvalueset 1 0 2 -1 Table
customquestion 2 1 7 -1 Table
oauth2tokendata 0 1 8 -1 Table
datavariable 7 1 17 -1 Table
explicitgroup_explicitgroup 0 2 2 -1 Table
datatable 1 1 11 -1 Table
vargroup_datavariable 0 2 2 -1 Table
dataversefeatureddataverse 0 2 4 -1 Table
workflowcomment 0 2 7 -1 Table
authenticationproviderrow 0 0 6 -1 Table
sequence 0 0 2 -1 Table
datasetfieldtype 9 2 18 176 Table
workflowstepdata 2 1 5 -1 Table
categorymetadata 0 2 4 -1 Table
usernotification 0 2 9 -1 Table
savedsearch 1 2 4 -1 Table
harvestingdataverseconfig 0 1 8 -1 Table
dataversefacet 0 2 4 -1 Table
metric 0 1 7 -1 Table
externaltooltype 0 1 3 -1 Table
savedsearchfilterquery 0 1 3 -1 Table
dvobject 49 3 20 -1 Table
guestbookresponse 2 5 13 -1 Table
variablemetadata 1 3 12 -1 Table
authenticateduser 17 0 18 -1 Table
datasetfield_controlledvocabularyvalue 0 2 2 -1 Table