fichecollege/CD67.FicheCollege.BDD/RestaurationFormulairesRepas.sql

CREATE TABLE [dbo].[RestaurationFormulairesRepas]
(
    [Id]							INT					IDENTITY (1, 1) NOT NULL,
	[RestaurationFormulaires_Id]	UNIQUEIDENTIFIER	NOT NULL,
	[RestaurationTypesRepas_Id]		INT					NOT NULL,
	[NbRepas]						INT					NULL,
	[NbJours]						INT					NULL,
	[NomEtablissement]				NVARCHAR(255)		NULL, 
	CONSTRAINT [PK_RestaurationFormulairesRepas] PRIMARY KEY CLUSTERED ([Id] ASC),
	CONSTRAINT [FK_RestaurationFormulairesRepasForm] FOREIGN KEY ([RestaurationFormulaires_Id]) REFERENCES [dbo].[RestaurationFormulaires] ([Id]),
	CONSTRAINT [FK_RestaurationFormulairesTypesRepas] FOREIGN KEY ([RestaurationTypesRepas_Id]) REFERENCES [dbo].[RestaurationTypesRepas] ([Id]),
)