ATG

[vitimbei]

create table consulta ( cod_usuario int not null primary key, senha_usuario varchar (45) not null )

create table aluno ( matricula_aluno int not null primary key, nome_aluno varchar (45) not null, turma_aluno varchar (45) not null, cpf_aluno int null, ctt_responsavel varchar (45) null )

create table professor ( cod_prof int not null primary key, nome_prof varchar (45) not null, endereço_prof varchar (45) null, turno_prof varchar (45) not null, ctt_prof varchar(45) null

)

create table cadastro ( cod_atest int not null primary key, data_atest date not null, cid int not null, matricula_aluno int not null,
foreign key (matricula_aluno) references aluno (matricula_aluno) );

insert into aluno values (123, 'vitim', '1*2', null , null );

insert into cadastro values (123, '05-05-24', 013, 123 );

insert into professor values (321, 'Luana', null, 'noite', null );

[vitimbei]

select * from consulta insert into consulta values (12345678 , 'oi12');

select * from aluno insert into aluno values (12345678 , 'Vitor', '1A', null, null);

select * from professor insert into professor values (1234567 , 'Jack', 'Anaburgo', 'tarde', 'oi@gmail.com');

select * from cadastro insert into cadastro values (1 , '2023-05-24', 123, 12345678 );