Not so long ago I have designed the database for project. I used the following script and structure:
<br />
CREATE TABLE [dbo].[Categories](<br />
[CategoryID] [int] IDENTITY(11,1) NOT NULL,<br />
[Name] [nvarchar](80) COLLATE Cyrillic_General_CI_AS NOT NULL,<br />
[ParentCategoryID] [int] NOT NULL,<br />
[GameID] [int] NOT NULL,<br />
CONSTRAINT [XPKCategories] PRIMARY KEY NONCLUSTERED <br />
(<br />
[CategoryID] ASC<br />
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]<br />
) ON [PRIMARY]<br />
<br />
GO<br />
USE [auction2]<br />
GO<br />
ALTER TABLE [dbo].[Categories] WITH CHECK ADD CONSTRAINT [R_39] FOREIGN KEY([GameID])<br />
REFERENCES [dbo].[Games] ([GameID])<br />