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