Anytime, Anywhere Notes "studious" full Practice (iii)-Database design

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