﻿CREATE TABLE [dbo].[RestaurationFormulaires]
(
    [Id]						UNIQUEIDENTIFIER	NOT NULL,
	[College_Id]				INT					NOT NULL,
	[Statut]					NVARCHAR (50) 		NOT NULL,
	[NbDP_College]				INT					NOT NULL,
	[NbDP_Lycee]				INT					NULL,
	[NbDP_MatPrimPeri]			INT					NULL,
	[NbDP_Commensaux]			INT					NULL,
	[NbDP_ATC]					INT					NULL,
	[NbDP_AgentC]				INT					NULL,
	[Prix_Forfait5j]			DECIMAL (18,2)		NULL,
	[NbJours_Forfait5j]			INT					NULL,
	[Prix_Forfait4j]			DECIMAL (18,2)		NULL,
	[NbJours_Forfait4j]			INT					NULL,
	[Prix_Forfait3j]			DECIMAL (18,2)		NULL,
	[NbJours_Forfait3j]			INT					NULL,
	[Prix_Forfait2j]			DECIMAL (18,2)		NULL,
	[NbJours_Forfait2j]			INT					NULL,
	[Prix_Forfait1j]			DECIMAL (18,2)		NULL,
	[NbJours_Forfait1j]			INT					NULL,
	[Prix_Ticket]				DECIMAL (18,2)		NOT NULL,
	[Tarif_Pension]				DECIMAL (18,2)		NULL,
	[Prix_ATC]					DECIMAL (18,2)		NOT NULL,
	[Prix_AgentC]				DECIMAL (18,2)		NOT NULL,
	[Prix_Commensaux]			DECIMAL (18,2)		NULL,
	[Prix_EcolePeri]			DECIMAL (18,2)		NULL,
	[NbEleves_FondSocial]		INT					NULL,
	[Montant_FondSocial]		DECIMAL (18,2)		NULL,
	[NbEleves_Impayes]			INT					NULL,
	[Montant_Impayes]			DECIMAL (18,2)		NULL,
	[Date_AvisCA]				DATETIME2 			NULL,
	[Ind_Signature]				BIT					NOT NULL,
	CONSTRAINT [PK_RestaurationFormulaires] PRIMARY KEY CLUSTERED ([Id] ASC),
	CONSTRAINT [FK_RestaurationFormulairesColleges] FOREIGN KEY ([College_Id]) REFERENCES [dbo].[Colleges] ([Id])
)

GO
CREATE NONCLUSTERED INDEX [IX_FK_RestaurationFormulairesCollege]
    ON [dbo].[RestaurationFormulaires]([College_Id] ASC);