adwitt
Tables (23)
adwitt_ad_group_base
- campaign_id — character-varying(25) — Primary key — NOT NULL
- ad_group_id — character-varying(25) — Primary key — NOT NULL
- old_ad_group_id — character-varying(25)
- creative_spec — text
- crop_spec — text
- tracking_id — text
- appevent_id — text
- collection_info — text
- platform_spec — text
- applink_treatment — character-varying(2000)
- adgroup_insta — character-varying(25)
- created_time — timestamp
adwitt_business
- business_id — character-varying(200)
- name — character-varying(100)
adwitt_business_adaccount
- business_id — character-varying(32)
- accountid — bigint
adwitt_fb_adaccount
- accountid — bigint — Primary key — NOT NULL
- currency — character-varying(16)
- name — character-varying(100)
- timezoneoffsethoursutc — integer — NOT NULL
- business_country_code — character-varying(16)
- balance — bigint
- timezone_name — character-varying(50)
- created_time — date
- use_limitfunction — character(5)
- industry_code — character-varying(10)
- isdburl — character-varying(10)
- is_active — boolean
adwitt_fb_adaccount_member
- fapmemberid — bigint — Foreign key → adwitt_member.id
- accountid — bigint — Foreign key → adwitt_fb_adaccount.accountid
- status — integer — NOT NULL
adwitt_fb_page2
- pageid — bigint
- name — character-varying(200)
- url — character-varying(512)
- picture — character-varying(512)
- type — integer
- is_game — character-varying(15)
- google_play — character-varying(512)
- itunes — character-varying(512)
- fb_canvas — character-varying(512)
adwitt_fb_page_adaccount
- accountid — bigint
- pageid — bigint
- productid — character-varying(50)
- name — character-varying(200)
adwitt_fb_page_member
- fapmemberid — bigint
- pageid — bigint
adwitt_industry
- code — character-varying(10)
- industry_name — character-varying(100)
- parent_code — character-varying(10)
adwitt_insight_metric_v1
- id — bigint
- code — character-varying(50)
- name — character-varying(250)
- xls_code — character-varying(250)
- sort_code — bigint
- roas — character-varying(10)
adwitt_login
- id — integer — NOT NULL
- adwitt_id — character-varying(50) — NOT NULL
- member_name — character-varying(100)
- ip_address — character-varying(30) — NOT NULL
- login_time — timestamp — NOT NULL
- login_status — boolean
adwitt_make_ad
- campaign_id — character-varying(25) — Primary key — NOT NULL
- adset_id — character-varying(25) — Primary key — NOT NULL
- ad_group_id — character-varying(25) — Primary key — NOT NULL
- old_ad_group_id — character-varying(25)
- ad_id — character-varying(25)
- blank_comment — character-varying(35) — haracter-varying(35) NUL
- creative_change_flg — boolean — NOT NULL
- crop_spec — text
- created_time — timestamp
adwitt_make_ad_error
- campaign_id — character-varying(25) — Primary key — NOT NULL
- ad_set_id — character-varying(25) — Primary key — NOT NULL
- ad_group_id — character-varying(25) — Primary key — NOT NULL
- ad_error_spec — text
- creative_error_spec — text
- error_user_title — text
- error_user_msg — text
- execute_cnt — integer
- created_time — timestamp
adwitt_make_adset
- campaign_id — character-varying(25) — Primary key — NOT NULL
- adset_id — character-varying(25) — Primary key — NOT NULL
- created_time — timestamp
- seq — bigint
adwitt_make_campaign
- account_id — character-varying(25) — Primary key — NOT NULL
- campaign_id — character-varying(25) — Primary key — NOT NULL
- adtype — smallint — NOT NULL
- catalog_id — character-varying(25)
- app_id — character-varying(25)
- page_id — character-varying(25) — NOT NULL
- created_time — timestamp
adwitt_member
- id — bigint — Primary key — NOT NULL
- name — character-varying(50) — NOT NULL
- permitnumber1 — character-varying(3)
- permitnumber2 — character-varying(2)
- permitnumber3 — character-varying(5)
- juminnumber1 — character-varying(6)
- juminnumber2 — character-varying(7)
- tel1 — character-varying(4)
- tel2 — character-varying(4)
- tel3 — character-varying(4)
- zipcode1 — character-varying(3)
- zipcode2 — character-varying(3)
- addr1 — character-varying(100)
- addr2 — character-varying(100)
- email1 — character-varying(30)
- email2 — character-varying(30)
- homepage — character-varying(50)
- facebookpage — text
- chargename — character-varying(20)
- chargetel1 — character-varying(4)
- chargetel2 — character-varying(4)
- chargetel3 — character-varying(4)
- chargehp1 — character-varying(4)
- chargehp2 — character-varying(4)
- chargehp3 — character-varying(4)
- chargeemail1 — character-varying(18)
- chargeemail2 — character-varying(18)
- chargeclient — character(18)
- advertisertype — character(1) — NOT NULL
- state — character(1)
- hp1 — character-varying(4)
- hp2 — character-varying(4)
- hp3 — character-varying(4)
- password — character-varying(50)
- regdate — date
- udtdate — date
- facebookpageid — text
- adwitt_id — character-varying(50)
- eng_name — character-varying(30)
- eng_addr1 — character-varying(100)
- eng_addr2 — character-varying(100)
- fee — integer
- agencyid — bigint
- taximage — character-varying(40)
- balance — integer — NOT NULL
- batchperiodpermin — integer — NOT NULL
- clientid — text
- contect_phone — character-varying(64)
- contect_email — character-varying(128)
- brnumber — character-varying(128)
- expiration_date — date
- block_status — smallint — NOT NULL
- commission_rate — real — NOT NULL
- commission_rate_month — character-varying(16)
- commission_rate_next — real — NOT NULL
- commission_rate_next_month — character-varying(16)
- dashboard_type — character-varying(16)
- locale — character(5)
- business_id — character-varying(32)
- user_accountid — character-varying(100)
- … +8
adwitt_page_token
- user_id — character-varying(30) — Primary key — NOT NULL
- page_id — character-varying(25) — Primary key — NOT NULL
- page_token — text
- create_time — timestamp
adwitt_permission
- fapmemberid — bigint — Foreign key → adwitt_member.id — NOT NULL
- permissiontype — integer — NOT NULL
adwitt_report
- id — integer — Primary key — NOT NULL
- member_id — bigint
- adaccount_id — bigint
- report_data — json
- report_email — json
- send_mail_chk — boolean
- save_report_date — date
- report_name — character-varying(255)
- send_mail_address — character-varying(30)
adwitt_report_mail_sendlist
- id — integer — Primary key — NOT NULL
- complete_mail_date — character-varying
- setted_mail_time — character-varying
- email — character-varying
- email_cc — character-varying
- report_id — bigint
- status — report_email_status_type
- create_time — timestamp(6)
adwitt_restore
- id — bigint — NOT NULL
- adaccount — bigint
- email — character-varying(100)
- step — character-varying(20)
- level1 — text
- level2 — text
- level3 — text
- level4 — text
- level5 — text
- delete_yn — character-varying(2)
- last_level — character-varying(20)
adwitt_save_column2
- id — bigint
- account_id — bigint
- email — character-varying(30)
- save_id — character-varying(10)
- save_data — text
- save_name — text
- regdate — timestamp
- save_roas — character-varying(200)
- radio_id — character-varying(30)
- save_spec — text
- save_insight_spec — text
- attr_window — character-varying(2)
adwitt_save_column_renew
- id — bigint
- account_id — bigint
- email — character-varying(30)
- adtype — character-varying(30)
- save_name — text
- save_insight_spec — text
- status — character-varying(20)
- default_flag — character-varying(30)
- regdate — timestamp
- spend_limit — character-varying(6)