Lookup Tables – Data Definition Language (DDL)

UniversityDataHub example for Lion State University

CREATE TABLE dim_address_type (
  address_type_id INT PRIMARY KEY,
  address_type_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_contact_type (
  contact_type_id INT PRIMARY KEY,
  contact_type_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_course_level_type (
  course_level_type_id INT PRIMARY KEY,
  course_level_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_enrollment_status_type (
  enrollment_status_type_id INT PRIMARY KEY,
  enrollment_status_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_ethnicity_type (
  ethnicity_type_id INT PRIMARY KEY,
  ethnicity_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_gender_type (
  gender_type_id INT PRIMARY KEY,
  gender_name VARCHAR(100) NOT NULL
);

 CREATE TABLE dim_grade_type (
  grade_type_id INT PRIMARY KEY,
  grade_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_race_type (
  race_type_id INT PRIMARY KEY,
  race_name VARCHAR(100) NOT NULL
);

CREATE TABLE dim_role_type (
  role_type_id INT PRIMARY KEY,
  role_name VARCHAR(100) NOT NULL
);