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