Lesson Summary

This lesson provides the steps for importing the three DDL statements that will create the three Domains. These three Domains are: 

  • User
  • GrantHistory
  • NotificationSetting

Lesson Steps

Step 1 - Create the User Domain

  • On the Project dashboard, go to the Domains panel and click on the New Domain button.



Step 2 - Create a new Domain from DDL Import

  • Click the Import from DDL button


Step 3 - Import a Single DDL

  • First, click the radio button for Import Single Domain from DDL
  • Then, click the Next button



Step 4 - Chose the appropriate database vendor

  • Open the Vendor pull down
  • If you're not using MySQL for this POC select the appropriate Vendor type, otherwise select mysql.



Step 5 - Paste the User DDL

  • Copy the 'user' DDL below and paste it into the DDL text area and click the Save button.

create table `user` (
  id              int(10) not null auto_increment, 
  external_id     varchar(50) not null unique, 
  first_name      varchar(25) not null, 
  last_name       varchar(25) not null, 
  middle_initial  char(1), 
  username        varchar(100) not null, 
  ssn             varchar(15) not null, 
  password        varchar(255) not null, 
  activation_date date, 
  primary key (id));





Step 6 - Preview your newly created Domain

  • If you have followed the above steps correctly, you should now be on the Domain dashboard for the User Domain.



Step 7 - Create the GrantHistory Domain

  • In the upper left corner of the Domain dashboard, click the New Domain button



Step 8 - Import DDL for GrantHistory

  • Repeat Steps 2 through 6 to Import 'grant_history' DDL below
  • Do not worry about the 'Preview Data Unavailable' message that appears after you've completed step 6; we will correct it later. Move onto step 9 below.


create table grant_history (
  id           int(10) not null auto_increment, 
  granter_id   varchar(50) not null unique, 
  first_name   varchar(25) not null, 
  last_name    varchar(25) not null, 
  username     varchar(100) not null, 
  status       varchar(15) not null, 
  credit_card  varchar(25) not null, 
  card_type    varchar(25) not null, 
  grant_date   date not null, 
  grant_amount float not null, 
  primary key (id));


Step 9 - Create the NotificationSetting Domain

  • In the upper left corner of the Domain dashboard, click the New Domain button



Step 10 - Import DDL for NotificationSetting

  • Repeat Steps 2 through 6 to Import 'notification_setting' DDL below


create table notification_setting (
  id               int(10) not null auto_increment, 
  user_external_id varchar(50) not null unique, 
  username         varchar(100) not null, 
  frequency_count  int(10) not null, 
  frequency_type   varchar(15) not null, 
  hit_rate         int(10) not null, 
  failure_rate     int(10) not null, 
  primary key (id));


Step 11 - Go to the Project Dashboard

  • On the main menu, at the top of your screen, click the Project Dashboard menu option.



If you have completed creating all three Domains, you should now see the following view.



Move onto the next lesson >