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

CREATE TABLE [dbo].[Actions] (
    [Id]                 INT            IDENTITY (1, 1) NOT NULL,
    [Nom]                NVARCHAR (MAX) NOT NULL,
    [Description]        NVARCHAR (MAX) NOT NULL,
    [Neutralise]         BIT            NOT NULL,
    [Ordre]              INT            NOT NULL,
    [ActionThematiqueId] INT            NOT NULL,
    CONSTRAINT [PK_Actions] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ActionThematiqueAction] FOREIGN KEY ([ActionThematiqueId]) REFERENCES [dbo].[ActionThematiques] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_FK_ActionThematiqueAction]
    ON [dbo].[Actions]([ActionThematiqueId] ASC);