fichecollege/CD67.FicheCollege.BDD/ActionEduThematiques.sql

CREATE TABLE [dbo].[ActionEduThematiques] (
    [Id]             INT            IDENTITY (1, 1) NOT NULL,
    [Nom]            NVARCHAR (MAX) NOT NULL,
    [Neutralise]     BIT            NOT NULL,
    [Ordre]          INT            NOT NULL,
    [ActionEduAxeId] INT            NOT NULL,
    CONSTRAINT [PK_ActionEduThematiques] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ActionEduAxeActionEduThematique] FOREIGN KEY ([ActionEduAxeId]) REFERENCES [dbo].[ActionEduAxes] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_FK_ActionEduAxeActionEduThematique]
    ON [dbo].[ActionEduThematiques]([ActionEduAxeId] ASC);