Database

CREATE TABLE [dbo].[dish] (
	[dish_id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (50) NOT NULL ,
	[description] [nvarchar] (256) NULL ,
	[price] [money] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[order] (
	[order_id] [int] IDENTITY (1, 1) NOT NULL ,
	[order_date] [datetime] NOT NULL ,
	[table_number] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[order_dish_collection] (
	[order_id] [int] NOT NULL ,
	[dish_id] [int] NOT NULL ,
	[quantity] [int] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[dish] ADD 
	CONSTRAINT [DF_dish_price] DEFAULT (0) FOR [price],
	CONSTRAINT [PK_dish] PRIMARY KEY  CLUSTERED 
	(
		[dish_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[order] ADD 
	CONSTRAINT [DF_order_order_date] DEFAULT (getdate()) FOR [order_date],
	CONSTRAINT [DF_order_table_number] DEFAULT (0) FOR [table_number],
	CONSTRAINT [PK_order] PRIMARY KEY  CLUSTERED 
	(
		[order_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[order_dish_collection] ADD 
	CONSTRAINT [DF_order_dish_collection_quantity] DEFAULT (1) FOR [quantity],
	CONSTRAINT [PK_order_dish_collection] PRIMARY KEY  CLUSTERED 
	(
		[order_id],
		[dish_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[order_dish_collection] ADD 
	CONSTRAINT [FK_order_dish_collection_dish] FOREIGN KEY 
	(
		[dish_id]
	) REFERENCES [dbo].[dish] (
		[dish_id]
	),
	CONSTRAINT [FK_order_dish_collection_order] FOREIGN KEY 
	(
		[order_id]
	) REFERENCES [dbo].[order] (
		[order_id]
	)
GO

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog