CREATE TABLE `dsnotes` (
  `ID_LNK` int(11) NOT NULL AUTO_INCREMENT,
  `Shortage_ID_LNK` int(11) NOT NULL,
  `User_ID_LNK` int(11) NOT NULL,
  `Note_Time` text NOT NULL,
  `Title` varchar(100) NOT NULL,
  `Content` text NOT NULL,
  `Updated_User_ID_LNK` int(11) NOT NULL,
  `Updated_Time` varchar(255) NOT NULL,
  `Deleted` int(11) NOT NULL,
  PRIMARY KEY (`ID_LNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1