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
| /****** Object: Table [dbo].[PATI] Script Date: 11/07/2013 12:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PATI](
[IndexPatient] [numeric](18, 0) NOT NULL,
[Nom] [varchar](100) NULL,
[Prenom] [varchar](100) NULL,
[Sexe] [varchar](50) NULL,
[AgeAnnee] [int] NULL,
[AgeMois] [int] NULL,
[AgeJour] [int] NULL,
[AgeHeure] [varchar](5) NULL,
[DateNaissance] [datetime] NULL,
[LieuNaissance] [varchar](100) NULL,
[Nationalite] [varchar](100) NULL,
[Religion] [varchar](100) NULL,
[Profession] [varchar](100) NULL,
[SituationFamiliale] [varchar](50) NULL,
[CodeRegion] [numeric](18, 0) NULL,
[CodeProvince] [numeric](18, 0) NULL,
[CodeCercle] [numeric](18, 0) NULL,
[CodeCommune] [numeric](18, 0) NULL,
[PieceIdentite] [varchar](50) NULL,
[NumPieceIdentite] [varchar](50) NULL,
[Adresse] [varchar](500) NULL,
[CodeVille] [numeric](18, 0) NULL,
[Telephone] [varchar](50) NULL,
[NomPere] [varchar](100) NULL,
[NomMere] [varchar](100) NULL,
[PersonneAPrevenir] [varchar](100) NULL,
[NomMarie] [varchar](100) NULL,
CONSTRAINT [PK_PATI] PRIMARY KEY CLUSTERED
(
[IndexPatient] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO |
Partager