2. PhenoDB overview

Schematic overview of entities (slightly simplified)

Schema description

• met Metadata schema. Holds metadata of the individual level data in the coh and sec schemas, and of the summary level data in the sum schema.
• coh Cohort data schema. Holds individual level data.
• sec Secure cohort data schema. Holds more sensitive individual level data that is always deemed to be hidden from a standard extraction. This can be individual identifiable identifiers such as study participant ID's, personal contact information etc.
• sum Summary data schema. This schema holds non-individual level data and aggregated summary statistics such as phenotype population prevalences and genotype association dataset specific data.

Standardised table description

The Metadata Schema 'met'

Tables and views in this schema are generally friendly to interact with manually, in contrast to the tables in the coh schema. The tables are named and created to model most entities and relations of the database.

• assessment Assessments. Characterised by a code and version code. Corresponds to a typical standardised questionnaire, but can capture anything of the sort from other kinds of assessments. Different types of assessments are modelled by the assessment_type. Each version of assessment will have its own row and identifier.