Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE sad_avaliado (
- id BIGSERIAL NOT NULL,
- tenant_id INT8 NOT NULL,
- funcionario_id BIGSERIAL NOT NULL,
- epoca_id BIGSERIAL NOT NULL,
- cca_id BIGINT NULL,
- avaliador_id BIGSERIAL NOT NULL,
- apagado boolean NOT NULL,
- PRIMARY KEY (id)
- );
- alter table sad_avaliado add constraint sad_funcionario_fkey foreign key (funcionario_id) references sad_funcionario;
- alter table sad_avaliado add constraint sad_epoca_fkey foreign key (epoca_id) references sad_epoca;
- alter table sad_avaliado add constraint sad_cca_fkey foreign key (cca_id) references sad_cca;
- alter table sad_avaliado add constraint sad_avaliador_fkey foreign key (avaliador_id) references sad_avaliador;
- CREATE INDEX idx_tenant_id_sad_avaliado ON sad_avaliado (tenant_id);
- # --- !Downs
- alter table sad_avaliado drop constraint sad_funcionario_fkey;
- alter table sad_avaliado drop constraint sad_epoca_fkey;
- alter table sad_avaliado drop constraint sad_cca_fkey;
- alter table sad_avaliado drop constraint sad_avaliador_fkey;
- DROP TABLE IF EXISTS sad_avaliado cascade;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement