create table Tags
(
  ID uniqueidentifier not null rowguidcol
    constraint PK_Tag primary key clustered,
  [Name] nvarchar(40) not null
) -- Tags

create table Posts
(
  ID uniqueidentifier not null rowguidcol
    constraint PK_Post primary key clustered,
  Body nvarchar(max) not null,
  Created datetime not null,	
  Excerpt nvarchar(max) not null,
  [File] varbinary(max) filestream default(0x),
  IPaper bit not null default 0,
  Published bit not null default 0,
  Title nvarchar(200) not null,
  Updated datetime not null
) -- Posts

  create table PostsTags
  (
    PostID uniqueidentifier not null,
	  TagID uniqueidentifier not null,
	  constraint PK_PostsTags
		  primary key clustered (PostID, TagID),
	  constraint FK_PostsTags_Posts
		  foreign key(PostID)
		  references Posts(ID)
		  on delete cascade,
	  constraint FK_PostsTags_Tags
		  foreign key(TagID)
		  references Tags(ID)
		  on delete cascade
	) -- PostsTags

quote:

---

Originally posted by TG

The cascade delete seems to be implemented according to your stated requiments - Have you tested the functionality?

---

quote:

---

Originally posted by TG
The one problem I do see is that you have CLUSTERED primary keys on uniqueidentifier columns.

---

quote:

---

Originally posted by TG
Another (maybe questionable) thing is the varbinary [file] column. Have you considered storing the file on a filesystem and just keeping some file attributes to describe the file and location in the table?

---