Table Data dictionary report - system_report_permissions

Generated: 2018-10-18 8:08:32 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table to control report permissions when Report security is enabled in Company settings or User settings

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('system_report_permissions_id_seq'::regclass) Unique identifier
reportname character varying(240) No No Report file name
can_print boolean No No Permission to print report; FALSE = No permission TRUE = Has permission
can_preview boolean No No Permission to preview report; FALSE = No permission TRUE = Has permission
can_export boolean No No Permission to export report; FALSE = No permission TRUE = Has permission
can_email boolean No No Permission to email report; FALSE = No permission TRUE = Has permission
default_email01 boolean No No Not used
default_email02 boolean No No Not used
default_email03 boolean No No Not used
default_email04 boolean No No Not used
default_email05 boolean No No Not used
default_email06 boolean No No Not used
default_email07 boolean No No Not used
default_email08 boolean No No Not used
default_email09 boolean No No Not used
user_id integer No No Identifier from system_users_base.id related to this record, blank = all users

Constraints

Name Type Definition Comment
bve_report_control_pkey Primary key (id)
system_report_permissions_user_id_fkey Foreign key (user_id) REFERENCES public.system_users_base (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin3 LTS by BigSQL