oracle salary,oracle 创建employees department salary表

create table employees(

employeeid varchar2(6) not null,

name varchar2(10) not null,

birthday date not null,

sex varchar2(2) not null,

address varchar2(20),

zip varchar2(6),

phone varchar2(12),

email varchar2(30),

departmentid varchar(3),

constraint employees_pk primary key(employeeid)

);

create table salary(

employeeid varchar2(6) not null,

income number(8,2) not null,

outcome number(8,2) not null,

constraint salary_pk primary key(employeeid)

);

create table department(

departmentid varchar2(3) not null,

depname varchar2(20) not null,

note varchar2(16),

constraint department_pk primary key(departmentid)

);