Name | Data type | Not Null? | Primary key? | Default | Comment |
---|---|---|---|---|---|
id | integer | Yes | Yes | nextval('system_filters_id_seq'::regclass) | |
window | character varying(100) | No | No | Where filter is available | |
name | character varying(100) | No | No | Name of filter | |
user | character varying(13) | No | No | User that is assigned the filter. If blank than it is a company wide filter. | |
inmenu | boolean | No | No | Added to main menu TRUE = Yes FALSE = No | |
filter_state | json | No | No | What filters are set | |
table_state | json | No | No | What columns are set, the widths and locations |
Name | Type | Definition | Comment |
---|---|---|---|
bve_filter_pkey | Primary key | (id) |