create table `tbl_user` (
uidx bigint auto_increment,
email varchar(300),
`name` varchar(100) not null,
`password` varchar(200) not null,
birthdate date,
regdate timestamp default current_timestamp,
constraint pk_tbl_user primary key(uidx),
constraint uq_tbl_user unique(email)
);
create table `tbl_post` (
pidx bigint auto_increment,
pcontent mediumtext not null,
writer varchar(100) not null,
regdate timestamp not null default current_timestamp,
updatedate timestamp,
secret enum('y', 'n') default 'n',
uidx bigint,
constraint pk_tbl_post primary key(pidx),
constraint fk_tbl_post foreign key(uidx) references tbl_user(uidx)
);
create table `tbl_reply` (
ridx bigint auto_increment,
rcontent mediumtext not null,
writer varchar(100) not null,
regdate timestamp not null default current_timestamp,
updatedate timestamp,
uidx bigint,
pidx bigint,
constraint pk_tbl_reply primary key(ridx),
constraint fk_tbl_reply_post foreign key(pidx) references tbl_post(pidx),
constraint fk_tbl_reply_user foreign key(uidx) references tbl_user(uidx)
);
create table `tbl_schedule` (
sidx bigint auto_increment,
scontent text not null,
startdate datetime not null default current_timestamp,
enddate datetime not null,
priority int(4) default 1,
constraint pk_schedule primary key(sidx)
);
create table `tbl_attach` (
uuid varchar(40),
uploadpath varchar(200) not null,
filename varchar(400) not null,
pidx bigint,
constraint pk_attch primary key(uuid),
constraint fk_attach_post foreign key(pidx) references tbl_post(pidx)
);
스프링 부트 프로젝트 생성 및 mysql 연동하기