show tables:
apxDBmySQL Object ( [dbhost] => 10.0.0.3:50002 [dbuser] => workernote [dbpass] => cv2025MDXfr? [db] => arcoplastar [linkid] => [result] => [sub_result] => [numrows] => [affrows] => [seek] => [object] => [array] => [free] => [res] => [error] => [setlowerkeynames] => )
Array ( [0] => Array ( [FIELD] => id [TYPE] => bigint(11) unsigned [NULL] => NO [KEY] => PRI [DEFAULT] => [EXTRA] => auto_increment ) [1] => Array ( [FIELD] => nr [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [2] => Array ( [FIELD] => enabled [TYPE] => enum('Y','N') [NULL] => YES [KEY] => [DEFAULT] => Y [EXTRA] => ) [3] => Array ( [FIELD] => nrzusatz [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [4] => Array ( [FIELD] => matchcode [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [5] => Array ( [FIELD] => kategorie [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [6] => Array ( [FIELD] => bezeichnung1 [TYPE] => varchar(200) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [7] => Array ( [FIELD] => bezeichnung2 [TYPE] => varchar(200) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [8] => Array ( [FIELD] => bezeichnung3 [TYPE] => varchar(200) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [9] => Array ( [FIELD] => bezeichnung4 [TYPE] => varchar(200) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [10] => Array ( [FIELD] => bezeichnung5 [TYPE] => varchar(200) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [11] => Array ( [FIELD] => gebindefaktor [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [12] => Array ( [FIELD] => verkaufseinheit [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [13] => Array ( [FIELD] => laenge [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [14] => Array ( [FIELD] => breite [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [15] => Array ( [FIELD] => hoehe [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [16] => Array ( [FIELD] => durchmesser [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [17] => Array ( [FIELD] => gewicht [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => 0 [EXTRA] => ) [18] => Array ( [FIELD] => gewichtseinheit [TYPE] => varchar(20) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [19] => Array ( [FIELD] => erloesgruppennr [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [20] => Array ( [FIELD] => warengruppenr [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [21] => Array ( [FIELD] => warenuntergruppenr [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [22] => Array ( [FIELD] => katalogvk [TYPE] => varchar(20) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [23] => Array ( [FIELD] => katalogseitevk [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [24] => Array ( [FIELD] => kundengruppe [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [25] => Array ( [FIELD] => bildname_top [TYPE] => varchar(250) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [26] => Array ( [FIELD] => bildname_diagonal [TYPE] => varchar(250) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [27] => Array ( [FIELD] => rawmatchcode [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [28] => Array ( [FIELD] => farbcode [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [29] => Array ( [FIELD] => variante [TYPE] => varchar(40) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [30] => Array ( [FIELD] => vkpreis1 [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [31] => Array ( [FIELD] => vkpreis2 [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [32] => Array ( [FIELD] => vkpreis3 [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [33] => Array ( [FIELD] => vkpreis4 [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [34] => Array ( [FIELD] => vkpreis5 [TYPE] => double [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) [35] => Array ( [FIELD] => themaid [TYPE] => int(11) [NULL] => YES [KEY] => [DEFAULT] => [EXTRA] => ) )
Array ( [0] => nr [1] => enabled [2] => nrzusatz [3] => matchcode [4] => bezeichnung1 [5] => bezeichnung2 [6] => bezeichnung3 [7] => bezeichnung4 [8] => bezeichnung5 [9] => gebindefaktor [10] => verkaufseinheit [11] => laenge [12] => breite [13] => hoehe [14] => durchmesser [15] => gewicht [16] => gewichtseinheit [17] => erloesgruppennr [18] => warengruppenr [19] => warenuntergruppenr [20] => katalogvk [21] => katalogseitevk [22] => kundengruppe [23] => bildname_top [24] => bildname_diagonal [25] => rawmatchcode [26] => farbcode [27] => variante [28] => vkpreis1 [29] => vkpreis2 [30] => vkpreis3 [31] => vkpreis4 [32] => vkpreis5 [33] => themaid )