Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

productgroup

node_id primary auto increment
ID
INT (11)
R+W
no
fieldset
"base"
node_code
Kategorie-Code
TEXT (63)
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6"
}
node_idfather
Übergeordnete Kategorie
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
ngr_id
Katalog
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
lft
Lft
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
rgt
Rgt
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
node_path
Kategorie-Pfad
TEXT
R
no
drvd_select
excdb_nstgrp_nodes.i18n_node_path_DE
fieldset
"base"
formCfg
{
    "editMode": 0
}
i18n_node_path_DE
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0,
    "fullSearch": true
}
node_name primaryDisplay
Kategorie-Name
TEXT
R
no
drvd_select
excdb_nstgrp_nodes.i18n_node_name_DE
fieldset
"base"
formCfg
{
    "cssLayout": "col-6",
    "mandatory": true
}
i18n_node_name_DE
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_desc
Kategorie-Beschreibung (alt)
TEXT
R
no
drvd_select
excdb_nstgrp_nodes.i18n_node_desc_DE
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "editMode": 0
}
i18n_node_desc_DE
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_desc_long
Kategorie-Langbeschreibung (alt)
TEXT
R
no
drvd_select
excdb_nstgrp_nodes.i18n_node_desc_long_DE
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "editMode": 0
}
i18n_node_desc_long_DE
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_keywords
Kategorie-Keywords
TEXT
R
no
drvd_select
excdb_nstgrp_nodes.i18n_node_keywords_DE
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "editMode": 0
}
i18n_node_keywords_DE
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_children
Anz. Unterkategorien
INT
R
no
drvd_select
(excdb_nstgrp_nodes.rgt - excdb_nstgrp_nodes.lft - 1)/2
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_isleaf
INT (1)
R
no
drvd_select
IF(excdb_nstgrp_nodes.rgt - excdb_nstgrp_nodes.lft = 1, 1, 0)
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
depth
INT
R
no
drvd_select
(LENGTH(excdb_nstgrp_nodes.i18n_node_path_DE) - LENGTH(REPLACE(excdb_nstgrp_nodes.i18n_node_path_DE, "|", "")) - 1)
fieldset
"base"
formCfg
{
    "editMode": 0
}
node_image
Bild
TEXT (63)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
active
Aktiv
INT (1)
R+W
no
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64
}
formCfg
{
    "type": "checkbox"
}
node_insert_time
DATETIME
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
node_insert_user
TEXT (127)
R+W
yes
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
node_update_time
DATETIME
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
node_update_user
TEXT (127)
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
ngr_namespace
Namespace
TEXT (32)
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
ngr_label
Label (Baum)
TEXT (63)
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
ngr_name
Set-Name
TEXT
R
no
table
[ "excdb_nstgrp" ]
drvd_select
excdb_nstgrp.i18n_ngr_name_DE
fieldset
"base"
listCfg
{
    "viewMode": 1,
    "fullSearch": false,
    "depends_on": "ngr_id"
}
formCfg
{
    "mandatory": true,
    "cssLayout": "col-6",
    "editMode": 0
}
i18n_ngr_name_DE
TEXT (127)
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
ngr_desc
TEXT
R
no
table
[ "excdb_nstgrp" ]
drvd_select
excdb_nstgrp.i18n_ngr_desc_DE
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
i18n_ngr_desc_DE
TEXT
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
ngr_addfields
TEXT
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
ngr_additemfields
TEXT
R+W
no
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
ngr_plugin
Plugin (Baum)
TEXT (127)
R+W
yes
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "dataStreamCall": {
            "method": "package_getOptions"
        }
    },
    "editMode": 0
}
ngr_ecms_pagealias
DATA
R+W
yes
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
ngr_ecms_xdata
DATA
R+W
yes
table
[ "excdb_nstgrp" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
dynx__externalid_shopware_1_de
INT (11)
R+W
yes
fieldset
"base"
dynx__externalid_shopware_2_de
INT (11)
R+W
yes
fieldset
"base"
cnt_item_FullPath
INT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
cnt_item_NodeOnly
INT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_plugin
Plugin
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_filter_attr_inherit
Filter-Vererbung
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_filter_attr_own
Kategorie-Filter-Attribute
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_mda_inherit
MDA-Vererbung
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_mda_own
Kategorie-MDAs
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_vgroup_inherit
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_vgroup_own
Varianten Gruppierung
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_external_id
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
node_xc__label
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_2_direct
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_2_total
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_1_direct
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_1_total
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_2_state_direct
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_2_state_total
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_1_state_direct
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
prd_counter_1_state_total
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
drvd_depth
Depth
INT
R
no
table
[ "parent" ]
drvd_select
(COUNT(DISTINCT parent.node_id) - 1)