Files
2025-03-12 17:06:23 +01:00

72 lines
1.8 KiB
YAML

propel:
_attributes: { package: plugins.stTaskSchedulerImportPlugin.lib.model }
st_task_scheduler_import_category_mapping:
_attributes: { phpName: stTaskSchedulerImportCategoryMapping }
id:
type: INTEGER
primaryKey: true
required: true
autoIncrement: true
import_hash_id:
type: BIGINT
required: true
category_path:
type: VARCHAR
size: 256
required: true
category_id:
type: INTEGER
required: false
foreignTable: st_category
foreignReference: id
onDelete: cascade
price_margin:
type: DECIMAL
size: 10
scale: 2
price_margin_type:
type: CHAR
size: 1
is_excluded:
type: BOOLEAN
default: false
required: true
_uniques:
category_path_idx:
- import_hash_id
- category_path
st_task_scheduler_import_product:
_attributes: { phpName: stTaskSchedulerImportProduct }
import_hash_id:
type: BIGINT
required: true
primaryKey: true
product_id:
type: INTEGER
required: true
foreignTable: st_product
foreignReference: id
onDelete: cascade
primaryKey: true
available:
type: BOOLEAN
required: true
default: true
st_task_scheduler_import_preloaded_data:
_attributes: { phpName: stTaskSchedulerImportPreloadedData }
import_hash_id:
type: BIGINT
required: true
primaryKey: true
data_id:
type: VARCHAR
size: 64
required: true
primaryKey: true
data:
type: MEDIUMTEXT
phpType: array
required: true