17 lines
408 B
SQL
17 lines
408 B
SQL
DROP TABLE employee;
|
|
CREATE TABLE employee (
|
|
fname varchar(15) not null,
|
|
minit varchar(1),
|
|
lname varchar(15) not null,
|
|
ssn char(9),
|
|
bdate date,
|
|
address varchar(50),
|
|
sex char,
|
|
salary decimal(10,2),
|
|
superssn char(9),
|
|
dno integer(4),
|
|
primary key (ssn),
|
|
foreign key (superssn) references employee(ssn),
|
|
foreign key (dno) references department(dnumber)
|
|
);
|