-- ----------------------------
-- Table structure for `product_type_one`
-- ----------------------------
DROP TABLE IF EXISTS `product_type_one`;
CREATE TABLE `product_type_one` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `price` bigint(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_category_id_product_type_one` (`category_id`),
  CONSTRAINT `fk_category_id_product_type_one` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON UPDATE CASCADE,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `categoryName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;


-- ----------------------------
-- Table structure for `image`
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `id` bigint(50) NOT NULL AUTO_INCREMENT,
  `image_link` varchar(200) NOT NULL,
  `product_id` bigint(50) NOT NULL,
  `category_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_categories_id_image` (`category_id`),
  CONSTRAINT `fk_categories_id_image` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

@Entity
@Table(name = "image", schema = "eshop", catalog = "")
public class Image {

    private static final String fDefaultImage = "/resources/default.jpg";

    private long id;
    private String imageLink = fDefaultImage;
    private long lotId;
    private int categoryId;

    //getters setters
}

@Entity
@Table(name = "category", schema = "eshop", catalog = "")
public class Category {
    private int id;
    private String categoryName;

    @OneToMany(mappedBy = "category", cascade = CascadeType.ALL, orphanRemoval = true, fetch = FetchType.LAZY)
    private Set<ProductOne> productsOne = new HashSet<ProductOne>();

    //getters setters
}

@Entity
@Table(name = "product_type_one", schema = "eshop", catalog = "")
public class ProductOne {
    private long id;
    private String name;
    private long price;

    @ManyToOne
    @JoinColumn(name = "category_id", insertable = false, updatable = false)
    private Category category;

    //private Set<Image> images = new HashSet<Image>(); //как добавить?

    //getters setters
}