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