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

CREATE TABLE [dbo].[ActionEduMissions] (
    [Id]                 INT            IDENTITY (1, 1) NOT NULL,
    [Code]               NVARCHAR (MAX) NOT NULL,
    [Nom]                NVARCHAR (MAX) NOT NULL,
    [Description]        NVARCHAR (MAX) NOT NULL,
    [ActionEduCollegeId] INT            NOT NULL,
    CONSTRAINT [PK_ActionEduMissions] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ActionEduCollegeActionEduMission] FOREIGN KEY ([ActionEduCollegeId]) REFERENCES [dbo].[ActionsEduColleges] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_FK_ActionEduCollegeActionEduMission]
    ON [dbo].[ActionEduMissions]([ActionEduCollegeId] ASC);