Overview of the Data Model

• test

• Brief description of what this is: establishes and visualizes relationships across entities in the database

Implementation of the Data Model

• Data will be stored in Synapse

• Brief mention of schematic and instantiation of the database to support relational database model, as outlined in diagram above

• Ingress of data and population of the database will comply with the latest version of the schemas (ref link below)

Additional Resources

• Source NFTI Data Model Diagram in LucidChart (linked and updated in this document)

  • Description: This is the source diagram of the Data Model for the NF Research Tool Database, generated and maintained LucidChart (noted: please reference the “New Layout Database Schema” sheet). The latest version of this diagram is linked and updated in this document. 

  • Link: https://lucid.app/documents/edit/3a118e5e-8884-48d1-af91-f03987bb0df8/0?callback=close&name=docs&callback_type=back&v=16092&s=612 

• NFTI Schema

  • Description: [X]  

  • Link to schema in Github: https://github.com/nf-osi/nf-research-tools-schema  

  • Link to schema in shared gdrive: https://docs.google.com/spreadsheets/d/15fwIhZw7YfhPkzOfQhj6zU_5-_7ywS05-L8qOjMIVdM/edit#gid=0  

Contact Information

Please feel free to contact Robert Allaway (robert.allaway@sagebase.org) and Ashley Clayton (ashley.clayton@sagebase.org) with any questions or comments related to the NFTI data model or any of the resources linked in this document

Acknowledgments

Thank you to Brynn Zalmanek, James Eddy, Mialy DeFelice, Milen Nikolov and Robert Allaway at Sage for contributions to the development and implementation of the NFTI schemas and data model, and to GFF for valuable contributions and feedback.