sharetraitdatabase

ShareTrait Database — a relational SQL database providing a structured implementation of the ShareTrait data. It includes the full schema definition, data tables and supporting documentation.

https://github.com/sharetraitproject/sharetraitdatabase

Science Score: 44.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • CITATION.cff file
    Found CITATION.cff file
  • codemeta.json file
    Found codemeta.json file
  • .zenodo.json file
    Found .zenodo.json file
  • DOI references
  • Academic publication links
  • Academic email domains
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (8.7%) to scientific vocabulary

Keywords

database database-schema experiment measurements observations
Last synced: 6 months ago · JSON representation ·

Repository

ShareTrait Database — a relational SQL database providing a structured implementation of the ShareTrait data. It includes the full schema definition, data tables and supporting documentation.

Basic Info
  • Host: GitHub
  • Owner: ShareTraitProject
  • License: cc-by-4.0
  • Language: Python
  • Default Branch: main
  • Homepage:
  • Size: 14.4 MB
Statistics
  • Stars: 0
  • Watchers: 1
  • Forks: 0
  • Open Issues: 6
  • Releases: 1
Topics
database database-schema experiment measurements observations
Created over 1 year ago · Last pushed 7 months ago
Metadata Files
Readme License Citation

README.md

ShareTrait DataBase SQL

This repository contains the ShareTrait DataBase (STDB) SQL of ShareTrait Project Data

Repository Structure

The SharetraitDatabase repository is structured as follows. Only the ShareTraitDatabase repository is described

``` ShareTraitProject/ ├── other-repos ├── ShareTraitDatabase/ | ├── README.md | ├── CONTRIBUTORS | ├── LICENSE | ├── db │ │ ├── STdbv01/ │ │ ├── stdb-all/ │ │ ├── README.md | ├── diagrams | ├── documentation | ├── mappings │ │ ├── attributemappingv02/ │ │ ├── attributemappings_v01/ │ │ ├── dataset-db-attributes-mapping-v1/ │ │ ├── README.md | ├── queries | ├── mappings │ ├── sharatrait-database-v1/ │ │ ├── db-documentation/ │ │ ├── db-export/ │ │ ├── db-queries/ │ │ ├── db-tables/ │ │ ├── db-export/ | ├── tables


```

Repository general description

Hereby we describe the general content found for each folder of the directory. Please make sure you look at the README.md of each folder for more information regarding the content of the files in the folders

| folder name | description | link | last modified | | :--- | :--- | :--- | :--- | | db | sharetrait database sql versions | link | 2024-06-12 | | diagrams | database schemas and models versions | link | 2024-08-18 | | documentation | definitions and description of the ER model | link | 2024-08-01 | | mappings | mappings for aligning db attributes to sharetrait previous versions | link| 2024-11-05 | | queries | questions queries mapping for selecting data | link | 2024-09-13 | | sharetrait-database-v1 | v1.0.0 of sharetrait database | link | 2024-11-18 | | tables | list of data files to populate database | link | 2024-11-04 |


[!NOTE] Please note that this repository is active. For the latest version, please refer to the latest database release folder Current version: sharetrait-database-v1, last modified on 2025-07-23

Owner

  • Login: ShareTraitProject
  • Kind: user

Citation (CITATION.cff)

# YAML 1.2
---
cff-version: "1.2.0"
message: "If you use this software, please cite it using the information provided in this metadata."
authors:
  -
    given-names: Irene
    family-names: Martorelli
    affiliation: "Vrije Universiteit Amsterdam"
    orcid: "https://orcid.org/0009-0000-3860-9290"
  -
    given-names: "Brett G."
    family-names: Olivier
    affiliation: "Vrije Universiteit Amsterdam"
    orcid: "https://orcid.org/0000-0002-5293-5321"
  -
    given-names: Raimon
    family-names: "Cuxart-Erruz"
    affiliation: "Martin Luther University Halle-Wittenberg"
    orcid: "https://orcid.org/0009-0004-1885-2022"
  -
    given-names: "Félix P."
    family-names: Leiva
    affiliation: "Radboud University Nijmegen"
    orcid: "https://orcid.org/0000-0003-0249-9274"
  -
    given-names: "Matty P."
    family-names: Berg
    affiliation: "Vrije Universiteit Amsterdam"
    orcid: "https://orcid.org/0000-0001-8442-8503"
  -
    given-names: Jacintha
    family-names: Ellers
    affiliation: "Vrije Universiteit Amsterdam"
    orcid: "https://orcid.org/0000-0003-2665-1971"
  -
    given-names: "Wilco C.E.P."
    family-names: Verberk
    affiliation: "Radboud University Nijmegen"
    orcid: "https://orcid.org/0000-0002-0691-583X"
title: "ShareTraitDatabase"
version: "1.2.0"
repository-code: "https://github.com/ShareTraitProject/ShareTraitDatabase/tree/db-release"
date-released: 2025-07-25
doi: ""
license: "CC-BY-4.0"
abstract: "ShareTrait DataBase (STDB) SQL – version 1.2.0 includes the schema, data tables, queries, and scripts needed to set up the ShareTrait database locally. It supports trait-based research by organizing trait, taxon, and experimental data in a structured format. Documentation and setup instructions are included in this repository."
keywords:
  - database
  - "data integration"
  - trait
  - standards
  - measurement
  - experiment
  - organism
  - speciees
  - population
  - observation
...

GitHub Events

Total
  • Push event: 1
  • Pull request event: 1
  • Create event: 1
Last Year
  • Push event: 1
  • Pull request event: 1
  • Create event: 1