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 + "]";
        }
        
}