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
| CR
[idCR] [int] IDENTITY(1,1) NOT NULL,
[refCR] [varchar](25) COLLATE French_CI_AS NULL,
[dateCR] [smalldatetime] NULL,
[idEtatRegistre] [tinyint] NULL,
[temps] [smallint] NULL,
[raisonValidation] [varchar](max) COLLATE French_CI_AS NULL,
[etatCR] [tinyint] NULL,
[idTechnicien] [tinyint] NULL,
[idClient] [smallint] NULL,
[idSite] [smallint] NULL,
[contactRegistre] [varchar](50) COLLATE French_CI_AS NULL,
[idRaison] [tinyint] NULL,
[observations] [varchar](max) COLLATE French_CI_AS NULL,
[CRExceptionnel] [bit] NULL,
[surTablette] [bit] NULL,
SITE_CLIENT
[idSite] [smallint] IDENTITY(1,1) NOT NULL,
[idClient] [int] NULL,
[NomSite] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumRue] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeRue] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NomRue] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdresseSuite] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CodePostal] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Ville] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Pays] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumTelFixe] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumFax] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Mail] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumTelMobile] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdresseFacturation] [bit] NULL,
[AdresseIntervention] [bit] NULL,
[Kilometrage] [numeric](18, 2) NULL,
[idZone] [smallint] NULL,
[idTechnicien] [tinyint] NULL,
[Horaires] [varchar](50) COLLATE French_CI_AS NULL,
[tempsTheorique] [numeric](18, 0) NULL,
ELEMENT_PLANNING
[idElementPlanning] [int] IDENTITY(1,1) NOT NULL,
[idPlanningEmploye] [int] NULL,
[idSite] [int] NULL,
[dateDebut] [smalldatetime] NULL,
[dateFin] [smalldatetime] NULL,
[commentaire] [varchar](200) COLLATE French_CI_AS NULL,
[dateAjout] [datetime] NULL,
[idEtat] [int] NULL,
[dureeMinutes] [int] NULL
ETAT_PLANNING
[idEtatPlanning] [int] IDENTITY(1,1) NOT NULL,
[nomEtatPlanning] [varchar](50) COLLATE French_CI_AS NULL,
[commentaireEtatPlanning] [varchar](200) COLLATE French_CI_AS NULL |
Partager