📄 tables.ddl
字号:
drop table studentcmptable;
drop table lockercmptable;
drop table bookcmptable;
drop table teachercmptable;
drop table StudentTeacherJoin;
create table studentcmptable (
ssn integer primary key,
name varchar(255),
grade integer,
lockerkey integer
);
create table lockercmptable (
number integer primary key
);
create table bookcmptable (
isbn varchar(255),
copyNumber integer,
title varchar(255),
author varchar(255),
studentkey integer,
primary key (isbn, copyNumber)
);
create table teachercmptable (
ssn integer primary key,
name varchar(255)
);
create table StudentTeacherJoin (
teacher_ssn integer,
student_ssn integer
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -