CompanyFilter

The table below describes the CompanyFilter table.

This is a virtual table, and is linked to the Company table (see Company).

None of the columns in this table are updatable.

This table contains the following foldable columns:

  • Filter_Index
  • Id
  • Filter_Condition_Type
  • Filter_Field
  • Filter_Value

This table does not contain Return Primary Key columns.

Column Name SQL Type Nullable

Filter_Index

Primary Key
SQL_INTEGER(unsigned) False

Id

Foreign Key linked to column Id in Company table
SQL_INTEGER(unsigned) False

Filter_Condition_Type

SQL_VARCHAR(255) True

Filter_Field

SQL_VARCHAR(255) False

Filter_Value

SQL_VARCHAR(255) False