mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
29 lines
526 B
YAML
29 lines
526 B
YAML
|
name: ad_campaigns
|
||
|
|
table: ad_campaigns
|
||
|
|
grain:
|
||
|
|
- ad_campaign_id
|
||
|
|
columns:
|
||
|
|
- name: ad_campaign_id
|
||
|
|
type: number
|
||
|
|
- name: ad_account_id
|
||
|
|
type: number
|
||
|
|
- name: campaign_name
|
||
|
|
type: string
|
||
|
|
- name: channel
|
||
|
|
type: string
|
||
|
|
- name: end_date
|
||
|
|
type: time
|
||
|
|
role: time
|
||
|
|
- name: objective
|
||
|
|
type: string
|
||
|
|
- name: start_date
|
||
|
|
type: time
|
||
|
|
role: time
|
||
|
|
joins:
|
||
|
|
- to: ad_accounts
|
||
|
|
'on': ad_account_id = ad_accounts.ad_account_id
|
||
|
|
relationship: many_to_one
|
||
|
|
- to: accounts
|
||
|
|
'on': ad_account_id = accounts.account_id
|
||
|
|
relationship: many_to_one
|