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

最新推荐文章于 2025-04-25 18:07:04 发布

midi13

最新推荐文章于 2025-04-25 18:07:04 发布

阅读量1.2k

点赞数

分类专栏：数据库文章标签： hibernate 数据库 null table tree user

本文链接：https://blog.youkuaiyun.com/midi13/article/details/2719979

版权

数据库专栏收录该内容

3 篇文章

订阅专栏

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;