1.一对多的数据库操作(Department Employee)
create table department
(
id varchar(40) primary key,
name varchar(40)
);
create table employee
(
id varchar(40) primary key,
name varchar(40),
salary double,
department_id varchar(40),
constraint department_id_FK foreign key(department_id) references department(id)
);
2. 多对多的数据库表操作
create table teacher
(
id varchar(40) primary key,
name varchar(40),
salary double
);
create table student
(
id varchar(40) primary key,
name varchar(40)
);
create table teacher_student
(
teacher_id varchar(40),
student_id varchar(40),
primary key(teacher_id,student_id),
constraint teacher_id_FK foreign key(teacher_id) references teacher(id),
constraint student_id_FK foreign key(student_id) references student(id)
);
3.一对一 (人和身份证)
create table person
(
id varchar(40) primary key,
name varchar(40)
);
create table idcard
(
id varchar(40) primary key,
address varchar(100),
constraint id_FK foreign key(id) references person(id)
);
1对1,1对多,多对多.
最新推荐文章于 2022-10-24 17:12:38 发布