create table ambulatorios (numero integer not null,
 andar integer,
 capacidade integer,
 constraint pk_numero primary key (numero)
);


create table medicos (codigo integer not null,
 nome varchar(50),
 idade integer,
 especialidade varchar(50),
 numeroAmbulatorio integer,
 constraint pk_codigoMedicos primary key (codigo),
 constraint fk_numeroAmbulatorio foreign key (numeroAmbulatorio) 
	references ambulatorios
);


create table pacientes (codigo integer not null,
 nome varchar(50),
 idade integer,
 problema varchar(50),
 constraint pk_codigoPacientes primary key (codigo)
);

create table consultas (
codigoMedico integer,
codigoPaciente integer,
dataHora datetime,

constraint pk_consultas primary key (codigoMedico, codigoPaciente ,dataHora),
constraint fk_medico foreign key (codigoMedico) references medicos,
constraint fk_paciente foreign key (codigoPaciente) references pacientes
);


insert into ambulatorios values (rand()*1000, 
		rand()*1000, 
		rand()*10+10);

insert into medicos values (rand()*100, 
		'joćo '+cast (cast((rand()*1000) as integer) as char), 
		rand()*60+20, 
		'especialidade ' +cast (cast((rand()*1000) as integer) as char),
		rand()*1000);

insert into pacientes values (rand()*10000, 
		'maria '+cast (cast((rand()*1000) as integer) as char), 
		rand()*60+20, 
		'problema ' +cast (cast((rand()*1000) as integer) as char));

insert into consultas values (rand()*100, rand()*10000, cast(cast((rand()*10+2000) as integer) as char) + '-' + cast(cast((rand()*10+4) as integer) as char) + '-' + cast(cast((rand()*10+20) as integer) as char) + ' ' + cast(cast((rand()*10) as integer) as char) + ':' + cast(cast((rand()*10) as integer) as char) + ':' + cast(cast((rand()*10) as integer) as char));