create.sql

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

-- create tables for CMP roster application

drop table league;
drop table player;
drop table team;
drop table team_player;

commit;

create table league (
	id VARCHAR(8) CONSTRAINT pk_league PRIMARY KEY,
	name VARCHAR(24),
	sport VARCHAR(24));

commit;
	
create table player (
	id VARCHAR(8) CONSTRAINT pk_player PRIMARY KEY,
	name VARCHAR(24),
	position VARCHAR(24),
	salary VARCHAR(24));

commit;
	
create table team (
	id VARCHAR(8) CONSTRAINT pk_team PRIMARY KEY,
	name VARCHAR(24),
	city VARCHAR(24),
	league_id VARCHAR(8),
	CONSTRAINT fk_league_id FOREIGN KEY (league_id) REFERENCES league(id));

commit;
	
create table team_player (
	player_id VARCHAR(8),
	team_id VARCHAR(8),
	CONSTRAINT fk_player_id FOREIGN KEY (player_id) REFERENCES player(id),
	CONSTRAINT fk_team_id FOREIGN KEY (team_id) REFERENCES team(id));

commit;
	
exit;