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 BIGSERIAL,
- 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;
- INSERT INTO public.sad_avaliado(
- id, tenant_id, funcionario_id, epoca_id, cca_id, avaliador_id, apagado)
- VALUES (1, 1, 1, 1, null, 1, false);
- ERROR: null value in column "cca_id" violates not-null constraint
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement