Implementar el esquema de base de datos de la clinica veterinaria ( incluir todas las tablas y datos de 5 pacientes con 2 registros de visita a la clinica cada uno).
CREATE DATABASE hist;
USE hist;
CREATE TABLE paciente(id_pte INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, id_caresp INT NOT NULL, id_prop INT NOT NULL, nompte
VARCHAR(20), esppte VARCHAR(20), rzpte VARCHAR(20), sxpte VARCHAR(5), pspte
DECIMAL, alzpte DECIMAL, fnpte DATE, INDEX(id_caresp), INDEX(id_prop));
CREATE TABLE Caracteristicas_especiales(id_caresp INT NOT
NULL PRIMARY KEY AUTO_INCREMENT, clpte VARCHAR(10), plpte VARCHAR(10), ccpte
VARCHAR(10), cepte VARCHAR(20), tjpte VARCHAR(10), cppte INT, fzpte
VARCHAR(20));
CREATE TABLE propietario(id_prop INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, id_pte INT NOT NULL, id_est INT NOT NULL, id_cd INT NOT NULL,
id_col INT NOT NULL, id_tel INT NOT NULL, nomprop VARCHAR(20), ap1_prop
VARCHAR(20), ap2_prop VARCHAR(20), dirprop VARCHAR(30), poprop VARCHAR(20));
CREATE TABLE estado(id_est INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, est VARCHAR(20));
CREATE TABLE ciudad(id_cd INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, cd VARCHAR(20));
CREATE TABLE colonia(id_col INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, col VARCHAR(20), cp INT);
CREATE TABLE telefono(id_tel INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, id_prop INT NOT NULL, telprop VARCHAR(10));
CREATE TABLE ambiente(id_amb INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, ent VARCHAR(30), nut VARCHAR(30), esvid VARCHAR(30));
CREATE TABLE constantes_fisicas(id_constfis INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, frecar VARCHAR(30), freres VARCHAR(30), pul
VARCHAR(30), temp DECIMAL);
CREATE TABLE consulta(folio INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, id_pte INT NOT NULL, id_amb INT NOT NULL, id_constfis INT NOT
NULL, id_lespri INT NOT NULL, id_lessec INT NOT NULL, id_linf INT NOT NULL,
id_sistesq INT NOT NULL, id_sistner INT NOT NULL, id_sistgen INT NOT NULL,
id_sisturi INT NOT NULL, id_sistres INT
NOT NULL, id_sistcard INT NOT NULL, id_sistdig INT NOT NULL, id_orgsen INT NOT
NULL);
CREATE TABLE lesiones_primarias(id_lespri INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, maclespri VARCHAR(10), paplespri VARCHAR(10),
puslespri VARCHAR(10), hablespri VARCHAR(10), veslespri VARCHAR(10), plalespri
VARCHAR(10), nodlespri VARCHAR(10), tumlespri VARCHAR(10), quilespri
VARCHAR(10));
CREATE TABLE lesiones_secundarias(id_lessec INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, comlessec VARCHAR(10), coeplessec VARCHAR(10),
esclessec VARCHAR(10), coslessec VARCHAR(10), exclessec VARCHAR(10), erlessec
VARCHAR(10), liqlessec VARCHAR(10), ullessec VARCHAR(10), hipelessec
VARCHAR(10), hipolessec VARCHAR(10), ciclessec VARCHAR(10));
CREATE TABLE linfodos(id_linf INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, manlin VARCHAR(10), esclin VARCHAR(10), inglin VARCHAR(10),
poplin VARCHAR(10));
CREATE TABLE patron_de_distribucion(id_patdis INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, vislatizq VARCHAR(10), vislatder VARCHAR(10),
visdor VARCHAR(10), visvent VARCHAR(10));
CREATE TABLE sistema_esqueletico(id_sistesq INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_insp INT NOT NULL, id_palp INT NOT NULL,
id_pruesp INT NOT NULL);
CREATE TABLE inspeccion(id_insp INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, postpte VARCHAR(10), valmar VARCHAR(10), valtro VARCHAR(10));
CREATE TABLE palpacion(id_palp INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, id_exttor INT NOT NULL, id_extpel INT NOT NULL);
CREATE TABLE extremidad_toraxica(id_exttor INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, reesc VARCHAR(10), coan VARCHAR(10), cade
VARCHAR(10));
CREATE TABLE extremidad_pelviana(id_extpel INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, pel VARCHAR(10), rod VARCHAR(10), corv
VARCHAR(10));
CREATE TABLE pruebas_especificas(id_pruesp INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, pruca VARCHAR(10), pruor VARCHAR(10), otras
VARCHAR(10));
CREATE TABLE sistema_nervioso(id_sistner INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_parcra INT NOT NULL, id_refpos INT NOT NULL,
id_estmen INT NOT NULL, id_refesp INT NOT NULL, id_reapos INT NOT NULL, id_otner
INT NOT NULL);
CREATE TABLE pares_craneales(id_parcra INT NOT NULL PRIMARY
KEY AUTO_INCREMENT, olf VARCHAR(10), opt VARCHAR(10), ocu VARCHAR(10), troc
VARCHAR(10), trig VARCHAR(10), abd VARCHAR(10), fac VARCHAR(10), vesloc
VARCHAR(10), glofar VARCHAR(10), vago VARCHAR(10), espac VARCHAR(10), hipgl
VARCHAR(10));
CREATE TABLE reflejos_postulares(id_refpos INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, carr VARCHAR(10), hemmar VARCHAR(10), hemmie
VARCHAR(10), salto VARCHAR(10), procon VARCHAR(10), proinc VARCHAR(10));
CREATE TABLE estado_mental(id_estmen INT NOT NULL PRIMARY
KEY AUTO_INCREMENT, dep VARCHAR(10), estu VARCHAR(10), coma VARCHAR(10));
CREATE TABLE reacciones_postulares(id_reapos INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, postv VARCHAR(10), reatc VARCHAR(10));
CREATE TABLE reflejos_espinales(id_refesp INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_miant INT NOT NULL, id_mipost INT NOT NULL);
CREATE TABLE miembro_anterior(id_miant INT NOT NULL PRIMARY
KEY AUTO_INCREMENT, bic VARCHAR(10), tric VARCHAR(10), flexa VARCHAR(10));
CREATE TABLE miembro_posterior(id_mipost INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, flexp VARCHAR(10), pat VARCHAR(10), tibcra
VARCHAR(10), gastr VARCHAR(10));
CREATE TABLE otrossistner(id_otner INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, reexcr VARCHAR(10), sensu VARCHAR(10), senpro VARCHAR(10),
refpa VARCHAR(10), refsac VARCHAR(10), cocc VARCHAR(10), siba VARCHAR(10),
refmic VARCHAR(10));
CREATE TABLE sistema_genital(id_sistgen INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_macho INT NOT NULL, id_hembra INT NOT NULL);
CREATE TABLE macho(id_macho INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, prep VARCHAR(10), escr VARCHAR(10), testi VARCHAR(10), pn
VARCHAR(10), prost VARCHAR(10));
CREATE TABLE hembra(id_hembra INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
vul VARCHAR(10), vag VARCHAR(10), ute VARCHAR(10), glanman VARCHAR(10));
CREATE TABLE sistema_urinario(id_sisturi INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, uret VARCHAR(10), vej VARCHAR(10), rnes
VARCHAR(10));
CREATE TABLE sistema_respiratorio(id_sistresp INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_viar INT NOT NULL, id_sonres INT NOT NULL,
id_patres INT NOT NULL, id_sinres INT NOT NULL);
CREATE TABLE vias_aereas(id_viar INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, trufa VARCHAR(10), cavnas VARCHAR(10), lari VARCHAR(10), traq
VARCHAR(10), pulm VARCHAR(10));
CREATE TABLE sonidos_respiratorios(id_sonres INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_norm INT NOT NULL, id_anorm INT NOT NULL);
CREATE TABLE normales(id_norm INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, bronq VARCHAR(10), vesi VARCHAR(10), bronvesi VARCHAR(10));
CREATE TABLE anormales(id_anorm INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, sonveiasu VARCHAR(10), sonvesidis VARCHAR(10), soppri
VARCHAR(10), estr VARCHAR(10), sopsec VARCHAR(10), crepest VARCHAR(10));
CREATE TABLE patrones_respiratorios(id_patres INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_restr INT NOT NULL, id_div INT NOT NULL, obstr
VARCHAR(10));
CREATE TABLE restrictivo(id_restr INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, pulmo VARCHAR(10), torx VARCHAR(10), abdo VARCHAR(10));
CREATE TABLE diverso(id_div INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, S1 VARCHAR(10), S2 VARCHAR(10));
CREATE TABLE sintomas_respiratorios(id_sinres INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, estor VARCHAR(10), tos VARCHAR(10), secnas
VARCHAR(10), tumfac VARCHAR(10), cambv VARCHAR(10), disins VARCHAR(10), disesp
VARCHAR(10), polp VARCHAR(10), taqp VARCHAR(10), hipn VARCHAR(10));
CREATE TABLE sistema_cardiovascular(id_sistcard INT NOT
NULL PRIMARY KEY AUTO_INCREMENT, id_memmuc INT NOT NULL, id_carpul INT NOT
NULL, id_regpre INT NOT NULL, id_ausc INT NOT NULL, id_otcard INT NOT NULL);
CREATE TABLE membranas_mucosas(id_memmuc INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, oral VARCHAR(10), coni VARCHAR(10), vagprep
VARCHAR(10));
CREATE TABLE caracteristicas_pulso(id_carpul INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, inten VARCHAR(10), frec VARCHAR(10), ritpul
VARCHAR(10), fem VARCHAR(10), yug VARCHAR(10));
CREATE TABLE region_precordial(id_regpre INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, chopre VARCHAR(10));
CREATE TABLE auscultacion(id_ausc INT NOT NULL PRIMARY KEY
AUTO_INCREMENT, pulmaus VARCHAR(10), aoraus VARCHAR(10), mitaus VARCHAR(10),
tricaus VARCHAR(10), S1 VARCHAR(10), S2 VARCHAR(10));
CREATE TABLE otrossistcard(id_otcard INT NOT NULL PRIMARY
KEY AUTO_INCREMENT, sopcard VARCHAR(10), arricard VARCHAR(10), tiemreca
VARCHAR(10), otros VARCHAR(10));
CREATE TABLE sistema_digestivo(id_sistdig INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, id_sigdig INT NOT NULL, boca VARCHAR(10), lendig
VARCHAR(10), diedi VARCHAR(10), fardi VARCHAR(10), esodi VARCHAR(10), estodi
VARCHAR(10), indel VARCHAR(10), ingru VARCHAR(10), recto VARCHAR(10), ano
VARCHAR(10), higdi VARCHAR(10));
CREATE TABLE signos_digestivos(id_sigdig INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, dolpalp VARCHAR(10), vomdig VARCHAR(10), regurdig
VARCHAR(10), diadig VARCHAR(10), deshidig VARCHAR(10), otros VARCHAR(10));
CREATE TABLE organos_sentidos(id_orgsen INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, visorg VARCHAR(10), parorg VARCHAR(10), connas
VARCHAR(10), esclorg VARCHAR(10), cororg VARCHAR(10), camant VARCHAR(10),
campost VARCHAR(10), iris VARCHAR(10), cristorg VARCHAR(10), segpost
VARCHAR(10), papop VARCHAR(10), retorg VARCHAR(10), oidos VARCHAR(10), condext
VARCHAR(10), condmed VARCHAR(10), condint VARCHAR(10), secorg VARCHAR(10),
refoto VARCHAR(10));
CREATE
TABLE ayuda_diagnostica(id_ayudiag INT NOT NULL PRIMARY KEY AUTO_INCREMENT, cuahem
VARCHAR(10), parori VARCHAR(10), copro VARCHAR(10), ecoayu VARCHAR(10), radiayu
VARCHAR(10), elcard VARCHAR(10), perbio VARCHAR(10), alt VARCHAR(10), ast
VARCHAR(10), bun VARCHAR(10), creayu VARCHAR(10), gluayu VARCHAR(10), biliayu
VARCHAR(10), tricho VARCHAR(10), lampwo VARCHAR(10));
ALTER TABLE paciente ADD FOREIGN KEY(id_caresp) REFERENCES Caracteristicas_especiales(id_caresp)
ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE paciente ADD FOREIGN KEY(id_prop) REFERENCES
propietario(id_prop) ON DELETE RESTRICT
ON UPDATE CASCADE;
ALTER TABLE
propietario ADD FOREIGN KEY(id_pte) REFERENCES paciente(id_pte) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE telefono ADD FOREIGN KEY(id_prop) REFERENCES
propietario(id_prop) ON DELETE RESTRICT
ON UPDATE CASCADE;
ALTER TABLE propietario ADD FOREIGN KEY(id_est) REFERENCES
estado(id_est) ON DELETE RESTRICT ON
UPDATE CASCADE;
ALTER TABLE propietario ADD FOREIGN KEY(id_cd) REFERENCES
ciudad(id_cd) ON DELETE RESTRICT ON
UPDATE CASCADE;
ALTER TABLE propietario ADD FOREIGN KEY(id_tel) REFERENCES
telefono(id_tel) ON DELETE RESTRICT ON
UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_amb) REFERENCES
ambiente (id_amb) ON DELETE RESTRICT ON
UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_constfis)
REFERENCES constantes_fisicas (id_constfis) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_lespri) REFERENCES
lesiones_primarias(id_lespri) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_lessec) REFERENCES
lesiones_secundarias(id_lessec) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_linf) REFERENCES
linfodos(id_linf) ON DELETE RESTRICT ON
UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistesq) REFERENCES
sistema_esqueletico(id_sistesq) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistner) REFERENCES
sistema_nervioso(id_sistner) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistgen) REFERENCES
sistema_genital(id_sistgen) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sisturi) REFERENCES
sistema_urinario(id_sisturi) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistres) REFERENCES
sistema_respiratorio(id_sistres) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistcard)
REFERENCES sistema_cardiovascular(id_sistcard) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_sistdig) REFERENCES
sistema_digestivo(id_sistdig) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE consulta ADD FOREIGN KEY(id_orgsen) REFERENCES
organos_sentidos(id_orgsen) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_esqueletico ADD FOREIGN KEY(id_pruesp)
REFERENCES pruebas_especificas(id_pruesp) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE palpacion ADD FOREIGN KEY(id_exttor) REFERENCES
extremidad_toraxica(id_exttor) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE palpacion ADD FOREIGN KEY(id_extpel) REFERENCES
extremidad_pelviana(id_extpel) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_esqueletico ADD FOREIGN KEY(id_insp)
REFERENCES inspeccion(id_insp) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_esqueletico ADD FOREIGN KEY(id_palp)
REFERENCES palpacion(id_palp) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_parcra)
REFERENCES pares_craneales(id_parcra) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_refpos)
REFERENCES reflejos_postulares(id_refpos) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_estmen)
REFERENCES estado_mental(id_estmen) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_reapos)
REFERENCES reacciones_postulares(id_reapos) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE reflejos_espinales ADD FOREIGN KEY(id_miant)
REFERENCES miembro_anterior(id_miant) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE reflejos_espinales ADD FOREIGN KEY(id_mipost)
REFERENCES miembro_posterior(id_mipost) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_refesp)
REFERENCES reflejos_espinales(id_refesp) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_nervioso ADD FOREIGN KEY(id_otner)
REFERENCES otrossistner(id_otner) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_genital ADD FOREIGN KEY(id_macho)
REFERENCES macho(id_macho) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_genital ADD FOREIGN KEY(id_hembra)
REFERENCES hembra(id_hembra) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sonidos_respiratorios ADD FOREIGN KEY(id_norm)
REFERENCES normales(id_norm) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sonidos_respiratorios ADD FOREIGN KEY(id_anorm)
REFERENCES anormales(id_anorm) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE patrones_respiratorios ADD FOREIGN
KEY(id_restr) REFERENCES restrictivo (id_restr) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE patrones_respiratorios ADD FOREIGN KEY(id_div)
REFERENCES diverso (id_div) ON DELETE
RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_respiratorio ADD FOREIGN KEY(id_viar)
REFERENCES vias_aereas (id_viar) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER
TABLE sistema_respiratorio ADD FOREIGN KEY(id_sonres) REFERENCES sonidos_respiratorios
(id_sonres) ON DELETE RESTRICT ON UPDATE
CASCADE;
ALTER TABLE sistema_respiratorio ADD FOREIGN KEY(id_patres)
REFERENCES patrones_respiratorios (id_patres) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_respiratorio ADD FOREIGN KEY(id_sinres)
REFERENCES sintomas_respiratorios (id_sinres) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_cardiovascular ADD FOREIGN
KEY(id_memmuc) REFERENCES membranas_mucosas (id_memmuc) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_cardiovascular ADD FOREIGN
KEY(id_carpul) REFERENCES caracteristicas_pulso (id_carpul) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_cardiovascular ADD FOREIGN
KEY(id_regpre) REFERENCES region_precordial (id_regpre) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_cardiovascular ADD FOREIGN KEY(id_ausc)
REFERENCES auscultacion (id_ausc) ON
DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_cardiovascular ADD FOREIGN
KEY(id_otcard) REFERENCES otrossistcard (id_otcard) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE sistema_digestivo ADD FOREIGN KEY(id_sigdig)
REFERENCES signos_digestivos (id_sigdig) ON
DELETE RESTRICT ON UPDATE CASCADE;
INSERT INTO paciente VALUES(NULL, 1, 1,
"Firulais", "Canina", "Dalmata",
"Macho", 40.5, 1.5, '2012-05-10');
INSERT INTO paciente VALUES(NULL, 2, 2, "Bruno",
"Canina", "Pitbull", "Macho", 60.2, 1.1,
'2011-08-20');
INSERT INTO paciente VALUES(NULL, 3, 3, "Pelusa",
"Felina", "Bengali", "Hembra", 22.8, 0.7,
'2011-11-03');
INSERT INTO paciente VALUES(NULL, 4, 4, "Hachiko",
"Canina", "Husky", "Macho", 45.0, 1.4, '2012-04-11');
INSERT INTO paciente VALUES(NULL, 5, 5, "Jack",
"Canina", "Terrier", "Macho", 50.0, 1.0, '2012-08-15');
INSERT INTO propietario VALUES(NULL, 1, 1, 1, 2, 1,
"Jose", "Linares", "Bueno", "Pinotepa,
#2422", "Ing. Industrial");
INSERT
INTO propietario VALUES(NULL, 2, 3, 4, 1, 3, "Ernesto",
"Torres", "Ramirez", "Allende, #1548", "Lic.
Administracion");
INSERT
INTO propietario VALUES(NULL, 3, 1, 3, 5, 7, "Diana",
"Flores", "Campa", "Omitlan, #2674",
"Contador publico");
INSERT INTO consulta VALUES(NULL, 1, 1, 1, 2, 2, 1, 1, 1,
3, 3, 4, 4, 5, 1);
INSERT INTO consulta VALUES(NULL, 1, 2, 1, 4, 2, 3, 1, 1,
3, 3, 4, 4, 1, 1);
INSERT INTO consulta VALUES(NULL, 2, 1, 1, 2, 2, 1, 4, 1,
3, 1, 5, 3, 5, 1);
INSERT INTO consulta VALUES(NULL, 2, 1, 1, 2, 3, 1, 3, 1,
3, 3, 1, 4, 5, 2);
INSERT INTO consulta VALUES(NULL, 3, 2, 1, 2, 4, 1, 1, 4,
3, 3, 1, 4, 2, 1);
INSERT INTO consulta VALUES(NULL, 3, 1, 1, 2, 2, 1, 4, 1,
3, 3, 2, 4, 5, 1);
INSERT INTO consulta VALUES(NULL, 4, 1, 1, 2, 2, 5, 1, 1, 1,
3, 4, 4, 5, 1);
INSERT INTO consulta VALUES(NULL, 4, 3, 1, 2, 4, 1, 1, 1, 4,
3, 4, 4, 5, 1);
INSERT INTO consulta VALUES(NULL, 5, 1, 1, 2, 2, 1, 4, 1, 2,
3, 4, 4, 5, 1);
INSERT INTO consulta VALUES(NULL, 5, 5, 1, 2, 2, 5, 1, 1,
3, 3, 5, 4, 5, 1);
No hay comentarios:
Publicar un comentario