---
propel: 
  _attributes: 
    defaultIdMethod: native
    package: plugins.appAdsTrackerPlugin.lib.model    
  app_ads_tracker_campaign: 
    _attributes: 
      phpName: AdsTrackerCampaign
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    app_ads_tracker_platform_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_platform
      foreignReference: id
      onDelete: cascade  
    is_active: 
      type: BOOLEAN
      default: 1
    is_system_default: 
      type: BOOLEAN
      default: 0      
    ads_name: 
      type: VARCHAR
      size: 255
    color: 
      type: VARCHAR
      size: 255
    _uniques: 
      app_ads_tracker_campaign_ads_name: 
        - ads_name            
  app_ads_tracker_platform: 
    _attributes: 
      phpName: AdsTrackerPlatform
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    is_active: 
      type: BOOLEAN
      default: 0
    is_system_default: 
      type: BOOLEAN
      default: false  
    ads_name: 
      type: VARCHAR
      size: 255
    description: 
      type: VARCHAR
      size: 255
    platform_type: 
      type: INTEGER
    color: 
      type: VARCHAR
      size: 255                              
  app_ads_tracker_list: 
    _attributes: 
      phpName: AdsTrackerList
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    app_ads_tracker_campaign_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_campaign
      foreignReference: id
      onDelete: cascade
    app_ads_tracker_platform_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_platform
      foreignReference: id
      onDelete: cascade  
    is_active: 
      type: BOOLEAN
      default: 1
    is_system_default: 
      type: BOOLEAN
      default: 0    
    ads_group: 
      type: VARCHAR
      size: 255
    ads_name: 
      type: VARCHAR
      size: 255
    url: 
      type: VARCHAR
      size: 255
    hash: 
      type: VARCHAR
      size: 255  
    url_hash: 
      type: VARCHAR
      size: 255     
    is_plugin: 
      type: BOOLEAN
      default: 0
    plugin_name: 
      type: VARCHAR
      size: 255
  app_ads_tracker_entering: 
    _attributes: 
      phpName: AdsTrackerEntering
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    app_ads_tracker_list_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_list
      foreignReference: id
      onDelete: cascade            
    ads_entering: 
      type: INTEGER      
  app_ads_tracker_order: 
    _attributes: 
      phpName: AdsTrackerOrder
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    order_id: 
      type: INTEGER
      foreignTable: st_order
      foreignReference: id
      onDelete: setnull
    app_ads_tracker_list_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_list
      foreignReference: id
      onDelete: setnull  
    app_ads_tracker_campaign_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_campaign
      foreignReference: id
      onDelete: setnull
    app_ads_tracker_platform_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_platform
      foreignReference: id
      onDelete: setnull
    order_ads_cookie: 
      type: LONGVARCHAR
    order_cost_brutto: 
      type: DECIMAL
      size: 10
      scale: 2          
    order_ads_cookie: 
      type: LONGVARCHAR                 
    order_ads_full_path: 
      type: VARCHAR
      size: 255
    order_last_ads: 
      type: VARCHAR
      size: 255  
    order_ads_entering:       
      type: INTEGER
    order_ads_conversion: 
      type: VARCHAR
      size: 255
    order_first_ads_entering: 
      type: timestamp
    order_days_to_purchase: 
      type: INTEGER
    order_cookie_data: 
      type: LONGVARCHAR  
    order_remote_address_data: 
      type: LONGVARCHAR
    order_merge_data: 
      type: LONGVARCHAR    
  app_ads_tracker_remote_address: 
    _attributes: 
      phpName: AdsTrackerRemoteAddress
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    app_ads_tracker_list_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_list
      foreignReference: id
      onDelete: cascade            
    url: 
      type: LONGVARCHAR    
    remote_address: 
      type: VARCHAR
      size: 255      
    hash: 
      type: LONGVARCHAR
    cookie: 
      type: LONGVARCHAR
    cookie_ads_hash:
      type: VARCHAR
      size: 255
    ads_hash_control: 
      type: VARCHAR
      size: 255              
  app_ads_tracker_debug: 
    _attributes: 
      phpName: AdsTrackerDebug
    created_at: 
      type: timestamp
    updated_at: 
      type: timestamp
    id: 
      type: INTEGER
      primaryKey: true
      required: true
      autoIncrement: true
    app_ads_tracker_list_id: 
      type: INTEGER
      foreignTable: app_ads_tracker_list
      foreignReference: id
      onDelete: cascade            
    url: 
      type: LONGVARCHAR
    referrer: 
      type: LONGVARCHAR  
    browser: 
      type: LONGVARCHAR
    ip: 
      type: VARCHAR
      size: 255      
    hash: 
      type: LONGVARCHAR
    cookie: 
      type: LONGVARCHAR
    cookie_ads_hash:
      type: VARCHAR
      size: 255  
    ads_hash_control: 
      type: VARCHAR
      size: 255