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 47 48
|
insert into SA_salon
(SA_enseigne, SA_SIREN, SA_NIC)
values ('on rase gratis ', '123456789', '00001')
, ('la boule à zéro', '987654321', '00001')
, ('partis tifs ', '999999999', '00002')
;
insert into PR_prestation
(PR_code, PR_libelle, PR_tarif)
values ('C001', 'coupe aux ciseaux', 12.50)
, ('C002', 'coupe tondeuse ', 11.00)
, ('P001', 'permanente std ', 38.20)
, ('SH00', 'shampoing std ', 04.00)
, ('SH01', 'shampoing spécial', 05.00)
;
insert into CL_client (CL_nom, CL_prenom, CL_ddn)
values ('Martin', 'Hélène', '2005-04-20')
, ('Dupuis', 'Benoit', '1984-12-21')
, ('Lesage', 'Mireille', '1982-07-16')
;
insert into RV_rendez_vous (SA_ident, RV_dtenr, RV_dtprest, CL_ident)
values (1, '2021-02-16', '2021-03-09', 3)
, (1, '2021-02-17', '2021-03-14', 1)
, (2, '2021-02-17', '2021-03-23', 2)
, (3, '2021-02-11', '2021-02-27', 1)
;
insert into SR_proposer(SA_ident, PR_ident)
values (1, 1)
, (1, 2)
, (1, 3)
, (1, 4)
, (1, 5)
, (2, 1)
, (2, 2)
, (2, 4)
, (2, 5)
, (3, 3)
, (3, 4)
, (3, 5)
;
insert into RP_concerner (PR_ident, SA_ident, RV_ident)
values (1, 1, 1)
, (5, 1, 1)
, (4, 1, 2)
, (3, 1, 2)
, (2, 2, 3)
-- , (3, 2, 4) -- KO : CIF d'inclusion
; |
Partager