| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| sys_function_privilege | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| pri_role_id | SmallInt | Papel |
| ||||
|
| pri_function_id | SmallInt | Funcionalidade |
| ||||
| pri_value | SmallInt | Valor do Privilégio:\n1=query;\n2=update;\n4=create;\n8=delete;\n\nPossible values and permissions:\n(1,3,5,7,9,11,13,15) => query;\n(2,3,6,7,10,11,14,15) => update;\n(4,5,6,7,12,13,14,15) => create;\n(8,9,10,12,13,14,15) => delete;\n | ||||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_sys_privilege_sys_function | URX_PUBLIC.sys_function_privilege | pri_function_id | ||
| ix_sys_privilege_sys_role | URX_PUBLIC.sys_function_privilege | pri_role_id | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_sys_privilege_sys_function | URX_PUBLIC.sys_function | URX_PUBLIC.sys_function_privilege | fun_id | pri_function_id |
| fk_sys_privilege_sys_role | URX_PUBLIC.sys_role | URX_PUBLIC.sys_function_privilege | rol_id | pri_role_id |
| Parent Relations (none) |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| diagramA |