package bean;
 
 import javax.persistence.Entity;
 import javax.persistence.FetchType;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
 import javax.persistence.Transient;
 
 import br.com.linkcom.neo.authorization.Role;
 import br.com.linkcom.neo.authorization.impl.AbstractPermission;
 import br.com.linkcom.neo.validation.annotation.MaxLength;
 import br.com.linkcom.neo.validation.annotation.Required;
 
 @Entity
 public class Permissao extends AbstractPermission {
 
 	protected Integer cdpermissao;
 	protected Papel papel;
 	protected String stringpermissao;
 	protected String path;
 	protected Tela tela;
 
 	@MaxLength(80)
 	@Required
 	public String getPath() {
 		return path;
 	}
 
 	@Id
 	@GeneratedValue(strategy = GenerationType.AUTO)
 	public Integer getCdpermissao() {
 		return cdpermissao;
 	}
 	
 	@ManyToOne(fetch=FetchType.LAZY)
 	@JoinColumn(name="cdpapel")
 	public Papel getPapel() {
 		return papel;
 	}
 	@ManyToOne(fetch=FetchType.LAZY)
 	@JoinColumn(name="cdtela")
 	public Tela getTela() {
 		return tela;
 	}
 	@MaxLength(80)
 	public String getStringpermissao() {
 		return stringpermissao;
 	}
 	
 	public void setCdpermissao(Integer cdpermissao) {
 		this.cdpermissao = cdpermissao;
 	}
 
 	public void setPapel(Papel papel) {
 		this.papel = papel;
 	}
 
 	public void setStringpermissao(String stringpermissao) {
 		this.stringpermissao = stringpermissao;
 	}
 
 	public void setPath(String path) {
 		this.path = path;
 	}
     
 
 	@Override
 	@Transient
 	public String getPermissionString() {
 
 		return stringpermissao;
 	}
 
 	@Override
 	public void setPermissionString(String stringpermissao) {
 		this.stringpermissao = stringpermissao;
 
 	}
 	
 	@Transient
 	public Role getRole() {
 		return papel;
 	}
 	public void setTela(Tela tela) {
 		this.tela = tela;
 	}
 
 }
 

 CREATE TABLE `permissao` (
   `cdpermissao` int(11) NOT NULL auto_increment,
   `stringpermissao` varchar(80) NOT NULL,
   `cdtela` int(11) NOT NULL,
   `cdpapel` int(11) NOT NULL,
   `path` varchar(50) default NULL,
   PRIMARY KEY  (`cdpermissao`),
   KEY `cdtela` (`cdtela`),
   KEY `cdpapel` (`cdpapel`),
   CONSTRAINT `fk_permissao_papel` FOREIGN KEY (`cdpapel`) REFERENCES `papel` (`cdpapel`),
   CONSTRAINT `fk_permissao_tela` FOREIGN KEY (`cdtela`) REFERENCES `tela` (`cdtela`)
 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
 

 CREATE TABLE public.permissao (
     cdpermissao integer NOT NULL,
     stringpermissao character varying(80) NOT NULL,
     cdtela integer NOT NULL,
     cdpapel integer NOT NULL,
     "path" character varying(50)
 ) WITHOUT OIDS;
 ALTER TABLE ONLY public.permissao ALTER COLUMN cdpermissao SET STATISTICS 0;
 ALTER TABLE ONLY public.permissao ALTER COLUMN stringpermissao SET STATISTICS 0;
 ALTER TABLE ONLY public.permissao ALTER COLUMN cdtela SET STATISTICS 0;
 ALTER TABLE ONLY public.permissao ALTER COLUMN cdpapel SET STATISTICS 0;
 
 ALTER TABLE ONLY permissao
     ADD CONSTRAINT permissao_pkey PRIMARY KEY (cdpermissao);
 
 ALTER TABLE ONLY permissao
     ADD CONSTRAINT fk_permissao_papel FOREIGN KEY (cdpapel) REFERENCES papel(cdpapel);
 
 ALTER TABLE ONLY permissao
     ADD CONSTRAINT fk_permissao_tela FOREIGN KEY (cdtela) REFERENCES tela(cdtela);