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 retailer address details

 * 

 * @author ashikali

 *

 */

@Entity

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

@NamedQueries({

	@NamedQuery(name="RetailerAddress.selectByRetailerId", query="select ra.addressId from RetailerAddress ra where ra.retailerId= :retailerId"),

	@NamedQuery(name="RetailerAddress.deleteByRetailerAndAddressId", query="delete from RetailerAddress ra where ra.retailerId= :retailerId and ra.addressId = :addressId"),

	@NamedQuery(name = "RetailerAddress.selectAddressesByRetailerId", query = "select a from RetailerAddress ra join Address a on a.id = ra.addressId where ra.retailerId = :retailerId")

})

public class RetailerAddress implements Serializable{

	private static final long serialVersionUID = 1L;

	public RetailerAddress() {

	}

	@Id

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

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

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

	private int retailerId;

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

	private int addressId;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getRetailerId() {

		return retailerId;

	}

	public void setRetailerId(int retailerId) {

		this.retailerId = retailerId;

	}

	public int getAddressId() {

		return addressId;

	}

	public void setAddressId(int addressId) {

		this.addressId = addressId;

	}

	@Override

	public String toString() {

		return "RetailerAddress [retailerId=" + retailerId + ", addressId=" + addressId + "]";

	}

}