DATABASE SCHEMA

Explore data model:

DOI

Referencing tables: attachment_link | doi_agent | doi_date | doi_geolocation | doi_related_identifier |


Field Database column Data type Description Referenced table
abstract abstract text
copyright_agent copyright_agent int agent
creators creators varchar
database database_id int database
dataset dataset int dataset
date_added date_added datetime
date_changed date_changed datetime
date_txt date_txt varchar
formats formats varchar
id id int(auto increment)
identifier identifier varchar
is_private is_private int
language language int list_language
licence licence int list_licence
methods methods text
owner owner int agent
publication_year publication_year varchar
publisher publisher varchar
reference reference int reference
remarks remarks text
resource resource varchar
resource_type resource_type int doi_resource_type
sizes sizes varchar
subjects subjects varchar
title title varchar
user_added user_added varchar
user_changed user_changed varchar
version version varchar