﻿CREATE TABLE [dbo].[RestaurationParametres]
(
    [Id]						INT				IDENTITY (1, 1) NOT NULL,
	[Annee_Id]					INT				NOT NULL,
	[Campagne]					BIT				NOT NULL,
	[Prix_Mini]					DECIMAL (18,2)    NULL,
	[Prix_ATC]					DECIMAL (18,2)    NULL,
	[Prix_AgentC]				DECIMAL (18,2)    NULL,
	[Prix_MiniAutres]			DECIMAL (18,2)    NULL,
	CONSTRAINT [PK_RestaurationParametres] PRIMARY KEY CLUSTERED ([Id] ASC),
	CONSTRAINT [FK_RestaurationParametresAnnee] FOREIGN KEY ([Annee_Id]) REFERENCES [dbo].[Annees] ([Id])
)

GO
CREATE NONCLUSTERED INDEX [IX_FK_AnneeCollege]
    ON [dbo].[RestaurationParametres]([Annee_Id] ASC);