CREATE TABLE `Image` (
  `id` int(25) NOT NULL,
  `imagename` varchar(45) NOT NULL,
  `imageurl` varchar(45) NOT NULL,
  `added` DATETIME NOT NULL,
  `caption` varchar(200) NOT NULL,
  `imagecol` varchar(45) NOT NULL,
  `modified` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`Photographer_id`) REFERENCES `Article` (`Article_id`),
  FOREIGN KEY (`Tag_id`) REFERENCES `Tag` (`Tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `Article` (
  `id` int(25) NOT NULL,
  `name` varchar(45) NOT NULL,
  `caption` varchar(200) NOT NULL,
  `text` TEXT NOT NULL,
  `articlecol` varchar(45) NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`Author_id`) REFERENCES `Image` (`Image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `Photographer` (
    `id` int(25) NOT NULL,
    `name` varchar(45) NOT NULL,
    PRIMARY KEY (`id`));

CREATE TABLE `Tag` (
    `id` int(25) NOT NULL,
    `name` varchar(45) NOT NULL,
    FOREIGN KEY (`Image_id`) REFERENCES `Image`(