INSERT INTO MEDEC (NOMMEDEC, PRENOMMEDEC, TELMEDEC, EMAILMEDEC) VALUES
('Dupont', 'Jean', '0601010101', '[email protected]'),
('Martin', 'Claire', '0602020202', '[email protected]'),
('Durand', 'Paul', '0603030303', '[email protected]'),
('Moreau', 'Julie', '0604040404', '[email protected]'),
('Lefevre', 'Luc', '0605050505', '[email protected]'),
('Garcia', 'Anna', '0606060606', '[email protected]'),
('Roux', 'Hugo', '0607070707', '[email protected]'),
('Fournier', 'Emma', '0608080808', '[email protected]'),
('Girard', 'Louis', '0609090909', '[email protected]'),
('Andre', 'Chloe', '0610101010', '[email protected]'),
('Mercier', 'Nina', '0611111111', '[email protected]'),
('Blanc', 'Léo', '0612121212', '[email protected]'),
('Guerin', 'Sarah', '0613131313', '[email protected]'),
('Faure', 'Noah', '0614141414', '[email protected]');
INSERT INTO INFIRM (NOMINFIRM, PRENOMINFIRM, TELINFIRM, EMAILINFIRM) VALUES
('Bernard', 'Camille', '0615151515', '[email protected]'),
('Robert', 'Mathieu', '0616161616', '[email protected]'),
('Petit', 'Laura', '0617171717', '[email protected]'),
('Richard', 'Alexis', '0618181818', '[email protected]'),
('Dubois', 'Eva', '0619191919', '[email protected]'),
('Fontaine', 'Lucas', '0620202020', '[email protected]'),
('Muller', 'Sophie', '0621212121', '[email protected]'),
('Henry', 'Thomas', '0622222222', '[email protected]'),
('Renaud', 'Manon', '0623232323', '[email protected]'),
('Masson', 'Nathan', '0624242424', '[email protected]'),
('Leclerc', 'Alice', '0625252525', '
[email protected]'),
('Robin', 'Julien', '0626262626', '[email protected]'),
('Gauthier', 'Lina', '0627272727', '[email protected]'),
('Marchand', 'Enzo', '0628282828', '[email protected]');
INSERT INTO PATIENT (IDINFIRM, NOMPATIENT, PRENOMPATIENT, EMAILPATIENT, TELPATIENT)
VALUES
(1, 'Lemoine', 'Clara', '[email protected]', '0701010101'),
(2, 'Barbier', 'Hugo', '[email protected]', '0702020202'),
(3, 'Pires', 'Maya', '[email protected]', '0703030303'),
(4, 'Lopez', 'Liam', '[email protected]', '0704040404'),
(5, 'Delorme', 'Jade', '[email protected]', '0705050505'),
(6, 'Navarro', 'Noé', '[email protected]', '0706060606'),
(7, 'Lemoine', 'Sasha', '[email protected]', '0707070707'),
(8, 'Caron', 'Iris', '[email protected]', '0708080808'),
(9, 'Charpentier', 'Aaron', '[email protected]', '0709090909'),
(10, 'Bouchet', 'Emma', '[email protected]', '0710101010'),
(11, 'Bouvier', 'Léna', '[email protected]', '0711111111'),
(12, 'Renault', 'Nolan', '[email protected]', '0712121212'),
(13, 'Gaillard', 'Zoé', '[email protected]', '0713131313'),
(14, 'Millet', 'Axel', '[email protected]', '0714141414');
INSERT INTO SALLE (CAPACITER, SOINS) VALUES
(2, 'Soins intensifs pour patients critiques'),
(4, 'Chirurgie générale'),
(6, 'Pédiatrie'),
(3, 'Oncologie'),
(5, 'Orthopédie et rééducation'),
(2, 'Psychiatrie'),
(4, 'Médecine générale'),
(3, 'Urgences'),
(6, 'Gynécologie et maternité'),
(2, 'Dermatologie');
