create table sailors (
    sid int primary key,
    sname text,
    rating int,
    age float
);

create table boats (
    bid int primary key,
    bname text,
    color text
);

create table reserves (
    sid int references sailors,
    bid int references boats,
    day text -- date of the reservation
    unique(sid, bid, day)
);

copy sailors from stdin;
22	Dustin	7	45.0
29	Brutus	1	33.0
31	Lubber	8	55.5
32	Andy	8	25.5
58	Rusty	10	35.0
64	Horatio	7	35.0
71	Zorba	10	16.0
74	Horatio	9	35.0
85	Art	3	25.5
95	Bob	3	63.5
\.

copy boats from stdin;
101	Interlake	blue
102	Interlake	red
103	Clipper	green
104	Marine	red
\.

copy reserves from stdin;
22	101	10/10/98
22	102	10/10/98
22	103	10/8/98
22	104	10/7/98
31	102	11/10/98
31	103	11/6/98
31	104	11/12/98
64	101	9/5/98
64	102	9/8/98
74	103	9/8/98
\.

