JSP新闻系统跟我学之一数据库设计

数据库设计;

Create database news
go
use news
go
Create table t_user
(
	id int identity(1,1)primary key,
	username varchar(20)unique not null,
	pwd varchar(20),
	email varchar(30),
	address varchar(50),
	hobby varchar(30)
)
insert t_user
select 'admin','admin','admin@sohu.com','北京景山','paly' union
select 'user','user','user@sohu.com','上海市浦东新区','swim' 
Create table t_topic
(
   id int identity(1,1)primary key,
   tname varchar(50),
   createtime datetime
)
insert t_topic
select '国际',GETDATE() union
select '国内',GETDATE() union
select '财经',GETDATE() union
select '体育',GETDATE() union
select '科技',GETDATE()
select * from t_topic
Create table t_news
(
   id int identity(1,1)primary key,
   tid int foreign key references t_topic(id),
   title varchar(100),
   author varchar(20),
   createtime datetime,
   ncontent nvarchar(2000),
   modifytime datetime,
   summary varchar(200),
   pic varchar(50)
)
select * from t_topic
select * from t_news
insert t_news
select 1,'人民币','央行',GETDATE(),'人民币利于出口',GETDATE(),'问题','' union
select 2,'德国制造4.0','央行',GETDATE(),'制造业牛奔',GETDATE(),'制造','' union
select 4,'苹果手机7','央行',GETDATE(),'三星手机爆炸，苹果手机出师不利',GETDATE(),'手机安全','' union
select 5,'中国足球','足球',GETDATE(),'功利足球',GETDATE(),'加油','' 






Create table t_comment
(
	id int identity(1,1)primary key,
	nid int foreign key references t_news(id),
	ccontent varchar(2000),
	createtime datetime,
	author varchar(20)
)