263 lines
5.8 KiB
YAML
263 lines
5.8 KiB
YAML
---
|
|
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 |