Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity;

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;

/**
 * This class basically contains tag details
 * 
 * @author ashikali
 *
 */
@Entity
@Table(name="pin_code_tag", schema = "dtr")
@NamedQueries({
        @NamedQuery(name="PinCodeTag.selectCount",query="select count(pct) from PinCodeTag pct"),
        @NamedQuery(name="PinCodeTag.selectAll",query="select pct from PinCodeTag pct"),
        @NamedQuery(name="PinCodeTag.selectById",query="select pct from PinCodeTag pct where pct.id= :id"),
        @NamedQuery(name="PinCodeTag.selectByPinCode",query="select pct from PinCodeTag pct where pct.pinCode= :pinCode"),
        @NamedQuery(name="PinCodeTag.selectByTagId",query="select pct from PinCodeTag pct where pct.tagId = :tagId"),
        @NamedQuery(name="PinCodeTag.deleteById",query="delete from PinCodeTag pct where pct.id= :id"),
        @NamedQuery(name="PinCodeTag.updateActiveById", query = "update PinCodeTag pct set pct.active = :active where pct.id= :id")
})
public class PinCodeTag implements Serializable{
        
        private static final long serialVersionUID = 1L;
        
        public PinCodeTag() {
        }
        
        @Id
        @Column(name="id", columnDefinition = "int(10) unsigned")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name="pin_code")
        private int pinCode;
        
        @Column(name = "tag_id")
        private int tagId;
        
        @Column(name = "active", columnDefinition="tinyint(1) default 0")
        private boolean active;
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        
        public int getPinCode() {
                return pinCode;
        }
        public void setPinCode(int pinCode) {
                this.pinCode = pinCode;
        }
        public int getTagId() {
                return tagId;
        }
        public void setTagId(int tagId) {
                this.tagId = tagId;
        }
    public boolean isActive() {
                return active;
        }
    public void setActive(boolean active) {
                this.active = active;
        }
    
}