H0LGhuVx

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