create.sql

来自「《j2ee经典实例详解》的源代码。原书无附带光盘。介绍的是一个在线银行系统的例子」· SQL 代码 · 共 35 行

drop table customer;
drop table salesrep;

create table salesrep
(salesrepid varchar(3) constraint pk_salesrep primary key,
name varchar(24));

insert into salesrep
values ('876', 'Clyde Webster');
insert into salesrep
values ('543', 'Janice Martin');
insert into salesrep
values ('777', 'John Johnston');

create table customer 
(customerid varchar(3) constraint pk_customer primary key,  
salesrepid varchar(3),
name varchar(24),
constraint fk_salesrepid
foreign key (salesrepid)
references salesrep(salesrepid));

insert into customer
values ('123', '876', 'Sal Jones');
insert into customer
values ('987', '777', 'Mary Jackson');
insert into customer
values ('221', '543', 'Alice Smith');
insert into customer
values ('388', '543', 'Bill Williamson');
insert into customer
values ('456', '543', 'Joe Smith');

exit;