qrP6a1tb

1create schema sailors
2;
3
4SET search_path TO sailors
5;
6
7alter schema sailors owner to postgres
8;
9
10create table if not exists sailors
11(
12  sid integer not null
13  constraint sailors_pkey
14  primary key,
15  sname varchar(30),
16  rating integer,
17  age real
18)
19;
20
21Create INDEX idx_sailor_Btree_Age on sailors(age);
22Create INDEX idx_sailor_Btree_Sname on sailors(sname);
23Create Index idx_sailor_Btree_rating_age on sailors(rating,age);
24
25alter table sailors owner to postgres
26;
27
28create table if not exists boats
29(
30  bid integer not null
31  constraint boats_pkey
32  primary key,
33  bname varchar(30),
34  color varchar(20)
35)
36;
37
38Create INDEX idx_boats_hash_color on boats USING hash(color);
39
40alter table boats owner to postgres
41;
42
43create table if not exists reserves
44(
45  day date not null,
46  sid integer not null
47  constraint reserves_sailors_sid_fk
48  references sailors,
49  bid integer not null
50  constraint reserves_boats_bid_fk
51  references boats,
52  constraint reserves_pk
53  primary key (day, sid, bid)
54)
55;
56
57Create INDEX idx_boats_hash_sid on reserves USING hash(sid);
58Create INDEX idx_boats_hash_bid on reserves USING hash(bid);
59
60
61alter table reserves owner to postgres
62;