test

Tables (27)

ox_account_user_assoc

  • account_id — mediumint(9) — Foreign key → ox_accounts.account_id — NOT NULL
  • user_id — mediumint(9) — Foreign key → ox_users.user_id — NOT NULL

ox_accounts

  • account_id — mediumint(9) — NOT NULL

ox_ad_category_assoc

  • ad_category_assoc_id — int(10) — Foreign key → ox_banners.bannerid — NOT NULL
  • category_id — int(10) — Foreign key → ox_category.category_id — NOT NULL
  • ad_id — int(10) — NOT NULL

ox_ad_zone_assoc

  • ad_zone_assoc_id — int(10) — Foreign key → ox_banners.bannerid — NOT NULL
  • zone_id — mediumint(9) — Foreign key → ox_zones.zoneid
  • ad_id — mediumint(9)

ox_affiliates

  • affiliateid — mediumint(9) — NOT NULL
  • agencyid — mediumint(9) — Foreign key → ox_agency.agencyid — NOT NULL
  • account_id — mediumint(9) — Foreign key → ox_accounts.account_id

ox_agency

  • agencyid — mediumint(9) — NOT NULL
  • account_id — mediumint(9) — Foreign key → ox_accounts.account_id
  • wpadmin_user_id — int(11)
  • wp_admin_team_name — varchar(100) — Foreign key → ox_client_admin.wp_admin_team_name — WP 담당 부서
  • review_id — int(11) — ox_tg_review id
  • file_id — int(11) — 사업자 등록증 file_id

ox_app_campaigns

  • app_campaign_id — int(11) — NOT NULL — 앱 캠페인 고유번호

ox_banner_creatives

  • creativeid — int(11) — Primary key — NOT NULL
  • bannerid — int(11) — Foreign key → ox_banners.bannerid — NOT NULL

ox_banners

  • bannerid — mediumint(9) — NOT NULL
  • campaignid — mediumint(9) — Foreign key → ox_app_campaigns.app_campaign_id — NOT NULL

ox_billing

  • billing_id — int(11) — NOT NULL
  • account_id — mediumint(9) — Foreign key → ox_accounts.account_id — NOT NULL
  • user_id — mediumint(9) — Foreign key → ox_users.user_id — NOT NULL

ox_campaign_groups

  • campaign_group_id — mediumint(9) — Foreign key → ox_campaigns.campaignid — NOT NULL
  • clientid — mediumint(9) — Foreign key → ox_clients.clientid — NOT NULL

ox_campaign_library

  • campaign_library_id — int(11) — NOT NULL — 캠페인 라이브러리 고유번호
  • client_id — int(11) — Foreign key → ox_clients.clientid — NOT NULL — 광고주 ID

ox_campaigns

  • campaignid — mediumint(9) — Foreign key → ox_app_campaigns.app_campaign_id — NOT NULL
  • clientid — mediumint(9) — Foreign key → ox_clients.clientid — NOT NULL

ox_category

  • category_id — int(10) — NOT NULL
  • name — varchar(255)

ox_client_admin

  • clientid — mediumint(9) — Foreign key → ox_clients.clientid — NOT NULL
  • user_id — mediumint(9) — Foreign key → ox_users.user_id — NOT NULL
  • wp_admin_team_name — varchar(100) — WP 담당 부서
  • ae_admin_user_id — mediumint(9)
  • am_admin_user_id — mediumint(9)

ox_clients

  • clientid — mediumint(9) — NOT NULL
  • agencyid — mediumint(9) — Foreign key → ox_agency.agencyid — NOT NULL
  • account_id — mediumint(9) — Foreign key → ox_accounts.account_id
  • review_id — int(11) — ox_tg_review id
  • file_id — int(11) — 사업자 등록증 file_id

ox_creative_rtb_status

  • creative_status_id — int(10) — NOT NULL — Uniq Key
  • client_id — int(11) — 광고주 아이디
  • creative_id — int(11) — Foreign key → ox_creatives.creativeid — 소재 아이디

ox_creative_rtb_status_history

  • creative_status_history_id — int(10) — NOT NULL — Uniq Key
  • creative_status_id — int(10) — Foreign key → ox_creative_rtb_status.creative_status_id — NOT NULL — Uniq Key

ox_creatives

  • creativeid — int(11) — Foreign key → ox_banner_creatives.creativeid — NOT NULL
  • clientid — mediumint(9) — Foreign key → ox_clients.clientid — NOT NULL
  • ciid — int(11) — Foreign key → ox_tg_ci_images.ciid

ox_inspection_creatives

  • inspection_creatives_id — bigint(20) — NOT NULL
  • creativeid — int(10) — Foreign key → ox_creatives.creativeid — NOT NULL

ox_placement_zone_assoc

  • placement_zone_assoc_id — int(10) — Foreign key → ox_campaigns.campaignid — NOT NULL
  • zone_id — mediumint(9) — Foreign key → ox_zones.zoneid
  • placement_id — mediumint(9)

ox_tg_ci_images

  • ciid — int(11) — NOT NULL
  • clientid — int(11) — Foreign key → ox_clients.clientid — NOT NULL

ox_tg_reviews

  • reviewid — int(11) — NOT NULL
  • clientid — int(11) — Foreign key → ox_clients.clientid — NOT NULL
  • review_userid — int(11) — NOT NULL

ox_users

  • user_id — mediumint(9) — NOT NULL

ox_zone_link_campaign

  • link_id — bigint(20) — NOT NULL — auto increment table id
  • zone_id — mediumint(9) — Foreign key → ox_zones.zoneid — NOT NULL — ox_zones.zoneid
  • campaign_id — mediumint(9) — Foreign key → ox_campaigns.campaignid — NOT NULL — ox_campaigns.campaignid

ox_zone_link_campaign_audit

  • audit_id — bigint(20) — NOT NULL — auto increment table id
  • campaign_id — mediumint(9) — Foreign key → ox_campaigns.campaignid — NOT NULL — ox_campaigns.campaignid
  • user_id — mediumint(9) — Foreign key → ox_users.user_id — NOT NULL — ox_users.user_id

ox_zones

  • zoneid — mediumint(9) — NOT NULL
  • affiliateid — mediumint(9) — Foreign key → ox_affiliates.affiliateid