/*Aswin 17-07-2018*/
CREATE TABLE batch_video_repository (
  id int(11) NOT NULL AUTO_INCREMENT,
  title varchar(255) NOT NULL,
  url varchar(255) NOT NULL,
  description varchar(255) DEFAULT NULL,
  keywords varchar(255) DEFAULT NULL,
  thumbnail varchar(255) DEFAULT NULL,
  staffID int(11) NOT NULL,
  batchID int(11) NOT NULL,
  PRIMARY KEY (id),
  KEY staffID (staffID),
  KEY batchID (batchID),
  CONSTRAINT batch_video_repository_ibfk_1 FOREIGN KEY (staffID) REFERENCES staffaccounts (staffID),
  CONSTRAINT batch_video_repository_ibfk_2 FOREIGN KEY (batchID) REFERENCES batches (batchID)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=latin1

