Script SQL Criacao de Tabelas Medico Paciente Consulta

create table medico codmedico integer not null nommedico varchar50 null tipmedico char1 not null constraint tipmedicoCons check tipmedico in PRC create table paciente codpac integer not null primary key nompac varchar50 null idade integer not null create table consulta codpac integer not null codmedico integer not null datConsulta date not null constraint pkconsulta primary key datconsulta insert into medico values 1 Carlos Alberto P insert into medico values 21 Marilia Pera C insert into paciente values 10 Francisco Antonio 25 insert into paciente values 12 Carlitos Francesco 35 insert into consulta values 10 1 10102018