Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can find a simple description of WPL DB Tables here. Also, you can download the DB diagram from the attachments. This KB is as-is.

...

wp_wpl_dbst_types: Type of WPL fields. This type uses in wp_wpl_dbst table. You can create your own field type if needed.
wp_wpl_sort_options: List of available sort options for certain kinds.
wp_wpl_item_categories: Categories for wp_wpl_items table.
wp_wpl_room_types: Rooms Type for properties.
wp_wpl_locationtextsearch: Cached location information of property for using in WPL autocomplete. (Using Google auto-suggest is recommended.)
wp_wpl_setting_categories: Category of WPL settings fields.
wp_wpl_kinds: Available kinds/entities for WPL. 0 means property and 2 means user. By installing Complex or Neighborhood etc. addons you may have more kinds in this table.

Note: We used categories in different tables in wpl WPL so you can check the following descriptions to make it clear.

wp_wpl_dbcat: Categories of the WPL fields (wp_wpl_dbst table). For example, Basic Details, Gallery, Address Map
wp_wpl_property_types: Categories of property types are in this table, Records with parent:0 are categories. For example Residential, Commercial, Land.
wp_wpl_listing_types: Categories of Listing Types, Records with parent:0 are categories. For example Sale, Rental, Vocational.
wp_wpl_item_categories: Categories for wp_wpl_items table. For example gallery, attachment, etc.
wp_wpl_setting_categories: in the WPL backend we have settings, Each setting has a category, for example, Global, Gallery, ..., UI Customizer.

Attachments

Attachments