Hello,
Here is a sample insertion of relevant tables by my request.
--insert table article
INSERT INTO [HEALTHBOARD].[dbo].[ARTICLE]
([CODART]
,[CODFAMART]
,[DESIGART]
,[PUBRUTART]
,[PVPUBLIC]
,[SEUILMINI])
VALUES
('M0001',1,'Amoxiciline ubi 250mg pdre susp F/60ml',93500,100000,10)
GO
INSERT INTO [HEALTHBOARD].[dbo].[ARTICLE]
([CODART]
,[CODFAMART]
,[DESIGART]
,[PUBRUTART]
,[PVPUBLIC]
,[SEUILMINI])
VALUES
('M0002',1,'Amoxico 500mg gel b/100',6025,7025,20)
GO
-- insert table destination
INSERT INTO [HEALTHBOARD].[dbo].[DESTINATION]
([CODDEST]
,[LIBDEST])
VALUES
('BPH1','Bon de pharmacie1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[DESTINATION]
([CODDEST]
,[LIBDEST])
VALUES
('BPH2','Bon de pharmacie2')
GO
INSERT INTO [HEALTHBOARD].[dbo].[DESTINATION]
([CODDEST]
,[LIBDEST])
VALUES
('Phcie1','Pharmacie interne F1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[DESTINATION]
([CODDEST]
,[LIBDEST])
VALUES
('Phcie2','Pharmacie interne F2')
GO
--insert table site
INSERT INTO [HEALTHBOARD].[dbo].[SITE]
([CODSITE]
,[LIBSITE])
VALUES
('PharmaF1','Pharmacie1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[SITE]
([CODSITE]
,[LIBSITE])
VALUES
('PharmaF2','Pharmacie2')
go
--insert table sous_site
INSERT INTO [HEALTHBOARD].[dbo].[SOUS_SITE]
([CODSOUSIT]
,[CODSITE]
,[LIBSOUSIT])
VALUES
('DISP1','PharmaF1','Dispensaire1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[SOUS_SITE]
([CODSOUSIT]
,[CODSITE]
,[LIBSOUSIT])
VALUES
('DISP2','PharmaF2','Dispensaire2')
go
--insert table type_mouvement
INSERT INTO [HEALTHBOARD].[dbo].[TYPE_MOUVEMENT]
([LIBTYPMVT])
VALUES
('Sortie gratuite1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[TYPE_MOUVEMENT]
([LIBTYPMVT])
VALUES
('Sortie gratuite2')
GO
INSERT INTO [HEALTHBOARD].[dbo].[TYPE_MOUVEMENT]
([LIBTYPMVT])
VALUES
('Entrée pharmacie F1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[TYPE_MOUVEMENT]
([LIBTYPMVT])
VALUES
('Entrée pharmacie F2')
GO
--insert table employer
INSERT INTO [HEALTHBOARD].[dbo].[EMPLOYER]
([MATEMP]
,[NOMEMP]
,[PRENEMP]
,[SEXEMP]
,[DATNAISSEMP]
,[LIEUNAISSEMP]
,[TELEMP]
,[PROFIL]
,[MDP]
,[CODSITE])
VALUES
(171819,'YAO','kan','M','13/06/1984','ferké','01-20-96-63','gestionnaire','cogito23','PharmaF1')
GO
INSERT INTO [HEALTHBOARD].[dbo].[EMPLOYER]
([MATEMP]
,[NOMEMP]
,[PRENEMP]
,[SEXEMP]
,[DATNAISSEMP]
,[LIEUNAISSEMP]
,[TELEMP]
,[PROFIL]
,[MDP]
,[CODSITE])
VALUES
(4021,'HUNT','kim','F','20/10/1980','bouaké','03-25-89-21','gestionnaire','lynx_123p','PharmaF2')
GO
--insert table mouvement
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP1','Phcie1',171819,3,'28/01/2015')
GO
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP1','Phcie1',171819,3,'29/01/2015')
GO
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP1','Phcie1',171819,3,'30/01/2015')
GO
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP2','Phcie2',4021,4,'28/01/2015')
GO
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP2','Phcie2',4021,4,'29/01/2015')
GO
INSERT INTO [HEALTHBOARD].[dbo].[MOUVEMENT]
([CODSOUSIT]
,[CODDEST]
,[MATEMP]
,[CODTYPMVT]
,[DATMVT]
,[CODCONSULT])
VALUES
('DISP2','Phcie2',4021,4,'30/01/2015')
GO
--insert table faire
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0001',1,120,'12/02/2012','12/02/2008',101023)
GO
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0001',2,80,'06/12/2014','06/12/209',119620)
GO
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0001',3,400,'17/08/2015','17/08/2010',124560)
GO
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0002',4,120,'25/04/2017','25/04/2010',203645)
GO
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0002',5,80,'18/12/2020','18/12/2010',308912)
GO
INSERT INTO [HEALTHBOARD].[dbo].[FAIRE]
([CODART]
,[CODMVT]
,[QTEMVT]
,[DATPEREMP]
,[DATFABRIC]
,[NUMLOT])
VALUES
('M0002',6,400,'03/07/2022','03/07/2011',970562)
GO