· 6 years ago · Apr 08, 2019, 09:28 AM
1# --- !Ups
2CREATE TABLE sad_cca (
3 id BIGSERIAL NOT NULL,
4 tenant_id INT8 NOT NULL,
5 nome BIGSERIAL NOT NULL,
6 epoca_id BIGSERIAL NOT NULL,
7 apagado boolean NOT NULL,
8 PRIMARY KEY (id)
9 );
10
11alter table sad_cca add constraint sad_epoca_fkey foreign key (epoca_id) references sad_epoca;
12
13
14# --- !Downs
15alter table sad_cca drop constraint sad_epoca_fkey;
16DROP TABLE IF EXISTS sad_avaliador cascade;
17
18
19/-/*/-*/-/-*/-*/
20package airc.sad.gestenv.cca.models;
21
22import airc.sad.gestenv.epoca.models.EpocaEntity;
23import airc.utils.base.models.EntityBase;
24
25import javax.persistence.*;
26import java.util.Set;
27
28@Entity
29@Table(name = "sad_cca", indexes = {
30 @Index(name="idx_tenant_id_sad_cca", columnList = "tenant_id")
31})
32public class CCAEntity extends EntityBase {
33
34 @Column(name="nome")
35 private String nome;
36
37 @OneToMany(mappedBy = "epoca")
38 private Set<EpocaEntity> epoca;
39
40 @Column(name="apagado")
41 private Boolean apagado;
42
43 public CCAEntity() {
44 }
45
46 public CCAEntity(String nome, Set<EpocaEntity> epoca, Boolean apagado) {
47 this.nome = nome;
48 this.epoca = epoca;
49 this.apagado = apagado;
50 }
51
52 public String getNome() {
53 return nome;
54 }
55
56 public void setNome(String nome) {
57 this.nome = nome;
58 }
59
60 public Set<EpocaEntity> getEpoca() {
61 return epoca;
62 }
63
64 public void setEpoca(Set<EpocaEntity> epoca) {
65 this.epoca = epoca;
66 }
67
68 public Boolean getApagado() {
69 return apagado;
70 }
71
72 public void setApagado(Boolean apagado) {
73 this.apagado = apagado;
74 }
75}
76
77/-*/-*/*-/-/-
78package airc.sad.gestenv.cca.models;
79
80import airc.sad.gestenv.epoca.models.EpocaEntity;
81import airc.sad.gestenv.permissao.models.PermissaoEntity;
82import airc.utils.base.models.EntityBase_;
83
84import javax.persistence.metamodel.SingularAttribute;
85
86public class CCAEntity_ extends EntityBase_ {
87 public static volatile SingularAttribute<CCAEntity, String> nome;
88 public static volatile SingularAttribute<CCAEntity, EpocaEntity> epoca;
89 public static volatile SingularAttribute<CCAEntity, Boolean> apagado;
90}