 	countRecord int(3),
 	date date,
 	primary key(barcode, name)
-) DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 create table attendance(
 	barcode varchar(30) primary key,
-	date date not null
-) DEFAULT CHARSET=utf8;
+	date datetime not null
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 create table achievement(
 	email varchar(50) primary key
-) DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 create table exerciseList(
-	name varchar(20),
-	type int(1), -- 일정시간동안 세트수 0, 일정세트 하는데 걸린시간 1
+	no int(6) not null primary key AUTO_INCREMENT,
+	name varchar(20) not null,
+	type int(1) not null, -- 일정시간동안 세트수 0, 일정세트 하는데 걸린시간 1
 	time time default 0,
-	count int(3) default 0,
-	primary key(name,type,time,count)
-) DEFAULT CHARSET=utf8;
+	count int(3) default 0
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 create table exerciseSchedule(
+	exerciseNo int(6) not null,
 	date date,
-	name varchar(20),
-	type int(1),
-	time time default 0,
-	count int(3) default 0,
-	primary key(date,name,type,time,count)
-) DEFAULT CHARSET=utf8;
+	foreign key (exerciseNo) references exerciseList(no) on delete cascade,
+	primary key (exerciseNo, date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 create table consulting(
 	no int(6) not null primary key AUTO_INCREMENT,
 	email varchar(50) not null,
 	title varchar(50) not null,
 	content text not null
-) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
 
 -- 브리드 이야기
 create table breatheBoard(

	email varchar(50) not null,
	title varchar(50) not null,
	content text not null	
)DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

create table freeBoard(
	no int(6) not null primary key AUTO_INCREMENT,
	email varchar(50) not null,
	title varchar(50) not null,
	content text not null	
)DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

-- 사부님의 노트
create table diaryBoard(

	weight int(3) not null,
	registerDate date not null,
	duration date not null
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

create table exerciseRecord(
	barcode varchar(30),
