Table of Contents

Table global\_permission

Remarks

This table defines the global permissions of a profile.

Schema

Name Type Not Null Primary Key Foreign Key Remarks
:———:———:————-:—————-:—————-:————
id_global_permission integer X X This is the primary key of the table.
permission character varying(255) X It corresponds to a java enumeration (VIEW_PROJECT, EDIT_PROJECT, CREATE_PROJECT, CHANGE_PHASE, VIEW_ADMIN, MANAGE_USER, MANAGE_UNIT, REMOVE_FILE, VIEW_ACTIVITYINFO or VALID_AMENDEMENT). It indicates that the the profile related has this permission.
id_profile integer X profile(id_profile) This is a foreign key to the table profile.

Diagram