JDBC Driver for Magento

Build 22.0.8462

CatalogCategoryAttribute

CatalogCategoryAttribute is an auto generated table

Columns

Name Type ReadOnly Description
ApplyTo String False

Apply to value for the element

AttributeCode String False

Code of the attribute.

AttributeId [KEY] Int False

Id of the attribute.

BackendModel String False

Backend model

BackendType String False

Backend type.

DefaultFrontendLabel String False

Frontend label for default store

DefaultValue String False

Default value for the element.

EntityTypeId String False

Entity type id

ExtensionAttributes String False

This is an auto-generated column

FrontendClass String False

Frontend class of attribute

FrontendInput String False

HTML for input element.

FrontendLabels String False

Frontend label for each store

IsComparable String False

The attribute can be compared on the frontend

IsFilterable Bool False

It used in layered navigation

IsFilterableInGrid Bool False

It is filterable in catalog product grid

IsFilterableInSearch Bool False

It is used in search results layered navigation

IsHtmlAllowedOnFront Bool False

The HTML tags are allowed on the frontend

IsRequired Bool False

Attribute is required.

IsSearchable String False

The attribute can be used in Quick Search

IsUnique String False

This is a unique attribute

IsUsedForPromoRules String False

The attribute can be used for promo rules

IsUsedInGrid Bool False

It is used in catalog product grid

IsUserDefined Bool False

Current attribute has been defined by a user.

IsVisible Bool False

Attribute is visible on frontend.

IsVisibleInAdvancedSearch String False

The attribute can be used in Advanced Search

IsVisibleInGrid Bool False

It is visible in catalog product grid

IsVisibleOnFront String False

The attribute is visible on the frontend

IsWysiwygEnabled Bool False

WYSIWYG flag

Note String False

The note attribute for the element.

Options String False

Options of the attribute (key => value pairs for select)

Position Int False

Position

Scope String False

Attribute scope

SourceModel String False

Source model

UsedForSortBy Bool False

It is used for sorting in product listing

UsedInProductListing String False

The attribute can be used in product listing

ValidationRules String False

Validation rules.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AttributeCode_p String

This is an auto-generated column

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462