fichecollege/CD67.FicheCollege.BDD/dbo/Tables/ActionThematiques.sql

CREATE TABLE [dbo].[ActionThematiques] (
    [Id]          INT            IDENTITY (1, 1) NOT NULL,
    [Nom]         NVARCHAR (MAX) NOT NULL,
    [Neutralise]  BIT            NOT NULL,
    [Ordre]       INT            NOT NULL,
    [ActionAxeId] INT            NOT NULL,
    CONSTRAINT [PK_ActionThematiques] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ActionAxeActionThematique] FOREIGN KEY ([ActionAxeId]) REFERENCES [dbo].[ActionAxes] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_FK_ActionAxeActionThematique]
    ON [dbo].[ActionThematiques]([ActionAxeId] ASC);