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
| CREATE TABLE [dbo].[PLANIFICATION](
[ID] [nvarchar](255) NOT NULL,
[NAME] [varchar](50) NOT NULL,
[EVENTSTART] [datetime] NOT NULL,
[EVENTEND] [datetime] NULL,
[RESSOURCE_ID] [varchar](50) NULL,
[STATUS] [int] NULL,
[HEURE_RDV] [datetime] NULL,
[LIEU_RDV] [text] NULL,
[ESPECE] [int] NULL,
[COMMUNE] [nvarchar](255) NULL,
[SECTEUR_PREPARE] [int] NULL,
[DATE_PREPARATION] [datetime] NULL,
[PERSONNE] [varchar](10) NULL,
[TERMINE] [int] NULL,
[DATE_REBOUCHAGE] [datetime] NULL,
[DATE_FIN] [datetime] NULL,
[MISE_A_JOUR] [varchar](50) NULL,
[REBOUCHAGE] [varchar](50) NULL,
[OPERATEUR_ID] [nvarchar](50) NULL,
[PREVENTION] [int] NULL,
[DATE_PREVENTION] [datetime] NULL,
[PROSPECTION] [int] NULL,
[DATE_PROSPECTION] [datetime] NULL,
[PERSONNE2] [varchar](10) NULL,
[PERSONNE3] [varchar](10) NULL,
CONSTRAINT [PK_PLANIFICATION] PRIMARY KEY NONCLUSTERED |
Partager