AACT Database Schema

An AACT Database Schema is a database schema for an AACT database.

• See: ClinicalTrials.gov Data.

---

---

References

2023

• https://aact.ctti-clinicaltrials.org/schema
  • QUOTE: The diagram below illustrates how ClinicalTrials.gov data is stored in the AACT database; it identifies all tables/columns and relationships.

    Each table includes the unique identifier assigned by ClinicalTrials.gov: nct_id. This provides a way to find all data about a particular study and serves as the key that joins related information across multiple tables. Every table (except Studies) also includes an id column which uniquely identifies each row in the table. In most cases, you need to use the nct_id to join tables. For more information about the id column, please refer to the documentation found here.

    AACT schema diagrams and documentation may be downloaded from the following links:

    • downloadable schema diagram (right click on the resulting page to download)
    • excel version of data dictionary (online searchable version also available here)
    • excel version of table definitions
  • 

---