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 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
|
USE [riodata]
GO
/****** Objet*: Table [dbo].[Commande] Date de génération du script*: 03/31/2009 14:24:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Commande](
[CptCde] [int] IDENTITY(1,1) NOT NULL,
[N°Cde] [nvarchar](15) COLLATE French_CI_AS NULL,
[Réf] [nvarchar](20) COLLATE French_CI_AS NULL,
[DT] [datetime] NULL,
[CodeFourn] [int] NULL,
[Edité] [bit] NULL DEFAULT ((0)),
[Soldé] [bit] NULL DEFAULT ((0)),
[ArticleReçu] [bit] NULL DEFAULT ((0)),
[BasCde] [nvarchar](max) COLLATE French_CI_AS NULL,
[Remarque] [nvarchar](max) COLLATE French_CI_AS NULL,
[Signataire] [nvarchar](20) COLLATE French_CI_AS NULL,
[Emetteur] [nvarchar](50) COLLATE French_CI_AS NULL,
[ValeurLivrée] [money] NULL,
[DateRelance] [datetime] NULL,
[CodeImputation] [int] NULL,
[NivAffec] [int] NULL,
[TypeImputation] [tinyint] NULL,
[AdresseLivraison] [int] NULL,
[AdresseFacturation] [int] NULL,
[CptSiteStockage] [int] NULL,
[LibelModLiv] [nvarchar](60) COLLATE French_CI_AS NULL,
[LibCondPaiement] [nvarchar](60) COLLATE French_CI_AS NULL,
[Franco] [nvarchar](60) COLLATE French_CI_AS NULL,
[RéceptionTotale] [bit] NULL DEFAULT ((0)),
[CodeFamilleImputation] [int] NULL,
[Validée] [bit] NULL DEFAULT ((0)),
[Màj] [bit] NULL DEFAULT ((0)),
[CptDeviseFourn] [int] NULL,
[Facturé] [bit] NULL DEFAULT ((0)),
[ImputBon] [int] NULL,
[ValTVA] [float] NULL DEFAULT ((0)),
[CptImputation1] [int] NULL DEFAULT ((0)),
[CptImputation2] [int] NULL DEFAULT ((0)),
[FlagR] [nvarchar](50) COLLATE French_CI_AS NULL,
[DtRéception] [datetime] NULL,
[TpeCde] [tinyint] NULL DEFAULT ((1)),
[Commentaires] [nvarchar](max) COLLATE French_CI_AS NULL,
[CptQui] [smallint] NULL DEFAULT ((0)),
[Destinataire] [nvarchar](255) COLLATE French_CI_AS NULL,
[SSMA_TimeStamp] [timestamp] NOT NULL,
CONSTRAINT [Commande$PrimaryKey] PRIMARY KEY CLUSTERED
(
[CptCde] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$BasCde$disallow_zero_length] CHECK ((len([BasCde])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$BasCde$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Commentaires$disallow_zero_length] CHECK ((len([Commentaires])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$Commentaires$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Emetteur$disallow_zero_length] CHECK ((len([Emetteur])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$Emetteur$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$FlagR$disallow_zero_length] CHECK ((len([FlagR])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$FlagR$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Franco$disallow_zero_length] CHECK ((len([Franco])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$Franco$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$LibCondPaiement$disallow_zero_length] CHECK ((len([LibCondPaiement])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$LibCondPaiement$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$LibelModLiv$disallow_zero_length] CHECK ((len([LibelModLiv])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$LibelModLiv$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$N°Cde$disallow_zero_length] CHECK ((len([N°Cde])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$N°Cde$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Réf$disallow_zero_length] CHECK ((len([Réf])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$Réf$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Remarque$disallow_zero_length] CHECK ((len([Remarque])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK CONSTRAINT [SSMA_CC$Commande$Remarque$disallow_zero_length]
GO
ALTER TABLE [dbo].[Commande] WITH CHECK ADD CONSTRAINT [SSMA_CC$Commande$Signataire$disallow_zero_length] CHECK ((len([Signataire])>(0)))
GO
ALTER TABLE [dbo].[Commande] CHECK |
Partager