fichecollege/CD67.FicheCollege.BDD/Territoires.sql

CREATE TABLE [dbo].[Territoires] (
    [Id]                 NVARCHAR (10)  NOT NULL,
    [Libelle]            NVARCHAR (255) NOT NULL,
    [Referent_SID]       NVARCHAR (64)  NULL,
    [Referent_Nom]       NVARCHAR (255) NULL,
    [Referent_Prenom]    NVARCHAR (255) NULL,
    [Referent_Structure] NVARCHAR (255) NULL,
    [Referent_Login]     NVARCHAR (255) NULL,
    [Referent_Email]     NVARCHAR (255) NULL,
    [Ordre]              INT            NOT NULL,
    CONSTRAINT [PK_Territoires] PRIMARY KEY CLUSTERED ([Id] ASC)
);