19.06.2012 - SQL

create table usuarios (
id int not null primary key,
nome varchar(20) not null unique,
senha varchar(20) not null,
cpf varchar(11) not null unique
);

create table concursos (
id int not null primary key,
nr int not null unique,
data date not null unique,
n1 int,
n2 int,
n3 int,
n4 int,
n5 int
);

create table apostas (
id int not null primary key,
id_usuario int not null references usuarios(id),
id_concurso int not null references concursos(id), 
n1 int not null,
n2 int not null,
n3 int not null,
n4 int not null,
n5 int not null,
n6 int,
n7 int
);