Overview  Object type    Table  Help 
 PREV Table    NEXT Table   FRAMES     NO FRAMES    

Table i3geousr_papeis

Physical Name:
i3geousr_papeis

Constraint:


Cadastro de papéis que permitem definir as operações

Attribute Summary
PK FK Logical Name Physical Name Type UNIQUE NOT NULL
    id_papel  id_papel  integer  UNIQUE  NOT NULL 
    nome  nome  text  UNIQUE  NOT NULL 
    descricao  descricao  text     

Foreign Key
Attribute Referenced Table Referenced Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child

Referenced Key
Attribute Table Foreign Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child
id_papel  i3geousr_operacoespapeis  id_papel  RESTRICT  RESTRICT  1  1..n 
id_papel  i3geousr_papelusuario  id_papel  RESTRICT  RESTRICT  1  1..n 

Complex Unique Key
 

Index Summary
Index Name Type UNIQUE

Attribute Detail

id_papel

id_papel

UNIQUE : TRUE
NOT NULL : TRUE
Type : integer
AUTO INCREMENT : FALSE
Default Value :
Constraint :

nome

nome

UNIQUE : TRUE
NOT NULL : TRUE
Type : text
AUTO INCREMENT : FALSE
Default Value :
Constraint :

descricao

descricao

UNIQUE : FALSE
NOT NULL : FALSE
Type : text
AUTO INCREMENT : FALSE
Default Value :
Constraint :

Overview  Object type    Table  Help 
 PREV Table    NEXT Table   FRAMES     NO FRAMES