ecto_test_tables.sql

CREATE TABLE department
(
 department_id serial NOT NULL,
 name text NOT NULL,
 PRIMARY KEY (department_id)
);

CREATE TABLE employee
(
 employee_id serial NOT NULL,
 first_name text NOT NULL,
 last_name text NOT NULL,
 hire_date date NOT NULL,
 department_id integer NOT NULL,
 FOREIGN KEY (department_id) REFERENCES department (department_id) ON UPDATE NO ACTION ON DELETE NO ACTION,
 PRIMARY KEY (employee_id)
);