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
| CREATE TABLE [dbo].[PERS](
[ROWID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[MATRIC] [int] NOT NULL,
[NOM] [varchar](30) NULL,
[PRENOM] [varchar](30) NULL
PRIMARY KEY CLUSTERED
( [ROWID] ASC ))
CREATE TABLE [dbo].[PERSVAR](
[ROWID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[MATRIC] [int] NULL,
[DSITUD] [datetime] NULL,
[DSITUF] [datetime] NULL,
[SERID] [varchar](6) NULL
PRIMARY KEY CLUSTERED
( [ROWID] ASC ))
CREATE TABLE [dbo].[AP](
[ROWID] [int] IDENTITY(1,1) NOT NULL,
[MATRIC] [int] NOT NULL,
[DATED] [datetime] NOT NULL,
[ABSID] [varchar](4) NOT NULL,
[TEMPS] [int] NULL,
[DATEF] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED
( [ROWID] ASC ))
CREATE TABLE [dbo].[MA](
[ROWID] [int] IDENTITY(1,1) NOT NULL,
[ABSID] [varchar](4) NOT NULL,
[LIBABS] [varchar](30) NULL,
PRIMARY KEY CLUSTERED
( [ROWID] ASC ))
CREATE TABLE [dbo].[PT](
[ROWID] [int] IDENTITY(1,1) NOT NULL,
[MATRIC] [int] NULL,
[DATS] [datetime] NULL,
[HEURES] [smallint] NULL,
[MINUTS] [smallint] NULL,
[ESS] [varchar](1) NULL,
PRIMARY KEY CLUSTERED
( [ROWID] ASC )) |
Partager