schema-export.sql
来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· SQL 代码 · 共 34 行
SQL
34 行
alter table certificate drop foreign key FK745F419798ABF971;alter table student drop foreign key FK8FFE823B24EDBC5F;drop table if exists certificate;drop table if exists student;drop table if exists team;create table certificate ( id varchar(255) not null, `describe` varchar(100), primary key (id));create table student ( id varchar(255) not null, age integer, name varchar(20), cardId varchar(30), team_id varchar(255), primary key (id));create table team ( id varchar(255) not null, teamName varchar(20), primary key (id));alter table certificate add index FK745F419798ABF971 (id), add constraint FK745F419798ABF971 foreign key (id) references student (id);alter table student add index FK8FFE823B24EDBC5F (team_id), add constraint FK8FFE823B24EDBC5F foreign key (team_id) references team (id);
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?