Neo4J_Proj 3.8 KB
Newer Older
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
create (C1:Client {idClient:'1',nom:'HARLAN', prenom:'Wise',ddn:'1970-09-07',adresse:'Apdo.:630-5180 Fusce Avenida',numero:'0132102368'})
create (C2:Client {idClient:'2',nom:'LEE', prenom:'Munoz',ddn:'1985-01-31',adresse:'5900 Faucibus ',numero:'0721229832'})
create (C3:Client {idClient:'3',nom:'GISELA', prenom:'Zamora',ddn:'1984-06-18',adresse:'2165 Donec Avda.',numero:'0715456201'})
create (C4:Client {idClient:'4',nom:'XANTHA', prenom:'Sanchez',ddn:'1990-07-02',adresse:'7737 Urna, C.',numero:'0683588695'})


create (A1:Animal {idAnimal:'1',nom:'Nita', poids:'3069',taille:'62',naissance:'2018-07-26', especeNom:'lapin'})
create (A2:Animal {idAnimal:'2',nom:'Tanisha', poids:'4107',taille:'12',naissance:'2018-06-11', especeNom:'lapin'})
create (A3:Animal {idAnimal:'3',nom:'Ingrid', poids:'3349',taille:'92',naissance:'2014-10-05', especeNom:'chat'})
create (A4:Animal {idAnimal:'4',nom:'Xavier', poids:'1145',taille:'53',naissance:'2018-05-27', especeNom:'hamster'})
create (A5:Animal {idAnimal:'5',nom:'Melodie', poids:'420',taille:'93',naissance:'2016-10-10', especeNom:'tortue'})


create (V1:Veterinaire {idVeterinaire:'1',nom:'MURPHY', prenom:'Carl',ddn:'1976-05-27',adresse:'P.O. Box 458, 1143 Fringilla. Av.',numero:'0620025319'})
create (V2:Veterinaire {idVeterinaire:'2',nom:'ODETTE', prenom:'Jordan',ddn:'1970-09-21',adresse:'Ap #626-7909 Ut Street',numero:'0648524289'})
create (V3:Veterinaire {idVeterinaire:'3',nom:'TYRONE', prenom:'Tana',ddn:'1969-01-26',adresse:'946-1718 Natoque Street',numero:'0330903858'})


create (M1:Medicament {nomMolec:'LEVOTHYROX',description:'Soigne les maux de gorge'})
create (M2:Medicament {nomMolec:'DOLIPRANE',description:'Soulage les douleurs'})
create (M3:Medicament {nomMolec:'DAFALGAN',description:'Soulage la fièvre'})
create (M4:Medicament {nomMolec:'IXPRIM',description:'Aucun effet'})
create (M5:Medicament {nomMolec:'EFFERALGAN',description:'Créer des bulles'})
create (M6:Medicament {nomMolec:'IMODIUM',description:'Immunise le système'})
create (M7:Medicament {nomMolec:'SPASFON',description:'Contre les selles liquides'})
create (M8:Medicament {nomMolec:'FORLAX',description:'Pour relaxer'})




create(T1:Traitement {idTraitement:'1'})
create(T2:Traitement {idTraitement:'2'})
create(T3:Traitement {idTraitement:'3'})
create(T4:Traitement {idTraitement:'4'})
create(T5:Traitement {idTraitement:'5'})
create(T6:Traitement {idTraitement:'6'})



create (C1) - [:proprietaireDe] -> (A1)
create (C1) - [:proprietaireDe] -> (A2)
create (C2) - [:proprietaireDe] -> (A3)
create (C3) - [:proprietaireDe] -> (A4)
create (C4) - [:proprietaireDe] -> (A5)


47 48 49 50 51 52 53 54 55 56
create (M1) - [:appartientA {debut:'2017-02-10', duree:'4', nbParJour:'1'}] -> (T1)
create (M2) - [:appartientA {debut:'2017-02-10', duree:'2', nbParJour:'1'}] -> (T1)
create (M3) - [:appartientA {debut:'2017-10-01', duree:'5', nbParJour:'2'}] -> (T2)
create (M4) - [:appartientA {debut:'2018-01-05', duree:'2', nbParJour:'1'}] -> (T3)
create (M5) - [:appartientA {debut:'2018-03-01', duree:'3', nbParJour:'2'}] -> (T3)
create (M6) - [:appartientA {debut:'2018-04-15', duree:'6', nbParJour:'3'}] -> (T4)
create (M7) - [:appartientA {debut:'2018-04-01', duree:'5', nbParJour:'1'}] -> (T5)
create (M8) - [:appartientA {debut:'2018-04-01', duree:'3', nbParJour:'1'}] -> (T5)
create (M2) - [:appartientA {debut:'2018-04-17', duree:'5', nbParJour:'1'}] -> (T6)
create (M4) - [:appartientA {debut:'2018-04-17', duree:'5', nbParJour:'3'}] -> (T6)
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71


create (T1) - [:prescritPar] -> (V1)
create (T2) - [:prescritPar] -> (V2)
create (T3) - [:prescritPar] -> (V1)
create (T4) - [:prescritPar] -> (V3)
create (T5) - [:prescritPar] -> (V2)
create (T6) - [:prescritPar] -> (V1)


create (T1) - [:prescritA] -> (A1)
create (T2) - [:prescritA] -> (A2)
create (T3) - [:prescritA] -> (A3)
create (T4) - [:prescritA] -> (A4)
create (T5) - [:prescritA] -> (A1)
72
create (T6) - [:prescritA] -> (A5)