CREATE TABLE `ADVISE` (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_TEACHER` int(11) NOT NULL,
  `KEY_STUDENT` int(11) NOT NULL,
  `KEY_START_EXECUTION_PERIOD` int(11) NOT NULL,
  `KEY_END_EXECUTION_PERIOD` int(11) NOT NULL, 
  `KEY_PROPOSAL` int(11) default NULL,	
  `PERCENTAGE` float NOT NULL,  
  `ADVISE_TYPE` varchar(50) NOT NULL,
  `ACK_OPT_LOCK` int(11) default NULL,  
  PRIMARY KEY  (`ID_INTERNAL`)
)TYPE=InnoDB