n951XGf5

1CREATE TABLE IF NOT EXISTS cau.sistema (
2  idsistema public.idnormal NOT NULL,
3  descricao VARCHAR(255) NOT NULL,
4  status public.logico NOT NULL,
5  CONSTRAINT pk_sistema PRIMARY KEY(idsistema)
6) ;
7
8CREATE TABLE IF NOT EXISTS cau.recurso (
9  idrecurso public.idnormal NOT NULL,
10  idsistema public.idnormal NOT NULL,
11  descricao VARCHAR(255) NOT NULL,
12  status public.logico NOT NULL,
13  CONSTRAINT pk_recurso PRIMARY KEY(idrecurso),
14  CONSTRAINT fk_recurso_sistema FOREIGN KEY (idsistema)
15  REFERENCES cau.sistema(idsistema)
16  ON DELETE RESTRICT
17  ON UPDATE RESTRICT
18  NOT DEFERRABLE
19) ;
20
21CREATE TABLE IF NOT EXISTS cau.permissao (
22  idpermissao public.idnormal NOT NULL,
23  idsistema public.idnormal NOT NULL,
24  idrecurso public.idnormal NOT NULL,
25  idusuario public.idnormal NOT NULL,
26  datafinal public.data_hora,
27  datainicial public.data_hora,
28  idusuarioautor usuario.idusuario NOT NULL,
29  CONSTRAINT pk_permissao PRIMARY KEY(idpermissao),
30  CONSTRAINT fk_permissao_sistema FOREIGN KEY (idsistema)
31  REFERENCES cau.sistema(idsistema)
32  ON DELETE RESTRICT
33  ON UPDATE RESTRICT
34  NOT DEFERRABLE,
35  CONSTRAINT fk_permissao_recurso FOREIGN KEY (idrecurso)
36  REFERENCES cau.recurso(idrecurso)
37  ON DELETE RESTRICT
38  ON UPDATE RESTRICT
39  NOT DEFERRABLE,
40  CONSTRAINT fk_permissao_usuario FOREIGN KEY (idusuario)
41  REFERENCES glb.usuario(idusuario)
42  ON DELETE RESTRICT
43  ON UPDATE RESTRICT
44  NOT DEFERRABLE
45) ;
46
47ALTER TABLE cau.sistema OWNER TO 'postgres';
48
49ALTER TABLE cau.recurso OWNER TO 'postgres';
50
51ALTER TABLE cau.permissao OWNER TO 'postgres';