Relationship Diagram
Build Table SQL
CREATE TABLEHx_author (Iduniqueidentifier not NULL, UserNamenvarchar( the) not NULL, AuthorNamenvarchar( the) not NULL, Passwordnvarchar( -) not NULL, PasswordSaltnvarchar( -) not NULL, facenvarchar( -), Signaturenvarchar( -));CREATE TABLEHx_link (Iduniqueidentifier not NULL, Titlenvarchar( the) not NULL, Linknvarchar( -) not NULL, Authoriduniqueidentifier not NULL, Createtimedatetime DEFAULT GETDATE() not NULL, Modifytimedatetime DEFAULT GETDATE() not NULL); CREATE TABLEhx_article (Iduniqueidentifier not NULL, Titlenvarchar( the) not NULL, Summarynvarchar( -) not NULL, Articlecontentntext not NULL, Authoriduniqueidentifier not NULL, CategoryIduniqueidentifier not NULL, Readcountint DEFAULT 0 not NULL, Commentcountint DEFAULT 0 not NULL, Createtimedatetime DEFAULT GETDATE() not NULL, Modifytimedatetime DEFAULT GETDATE() not NULL, Statusbit DEFAULT 1 not NULL); CREATE TABLEHx_quote (Iduniqueidentifier not NULL, Authoriduniqueidentifier not NULL, Quotecontentnvarchar( -) not NULL, Createtimedatetime DEFAULT GETDATE() not NULL, Modifytimedatetime DEFAULT GETDATE() not NULL);CREATE TABLEHx_author (Iduniqueidentifier not NULL, UserNamenvarchar( the) not NULL, AuthorNamenvarchar( the) not NULL, Passwordnvarchar( -) not NULL, PasswordSaltnvarchar( -) not NULL, facenvarchar( -), Signaturenvarchar( -));
Anytime, Anywhere Notes "studious" full Practice (iii)-Database design