Yurttas/PL/DBL/postgres/F/01/Company-A/Employee-cre.sql

 1/*
 2REM
 3REM
 4REM Employee-cre.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companya";
11
12CREATE TABLE Employee(fname VARCHAR(12) NOT NULL,
13                      minit CHAR,
14                      lname VARCHAR(16) NOT NULL, 
15                      ssn CHAR(9) NOT NULL,
16                      bdate CHAR(9),
17                      address VARCHAR(24),
18                      sex CHAR,
19                      salary FLOAT,
20                      superssn CHAR(9),
21                      dno INTEGER NOT NULL,
22          PRIMARY KEY(ssn));