Note: The options for SCHEMA and ENUMERATION are not exposed by default. These advanced EDC features can be enabled by setting the following property in your brms.properties file: 
com.corticon.studio.edc.advancedFeatures=true

In the Vocabulary editor with its root selected, choose the EDC tab, and then click the SCHEMA Create/Update button

As the Create/Update Database Schema function will change an existing schema, consider whether you want that action. As this is a database we just created, yes, we want to create it.

After completion, the tables, columns, and keys are all setup, and a best effort is made to define join expressions. The schema is then imported back into the Vocabulary. You might need to refine join expressions.

Because this example created the database elements, the metadata was automatically defined in the Vocabulary so there is no need to perform the task of importing metadata..

Create the schema in the database

A Corticon EDC Datasource connection enables you to push the schema into the database. For a basic use case, this a great timesaver.

It is more often the case that a database administrator would create the schema for the persistent entities as tables and columns in the database. For the EDC sample, you need to have executed the Corticon SQL script patient for your database in your database management tool's editor.

Once the database has been setup for the Vocabulary, you need to import the metadata into Corticon Studio to complete the binding. In Corticon Studio on the Vocabulary's EDC tab, click METADATA: Import. The mapping metadata from the database is added into the Vocabulary for the Entities (tables), Attributes (columns), and Associations (join expressions). For more about mapping and possible anomalies, see Mapping and validating EDC database metadata.