Table get terms to filter

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.6

Description

A collection of terms used to provide various types of data-filtering for searches and index listings. It ties in with the various pulldown menus in sideboxes, the primary one being manufacturers_id, which runs specific filters on data shown tied to a selected manufacturer_id.


Table Details

Primary Key

get_term_name

Indexed Fields

None.


Columns

get_term_name Primary Key

The term to allow filtering on.
Type: varchar(255)
Null: No
Default:

get_term_name Primary Key

The term to allow filtering on.
Type: varchar(255)
Null: No
Default:

get_term_table

The table to which the described filtering term applies.
Type: varchar(64)
Null: No
Default:

get_term_name_field Primary Key

The field of the specified table to which filtering should be enabled
Type: varchar(64)
Null: No
Default:


Default Entries

get_term_name: | manufacturers_id | TABLE_MANUFACTURERS | manufacturers_name
get_term_name: | music_genre_id | TABLE_MUSIC_GENRE | music_genre_name
get_term_name: | record_company_id | TABLE_RECORD_COMPANY | record_company_name