AQdFDqHW

1create table if not exists level(
2  aclevel varchar(5) not null,
3  dscr varchar(20) not null,
4  constraint pk_level primary key(aclevel)
5);
6create table if not exists sailor(
7  sid integer not null,
8  name varchar(30) not null,
9  email varchar(30) not null,
10  dbirth date not null,
11  level varchar(5) not null,
12  constraint pk_sailor primary key (sid),
13  constraint pk_sailor_level foreign key (level) references level(aclevel)
14);
15
16create table if not exists boattype(
17  id integer not null,
18  dscr varchar(30) not null, 
19  constraint pk_boattype primary key(id)
20);
21create table if not exists boat(
22  bid integer not null,name varchar(30) 
23  not null, len int not null, 
24  phorses float not null, 
25  color varchar(10) not null, 
26  btype integer not null,
27  wight float not null, 
28  constraint pk_boat primary key(bid),
29  constraint fk_boat_boattype 
30  foreign key(btype) references boattype(id)
31);
32
33create table if not exists reserve(
34  sid integer not null, 
35  bid integer not null, 
36  dhour date not null,
37  dhorret date,
38  constraint pk_reserve primary key(sid, bid, dhour),
39  constraint fk_reserve_sailor foreign key(sid) references sailor(sid),
40  constraint fk_reserve_boat foreign key(bid) references boat(bid)
41);