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
| USE [SUIVICONTRATS-AO-01]
GO
/****** Objet*: Table [dbo].[Mytable] Date de génération du script*: 03/20/2008 09:52:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MISSION](
[ID_Mytable] [int] IDENTITY(1,1) NOT NULL,
[ID_FOU] [int] NOT NULL,
[ID_DEM] [int] NOT NULL,
[ID_PRO] [int] NOT NULL,
[NUMEROSA] [varchar](10) COLLATE Latin1_General_CI_AS NULL,
[NOM_INTER] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
[PRENOM_INTER] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
[DATE_ASSIG] [datetime] NULL,
[DATE_DEB] [datetime] NULL,
[DATE_FIN] [datetime] NULL,
[CODE_DEP] [varchar](4) COLLATE Latin1_General_CI_AS NULL,
[LIBELLE_DEP] [varchar](40) COLLATE Latin1_General_CI_AS NULL,
[DATE_DEP] [datetime] NULL,
CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED
(
[ID_MyTable] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 70) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [FK_MyTable_DEM_GLO] FOREIGN KEY([ID_DEM])
REFERENCES [dbo].[DEM_GLO] ([ID_DEM])
GO
ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_DEM_GLO]
GO
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [FK_MyTable_FOUR] FOREIGN KEY([ID_FOUR])
REFERENCES [dbo].[FOUR] ([ID_FOUR])
GO
ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MISSION_FOUR]
GO
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [FK_MISSION_PRO_TY] FOREIGN KEY([ID_PRO])
REFERENCES [dbo].[PROFIL_TYPE] ([ID_PRO_TY])
GO
ALTER TABLE [dbo].[MyTable] CHECK CONSTRAINT [FK_MyTable_PRO_TY] |
Partager