Table Data dictionary report - system_filters

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

Tables for saved filters

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('system_filters_id_seq'::regclass) Unique identifier
window character varying(100) No No Spire list screen for this record
name character varying(100) No No Name or description of filter as set by user
inmenu boolean No No Display on main menu flag; FALSE = No TRUE = Yes
filter_state json No No Filter criteria
table_state json No No Column settings
save_table boolean Yes No Save this settings flag; FALSE = No TRUE = Yes
user_id integer No No Identifier from system_users_base.id related to this record, blank = all users

Constraints

Name Type Definition Comment
bve_filter_pkey Primary key (id)
system_filters_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