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
| CREATE TABLE [dbo].[RessHum_Conge](
[id_c] [bigint] IDENTITY(1,1) NOT NULL,
[matricule] [varchar](50) NOT NULL,
[nmpr] [varchar](200) NOT NULL,
[suf] [varchar](100) NOT NULL,
[ntr] [varchar](250) NULL,
[duj] [varchar](50) NOT NULL,
[auj] [varchar](50) NOT NULL,
[nbj] [int] NULL CONSTRAINT [DF_RessHum_Conge_nbj] DEFAULT ((1)),
[lej] [varchar](50) NULL,
[poste] [varchar](250) NULL,
[motif] [text] NULL,
[dtsys] [datetime] NULL,
[etat_cuf] [varchar](50) NULL CONSTRAINT [DF_RessHum_Conge_etat_cuf] DEFAULT ('En cours'),
[rq_cuf] [text] NULL,
[dt_cuf] [datetime] NULL,
[poste_cuf] [varchar](150) NULL,
[diplome] [varchar](50) NULL,
[etat_dir] [varchar](50) NULL CONSTRAINT [DF_RessHum_Conge_etat_dir] DEFAULT ('--'),
[rq_dir] [text] NULL,
[dt_dir] [datetime] NULL,
[poste_dir] [varchar](150) NULL,
[etat_dop] [varchar](50) NULL CONSTRAINT [DF_RessHum_Conge_etat_dop] DEFAULT ('--'),
[rq_dop] [text] NULL,
[dt_dop] [datetime] NULL,
[poste_dop] [varchar](150) NULL,
[usine] [varchar](8) NULL,
[etat_rh] [varchar](50) NULL CONSTRAINT [DF_RessHum_Conge_etat_rh] DEFAULT ('--'),
[rq_rh] [text] NULL,
[dt_rh] [datetime] NULL,
[poste_rh] [varchar](150) NULL,
[exp] [varchar](20) NULL,
[ValidPar_cufs] [varchar](10) NULL,
[ValidPar_dir] [varchar](10) NULL,
[ValidPar_rh] [varchar](10) NULL,
[PassPar] [varchar](50) NULL,
CONSTRAINT [PK_RessHum_Conge] PRIMARY KEY CLUSTERED
(
[id_c] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [FG1]
) ON [FG1] TEXTIMAGE_ON [PRIMARY]
GO |
Partager