package jpa;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Set;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 * The persistent class for the product database table.
 * 
 */
@Entity
@Table(name = "product")
@NamedQuery(name = "Product.findAll", query = "SELECT p FROM Product p")
public class Product implements Serializable
{
   private static final long serialVersionUID = 1L;

   @Id
   private int id;

   @Lob
   private String description;

   private BigDecimal height;

   private String name;

   private BigDecimal price;

   private BigDecimal width;

   // bi-directional many-to-many association to Category
   @ManyToMany
   @JoinTable(name = "product_category", joinColumns = {
         @JoinColumn(name = "product_id") }, inverseJoinColumns = {
               @JoinColumn(name = "category_id") })
   private Set<Category> categories;

   public Product()
   {
   }

   public int getId()
   {
      return this.id;
   }

   public void setId(int id)
   {
      this.id = id;
   }

   public String getDescription()
   {
      return this.description;
   }

   public void setDescription(String description)
   {
      this.description = description;
   }

   public BigDecimal getHeight()
   {
      return this.height;
   }

   public void setHeight(BigDecimal height)
   {
      this.height = height;
   }

   public String getName()
   {
      return this.name;
   }

   public void setName(String name)
   {
      this.name = name;
   }

   public BigDecimal getPrice()
   {
      return this.price;
   }

   public void setPrice(BigDecimal price)
   {
      this.price = price;
   }

   public BigDecimal getWidth()
   {
      return this.width;
   }

   public void setWidth(BigDecimal width)
   {
      this.width = width;
   }

   public Set<Category> getCategories()
   {
      return this.categories;
   }

   public void setCategories(Set<Category> categories)
   {
      this.categories = categories;
   }

}