1 -- A user may or may not play games
3 id integer primary key,
4 name varchar(32) unique not null
8 id integer primary key,
12 -- A player (ref. uid) is involved into a game (ref. gid)
16 points
integer not null default 0,
17 foreign key(uid
) references Users(id),
18 foreign key(gid
) references Games(id)
24 choice
character(1) not null, --'r', 'p', 's', 'l' or 'k'
25 mnum
integer not null,
26 foreign key(uid
) references Users(id),
27 foreign key(gid
) references Games(id)