MaterialMarktplace

Tabelle: material_marktplace
Domain: MaterialMarktplace · com.reybex.domain.wws.marktplace
Modul: OMP

Partner-Hinweise

• Daten liegen mandantengetrennt – bei SELECT fast immer tenant_id = :mandant setzen (Spalte ggf. TenantId in älteren Tabellen).
• Schreibende SQL (INSERT/UPDATE/DELETE) nur in abgestimmten Export-/Report-Jobs (Transaktion BAS23) und nie ohne Freigabe durch reybex.
• Für API-Integrationen bevorzugt die API statt direkter DB-Zugriffe.

→ Beispiel-SQLs (BAS23)

Primärschlüssel

• id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
id	bigint auto_increment	Ja	—	Primärschlüssel (Domain: id)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
material_id	bigint	Nein	—	Fremdschlüssel → material
marktplace_id	bigint	Nein	—	Fremdschlüssel → marktplace
material_template_id	bigint	Ja	—	Fremdschlüssel → material template
material_name	varchar(300) charset utf8mb4	Ja	—	Domain-Feld materialName
material_description	longtext charset utf8mb4	Ja	—	Domain-Feld materialDescription
upload_status	varchar(5) charset utf8mb4	Nein	—	upload status
bullet_point1	varchar(999) charset utf8mb4	Ja	—	Domain-Feld bulletPoint1
bullet_point2	varchar(999) charset utf8mb4	Ja	—	Domain-Feld bulletPoint2
bullet_point3	varchar(999) charset utf8mb4	Ja	—	Domain-Feld bulletPoint3
bullet_point4	varchar(999) charset utf8mb4	Ja	—	Domain-Feld bulletPoint4
bullet_point5	varchar(999) charset utf8mb4	Ja	—	Domain-Feld bulletPoint5
search_terms	text charset utf8mb4	Ja	—	Domain-Feld searchTerms
is_highlighted	smallint	Ja	0	Boolean: Highlighted
is_shipping_free	smallint	Ja	0	Boolean: Shipping Free
is_only_sellable_with_positive_stock	smallint	Ja	0	Boolean: Only Sellable With Positive Stock
is_active	smallint	Nein	0	Aktiv-Flag
ebay_picture_attribute_id	bigint	Ja	—	Fremdschlüssel → ebay picture attribute
ebay_listing_days	int	Ja	—	Domain-Feld ebayListingDays
is_in_marktplace	smallint	Ja	0	Boolean: In Marktplace
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
date_created	datetime	Ja	—	Anlagezeitpunkt
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
is_shipping_by_amazon	smallint	Ja	0	Boolean: Shipping By Amazon
is_requestable	smallint	Ja	0	Boolean: Requestable
visibility_id	bigint	Ja	—	Fremdschlüssel → visibility
profile_return_policy_id	bigint	Ja	—	Fremdschlüssel → profile return policy
profile_payment_id	bigint	Ja	—	Fremdschlüssel → profile payment
profile_shipping_id	bigint	Ja	—	Fremdschlüssel → profile shipping
condition_id	bigint	Ja	—	Fremdschlüssel → condition
excluded_customer_groups	varchar(200) charset utf8mb4	Ja	—	Domain-Feld excludedCustomerGroups
marketplace_sku	varchar(100) charset utf8mb4	Ja	—	Domain-Feld marketplaceSku
marketplace_product_id	varchar(100) charset utf8mb4	Ja	—	Domain-Feld marketplaceProductId
stock_carrier_sku	varchar(100) charset utf8mb4	Ja	—	Domain-Feld stockCarrierSku
sub_title	varchar(200) charset utf8mb4	Ja	—	Domain-Feld subTitle
max_process_days	int	Ja	0	Domain-Feld maxProcessDays
is_variant_sync_separated	smallint	Ja	0	Boolean: Variant Sync Separated
last_synchronized_stock	double	Ja	—	Domain-Feld last_synchronized_stock
last_synchronized_date	datetime	Ja	—	Domain-Feld last_synchronized_date
last_synchronized_price	double	Ja	—	Domain-Feld last_synchronized_price
last_synchronized_status	bigint	Ja	—	Domain-Feld last_synchronized_status
material_marketplace_url	varchar(255) charset utf8mb4	Ja	—	Domain-Feld materialMarketplaceUrl
business_price	double(20, 8)	Ja	—	Domain-Feld businessPrice
is_catalog_option	smallint	Ja	0	Domain-Feld isCatalogOption
is_domestic	smallint	Ja	—	Boolean: Domestic
marketplace_brand_id	bigint	Ja	—	Fremdschlüssel → marketplace brand
catalog_id	varchar(20) charset utf8mb4	Ja	—	Fremdschlüssel → catalog
is_gross_price	smallint	Ja	0	Boolean: Gross Price
n11_group_attribute	varchar(50) charset utf8mb4	Ja	—	n11 group attribute
n11_group_item_code	varchar(50) charset utf8mb4	Ja	—	n11 group item code
n11_item_name	varchar(50) charset utf8mb4	Ja	—	n11 item name
is_allow_oversell	smallint	Ja	0	Boolean: Allow Oversell
marketplace_description	longtext charset utf8mb4	Ja	—	Domain-Feld marketplaceDescription
marketplace_confirmation_id	varchar(50)	Ja	—	Domain-Feld marketplaceConfirmationId
seperate_item_marketplace_product_id	varchar(100)	Ja	—	Domain-Feld seperateItemMarketplaceProductId

Fremdschlüssel

Spalte(n)	Referenz
marketplace_brand_id	lt_marketplace_brand (id)
marktplace_id	ltt_marktplace (id)
condition_id	lt_supported_marktplace_material_condition (id)
tenant_id	company (tenant_id)
material_id	material (id)
profile_return_policy_id	ltt_ebay_seller_profile (id)
profile_payment_id	ltt_ebay_seller_profile (id)
profile_shipping_id	ltt_ebay_seller_profile (id)
material_template_id	ws_description_template (id)

Indizes / Unique

Name	Unique	Spalten
unique	Nein	tenant_id, material_id, marktplace_id