LauKnbTN

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