Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER USER v14dat101_034 SET SEARCH_PATH TO Stevne;
- CREATE TABLE Ovelse (
- navn varchar(15) not null PRIMARY KEY,
- disiplin varchar(15) not null,
- WR varchar (8) not null,
- TR varchar (8) not null
- );
- CREATE TABLE Utover (
- startnr INT not null PRIMARY KEY,
- navn varchar (15) not null,
- nasjonalitet varchar (15) not null
- );
- CREATE TABLE Deltakelse (
- ovelsenavn varchar (15) not null PRIMARY KEY,
- utover varchar (15) not null PRIMARY KEY,
- resultat varchar (8) not null,
- foreign key (utover) references Utover(startnr),
- foreign key (ovelsenavn) references Ovelse(navn)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement