Schemas represent the structure of datasets.

Overview

A schema defines the tables and columns present in all datasets with that schema. All datasets with the same schema have the same structure and can have the same concepts and cohorts applied to them.

All schemas are available to all users, which means all users are able to create concepts and cohorts for every schema.

Information

The information you will receive when either listing schemas or getting information on a specific schema is:

Schema

Description

name

The name of the schema

description

The description of that schema

datasets

The datasets that have this schema, along with information about each dataset

primary tables

The Tables that are patient-centric and contain medical information about the patient.

support tables

The tables that are not patient-centric. They may hold information about providers, locations, etc.

columns

For each table, the columns in that table.

Endpoints

You can list all schemas here.

For a given Schema you can: