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
| insert into YM_type_mesure
(YM_code, YM_libelle, YM_unite)
values ('POIDS', 'poids en kilogrammes', 'kg')
, ('TAILLE', 'taille en centimetres', 'cm')
, ('GLYCEM', 'glycemie en grammes par litre', 'g/l')
;
insert into PE_personne
(PE_nom, PE_prenom, PE_ddn)
values ('martin', 'pauline', '1978-07-15')
, ('abadie', 'remi', '1989-10-22')
, ('lesage', 'odile', '1992-02-07')
, ('dupont', 'yann', '1995-05-30')
;
insert into VI_visite
(PE_ident, VI_seq, VI_date)
values (1, 1, '2021-06-10')
, (2, 1, '2021-06-10')
, (1, 2, '2021-11-01')
, (3, 1, '2021-12-18')
;
insert into ME_mesure
(PE_ident, VI_seq, ME_seq, ME_val, YM_ident)
values (1, 1, 1, 55, 1)
, (1, 1, 2, 167, 2)
, (1, 1, 3, 0.82, 3)
, (2, 1, 1, 181, 2)
, (1, 2, 1, 56, 1)
, (1, 2, 2, 0.79, 3)
, (3, 1, 1, 163, 2)
, (3, 1, 2, 58, 1)
; |
Partager