Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.dtr;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.persistence.UniqueConstraint;

/**

 * This class basically contains api details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name="dtr.shop_address", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"shop_id","address_id"})})

@NamedQueries({

	@NamedQuery(name="ShopAddress.selectAddressByShopId", query="select a from ShopAddress sa join Address a on a.id = sa.addressId where sa.shopId= :shopId"),

	@NamedQuery(name="ShopAddress.deleteByShopId", query="delete from ShopAddress sa where sa.shopId= :shopId")

})

public class ShopAddress implements Serializable{

	private static final long serialVersionUID = 1L;

	public ShopAddress() {

	}

	@Id

	@Column(name="id", unique=true, updatable=false)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name="shop_id", unique=false, updatable=false)

	private int shopId;

	@Column(name="address_id", unique = false)

	private int addressId;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getShopId() {

		return shopId;

	}

	public void setShopId(int shopId) {

		this.shopId = shopId;

	}

	public int getAddressId() {

		return addressId;

	}

	public void setAddressId(int addressId) {

		this.addressId = addressId;

	}

	@Override

	public String toString() {

		return "ShopAddress [shopId=" + shopId + ", addressId=" + addressId + "]";

	}

}