深入浅出Hibernate中的数据库设计

create table User(
id			int			not null,
name		varchar(50) 	not null,
pwd			varchar(50)	not null,
primary key (id)
)
type=InnoDB;

create table board(
id			int			not null,
parent_id		int 			not null,
name		varchar(50)	not null,
remark		varchar(255),
create_by		int 			not null,
create_time	datetime		not null,
primary key (id)
)
type=InnoDB;

create table article(
id			int			not null,
parent_id		int,
board_id		int			not null,
article_type	int			not null,
title			varchar(255)	not null,
body			text,
hits			int			not null,
bytes			int,
tree_index		varchar(255),
node_level		int,
root_id		int,
create_by		int			not null,
create_time	datetime		not null,
last_update_by	int			not null,
last_update_time	datetime	not null,
primary key (id)
)
type=InnoDB;

create table vote(
id			int			not null,
count			int,
primary key (id)
)
type=InnoDB;

create table vote_option(
option_id		int			not null,
poll_id		int			not null,
option_text		text,
agree_number	int,
primary key (option_id)
)
type=InnoDB;