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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
|
/****** Object: Table [dbo].[Mouvement] Script Date: 07/09/2016 16:06:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Mouvement](
[IDMouvement] [int] NOT NULL,
[TypeMouvement] [tinyint] NOT NULL,
[Libelle] [varchar](255) NOT NULL,
[DateDepart] [char](8) NOT NULL,
[DateRetour] [char](8) NOT NULL,
[Remarque] [varchar](max) NOT NULL,
[IDPatient] [int] NOT NULL,
[CreePar] [int] NOT NULL,
[DateCreation] [char](17) NOT NULL,
[ModifiePar] [int] NULL,
[DateModification] [char](17) NOT NULL,
CONSTRAINT [PK_IDMouvement] PRIMARY KEY CLUSTERED
(
[IDMouvement] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Mouvement] ADD CONSTRAINT [DF_Mouvement_DateRetour] DEFAULT ('') FOR [DateRetour]
GO
ALTER TABLE [dbo].[Mouvement] ADD CONSTRAINT [DF_Mouvement_Remarque] DEFAULT ('') FOR [Remarque]
GO
ALTER TABLE [dbo].[Mouvement] ADD CONSTRAINT [DF_Mouvement_DateModification] DEFAULT ('') FOR [DateModification]
GO
ALTER TABLE [dbo].[Mouvement] WITH CHECK ADD CONSTRAINT [FK_Mouvement/Patient] FOREIGN KEY([IDPatient])
REFERENCES [dbo].[Patient] ([IDPatient])
GO
ALTER TABLE [dbo].[Mouvement] CHECK CONSTRAINT [FK_Mouvement/Patient]
GO
ALTER TABLE [dbo].[Mouvement] WITH CHECK ADD CONSTRAINT [FK_Mouvement/Utilisateur_CreePar] FOREIGN KEY([CreePar])
REFERENCES [dbo].[Utilisateur] ([IDUtilisateur])
GO
ALTER TABLE [dbo].[Mouvement] CHECK CONSTRAINT [FK_Mouvement/Utilisateur_CreePar]
GO
ALTER TABLE [dbo].[Mouvement] WITH CHECK ADD CONSTRAINT [FK_Mouvement/Utilisateur_ModifiePar] FOREIGN KEY([ModifiePar])
REFERENCES [dbo].[Utilisateur] ([IDUtilisateur])
GO
ALTER TABLE [dbo].[Mouvement] CHECK CONSTRAINT [FK_Mouvement/Utilisateur_ModifiePar]
GO |
Partager