1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE TABLE [dbo].[INTERVENANTE](
[NumInt] [int] IDENTITY(1,1) NOT NULL,
[NomInt] [varchar](50) COLLATE French_CI_AS NULL,
[PrenomInt] [varchar](50) COLLATE French_CI_AS NULL,
[NomJFInt] [varchar](50) COLLATE French_CI_AS NULL,
[AdresseInt] [varchar](50) COLLATE French_CI_AS NULL,
[CPInt] [int] NULL,
[VilleInt] [varchar](50) COLLATE French_CI_AS NULL,
[TelFixeInt] [int] NULL,
[TelPortInt] [int] NULL,
[SecuSocialeInt] [float] NULL,
[DateNaissInt] [datetime] NULL,
[LieuNaissInt] [varchar](50) COLLATE French_CI_AS NULL,
[DateEntrInt] [datetime] NULL,
[DateSortInt] [decimal](18, 0) NULL,
[ObsInt] [varchar](50) COLLATE French_CI_AS NULL,
CONSTRAINT [PK_INTERVENANTE] PRIMARY KEY CLUSTERED
(
[NumInt] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] |
Partager