CREATE TABLE "Posts" ( "Id" int, "Title" varchar(255), "Body" varchar(255), "PublishedOn" datetime, "AllowAnonymousToComment" varchar(255), "ApprovedCommentsCount" int, "UnApprovedCommentsCount" int, "ModifiedOn" datetime, "Author_Id" int CONSTRAINT Users_Id REFERENCES Users(Id), "UserAgent" varchar(255), "IsDraft" bool, "IsApproved" bool, "..." varchar(255) ); CREATE TABLE "Comments" ( "Id" int PRIMARY KEY, "Body" varchar(255), "CreatorName" varchar(255), "Parent_Id" int CONSTRAINT Comments_Id REFERENCES Comments(Id), "userAgent" varchar(255), "CreateOn" datetime, "User_Id" int CONSTRAINT Users_Id REFERENCES Users(Id), "SiteUrl" varchar(255), "Email" varchar(255), "Post_Id" int CONSTRAINT Posts_Id REFERENCES Posts(Id), "Status" int, "ModifiedOn" datetime, "..." varchar(255) ); CREATE TABLE "Attachments" ( "Id" int PRIMARY KEY, "FileName" varchar(255), "AttachedOn" datetime, "Size" int, "Extension" varchar(255), "ContentType" varchar(255), "Attacher_Id" int CONSTRAINT Users_Id REFERENCES Users(Id), "UserAgent" varchar(255), "DownloadsCount" int ); CREATE TABLE "Users" ( "Id" int PRIMARY KEY, "UserName" varchar(255), "HashPasswod" varchar(255), "DisplayName" varchar(255), "Email" varchar(255), "..." varchar(255) ); CREATE TABLE "Roles" ( "Id" int PRIMARY KEY, "Name" varchar(255), "Description" varchar(255) ); CREATE TABLE "Tags" ( "Id" int, "Name" varchar(255) ); CREATE TABLE "Permissions" ( "Id" int PRIMARY KEY, "Name" varchar(255) ); CREATE TABLE "UserRole" ( "User_Id" int CONSTRAINT Users_Id REFERENCES Users(Id), "Role_Id" int CONSTRAINT Roles_Id REFERENCES Roles(Id) ); CREATE TABLE "PermissionRole" ( "Role_Id" int CONSTRAINT Roles_Id REFERENCES Roles(Id), "Permission_Id" int CONSTRAINT Permissions_Id REFERENCES Permissions(Id) ); CREATE TABLE "PostTag" ( "Tag_Id" int CONSTRAINT Tags_Id REFERENCES Tags(Id), "Post_Id" int CONSTRAINT Posts_Id REFERENCES Posts(Id) );