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)