CREATE TABLE [RilPro].[AnagOperatori] (
    [CodSoggetto]   NCHAR (17)    NOT NULL,
    [CodCS]         NCHAR (2)     NOT NULL,
    [CodDipendente] NCHAR (7)     NULL,
    [CodAziendaOp]  NCHAR (6)     NULL,
    [DescAziendaOp] NVARCHAR (40) NULL,
    [CodFilialeOp]  NCHAR (10)    NULL,
    [DescFilialeOp] NVARCHAR (40) NULL,
    [Cognome]       NVARCHAR (40) NULL,
    [Nome]          NVARCHAR (40) NULL,
    CONSTRAINT [PK_AnagOperatori_1] PRIMARY KEY CLUSTERED ([CodSoggetto] ASC),
    CONSTRAINT [FK_AnagOperatori_AnagCompanySito] FOREIGN KEY ([CodCS]) REFERENCES [dbo].[AnagCompanySito] ([CodCS]) ON UPDATE CASCADE
);

