[Series Học ASP.NET MVC] Phần 1 - Thiết kế cơ sở dữ liệu

Script sql

create table Category(
CategoryID int identity(1,1) primary key,
CategoryName nvarchar(100) not null
)
go
create table Post(
PostID int identity(1,1) primary key,
Title nvarchar(200) not null,
Author nvarchar(50) not null,
Price decimal(18,0),
CategoryID int not null,
[Description] nvarchar(300) not null,
Published datetime default(getdate()),
ViewCount int default(0),
constraint fk_book_category foreign key (CategoryID) references Category(CategoryID)
)
go
create table [User](
UserID int identity(1,1) primary key,
Username varchar(50) not null,
[Password] nvarchar(50) not null,
Fullname nvarchar(100) not null,
IsAdmin bit default(0)
)
go
create table Comment(
CommentID int identity(1,1) primary key,
PostID int not null,
UserID int not null,
CommentDate datetime default(getdate()),
Content nvarchar(500) not null,
constraint fk_comment_user foreign key (UserID) references [User](UserID),
constraint fk_comment_post foreign key (PostID) references Post(PostID)
)