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
| USE [IC_LOUTY]
GO
/****** Object: Table [dbo].[Activite] Script Date: 01/10/2013 10:50:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Activite](
[act_KeyStr] [char](10) NOT NULL,
[act_Analytique] [varchar](8) NOT NULL,
[act_NomCommercial] [varchar](30) NULL,
[act_SiteInternet] [varchar](30) NULL,
[act_NomComptable] [varchar](40) NOT NULL,
[act_DetailActivite] [varchar](500) NULL,
[act_DateDebut] [date] NULL,
[act_DateFin] [date] NULL,
[act_ModifieLe] [datetime] NULL,
[act_ModifiePar] [varchar](30) NULL,
[act_CreePar] [varchar](30) NULL,
[act_CreeLe] [datetime] NULL,
[act_Publiable] [char](10) NULL,
[act_Memo] [varchar](1000) NULL,
[act_ChiffreAffPrevAn] [numeric](16, 2) NULL,
[act_TextPresentation] [varchar](500) NULL,
[act_LienLogo] [varchar](50) NULL,
CONSTRAINT [PK_Activite] PRIMARY KEY CLUSTERED
(
[act_KeyStr] ASC,
[act_Analytique] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Activite] WITH CHECK ADD CONSTRAINT [FK_Activite_Structure] FOREIGN KEY([act_KeyStr])
REFERENCES [dbo].[Structure] ([str_Key])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Activite] CHECK CONSTRAINT [FK_Activite_Structure]
GO |
Partager