1 Star 0 Fork 0

chuan / SQLcode

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Without author's permission, this code is only for learning and cannot be used for other purposes.
Clone or download
lis.sql 576 Bytes
Copy Edit Web IDE Raw Blame History
chuan authored 2020-10-03 14:56 . Initial commit
create table tb_emp
(
eno int not null comment '员工编号',
ename varchar(20) not null comment '姓名',
job varchar(20) not null comment '员工职位',
mgr int comment '主管编号', -- 自参照完整性. 主管和员工(一对多),同时主管也是员工
sal int not null comment '员工月薪',
comm int comment '每月补贴',
dno int comment '所在部门编号',
primary key (eno)
);
create table tb_dept
(
dno int not null comment '编号',
dname varchar(10) not null comment '名称',
dloc varchar(20) not null comment '所在地',
primary key (dno)
);

Comment ( 0 )

Sign in for post a comment

1
https://gitee.com/chuancode/SQLcode.git
git@gitee.com:chuancode/SQLcode.git
chuancode
SQLcode
SQLcode
master

Search