Samuele E. Locatelli
17 lines
635 B
Transact-SQL
17 lines
635 B
Transact-SQL
CREATE TABLE [dbo].[UTENTE] (
|
|
[DOMINIO] VARCHAR (30) NULL,
|
|
[USER_NAME] NVARCHAR (50) NOT NULL,
|
|
[COGNOME] VARCHAR (100) NULL,
|
|
[NOME] VARCHAR (100) NULL,
|
|
[COD_SOCIETA] VARCHAR (5) NULL,
|
|
[MATRICOLA] VARCHAR (5) NULL,
|
|
[COD_CDC] VARCHAR (10) NULL,
|
|
[EMAIL] VARCHAR (100) NULL,
|
|
[SIGLA] NVARCHAR (5) NULL,
|
|
[COD_LINGUA] VARCHAR (3) NULL,
|
|
[ATTIVO] CHAR (1) NULL,
|
|
CONSTRAINT [PK_UTENTE] PRIMARY KEY CLUSTERED ([USER_NAME] ASC),
|
|
CONSTRAINT [FK_UTENTE_CDC] FOREIGN KEY ([COD_CDC]) REFERENCES [dbo].[CDC] ([COD_CDC]) ON UPDATE CASCADE
|
|
);
|
|
|