Tables


SchemaSpy Analysis of ada

Generated on Wed Apr 12 15:06 GMT 2023

XML Representation
Insertion Order Deletion Order
TABLES 16
VIEWS 3
COLUMNS 119
Constraints 16
Anomalies 0
Routines 2

Database Properties

Database Type: PostgreSQL - 14.6

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
file_extensions 1 0 7 -1 Table

Table to hold different file name extensions allowed by ADA system
subject_schemas 1 0 6 -1 Table

Table holding json schemas of different subject(object) approved by ADA system, e.g. analysis object, sample object
record_creators 0 3 5 -1 Table

Table to hold creators of the datasets
record_files 0 2 10 -1 Table

Table to hold metadata of the file related to the datasets
funders 1 0 6 -1 Table

Table to hold different funder information allowed by ADA system
name_entities 4 0 7 -1 Table

Table to hold different personal or organizational names
record_subjects 0 2 6 -1 Table

Table holding dataset-related subjects, stored in json format, conforming to approved json schemas
name_entity_identifiers 0 2 6 -1 Table

Table to hold identifiers of person or organization
records 7 0 13 1 Table

Table to hold core metada of the record
curators 0 0 5 -1 Table

Table to hold curators with role
external_identifier_schemes 1 0 6 -1 Table

Table to hold different identifier scheme infomation allowed by ADA system
record_fundings 0 2 8 -1 Table

Table to hold funding information of the datasets
record_contributors 0 2 6 -1 Table

Table to hold contributors of the datasets
licenses 1 0 6 -1 Table

Table to hold different license information allowed by ADA system
record_trails 0 1 4 -1 Table

Table to hold track infomation of the records
record_licenses 0 2 5 -1 Table

Table to hold rights information of the datasets
v_name_entities 0 0 7 0 View
view_datacite_contributors 0 0 3 0 View
view_datacite_creators 0 0 3 0 View