ads

Tables (17)

ad_collection

  • ad_collection_id — BIGINT
  • collection_type — VARCHAR(255)
  • name — VARCHAR(255)
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • ad_group_status — VARCHAR(255)
  • business_group_id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ad_group

  • ad_group_id — BIGINT
  • ad_collection_id — BIGINT — NOT NULL
  • campaign_id — BIGINT — NOT NULL
  • target_id — BIGINT — NOT NULL
  • daily_budget — BIGINT

ad_group_budget

  • id — BIGINT
  • ad_group_id — BIGINT — NOT NULL
  • version — BIGINT
  • amount — BIGINT
  • deposit_sum — BIGINT
  • withdraw_sum — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

bottom_sheet_ad

  • bottom_sheet_ad_id — BIGINT
  • ad_collection_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • ad_status — VARCHAR(255)
  • brand_name — VARCHAR(255)
  • background_image — TEXT
  • title — VARCHAR(255)
  • sub_title — VARCHAR(255)
  • cta_button_text — VARCHAR(255)
  • cta_button_text_color — VARCHAR(7)
  • hide_today_button_text_color — VARCHAR(7)
  • cta_button_color — VARCHAR(7)
  • cta_button_link — TEXT
  • close_icon_url — TEXT
  • is_web_link — BOOLEAN
  • is_app_screen — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

business_group

  • business_group_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • is_agency — BOOLEAN
  • invoice_email — VARCHAR(255)
  • review_status — VARCHAR(40)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

campaign

  • campaign_id — BIGINT
  • business_group_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • budget — DOUBLE
  • campaign_status — VARCHAR(255)
  • goal — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

campaign_budget

  • campaign_budget_id — BIGINT
  • campaign_id — BIGINT — NOT NULL
  • version — BIGINT
  • paid_amount — BIGINT
  • paid_deposit_sum — BIGINT
  • paid_withdraw_sum — BIGINT
  • free_amount — BIGINT
  • free_deposit_sum — BIGINT
  • free_withdraw_sum — BIGINT
  • is_postpaid — BOOLEAN
  • credit_limit — BIGINT
  • credit_deposit_sum — BIGINT
  • credit_withdraw_sum — BIGINT
  • credit_settlement_sum — BIGINT
  • billing_due_date — TIMESTAMP
  • billing_status — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

company

  • company_id — BIGINT
  • registration_number — VARCHAR(255) — NOT NULL
  • registration_image_url — VARCHAR(255)
  • business_account_image_url — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • representative_name — VARCHAR(255)
  • type — VARCHAR(255)
  • industry — VARCHAR(255)
  • address — VARCHAR(255)
  • zip_code — VARCHAR(255)
  • account_number — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member

  • member_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • account_id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member_business_group

  • id — BIGINT — Primary key — NOT NULL — ID
  • member_id — BIGINT — NOT NULL — 회원 ID
  • business_group_id — BIGINT — NOT NULL — 비즈니스 그룹 ID
  • role — VARCHAR(255) — NOT NULL — 역할
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • ad_group_id — BIGINT — NOT NULL — 광고그룹 ID
  • name — VARCHAR(255) — NOT NULL — 광고명
  • category — VARCHAR(255) — NOT NULL — 카테고리
  • ad_status — VARCHAR(255) — NOT NULL — 광고 상태
  • brand_name — VARCHAR(255) — NOT NULL — 브랜드명
  • icon_image_url — VARCHAR(255) — NOT NULL — 아이콘 이미지 URL
  • landing_url — TEXT — NOT NULL — 랜딩 URL
  • main_text — TEXT — NOT NULL — 메인 텍스트
  • sub_text — TEXT — NOT NULL — 서브 텍스트
  • cta_button_text — VARCHAR(255) — NOT NULL — CTA 버튼 텍스트
  • requires_review — VARCHAR(255) — 검토 필요 여부
  • detargeting_condition — TEXT — 디타겟팅 조건
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • ad_group_id — BIGINT — NOT NULL — 광고그룹 ID
  • name — VARCHAR(255) — NOT NULL — 광고명
  • category — VARCHAR(255) — NOT NULL — 카테고리
  • ad_status — VARCHAR(255) — NOT NULL — 광고 상태
  • image_url — VARCHAR(2048) — NOT NULL — 이미지 URL
  • landing_url — TEXT — NOT NULL — 랜딩 URL
  • brand_name — TEXT — NOT NULL — 브랜드명
  • requires_review — VARCHAR(255) — 검토 필요 여부
  • detargeting_condition — TEXT — 디타겟팅 조건
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • ad_collection_id — BIGINT — NOT NULL — 광고 컬렉션 ID
  • name — VARCHAR(255) — NOT NULL — 광고명
  • category — VARCHAR(255) — NOT NULL — 카테고리
  • ad_status — VARCHAR(255) — NOT NULL — 광고 상태
  • brand_name — VARCHAR(255) — NOT NULL — 브랜드명
  • background_image — TEXT — NOT NULL — 배경 이미지
  • is_web_link — BOOLEAN — NOT NULL — 웹 링크 여부
  • is_app_screen — BOOLEAN — NOT NULL — 앱 화면 여부
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • name — VARCHAR(255) — NOT NULL — 전략명
  • device — VARCHAR(255) — NOT NULL — 디바이스
  • gender — VARCHAR(255) — NOT NULL — 성별
  • min — INT — 최소 연령
  • max — INT — 최대 연령
  • is_all — BOOLEAN — NOT NULL — 전체 연령 여부
  • business_group_id — BIGINT — NOT NULL — 비즈니스 그룹 ID
  • is_all_placements — BOOLEAN — NOT NULL — 전체 플레이스먼트 여부
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

mission

  • mission_id — BIGINT
  • mission_ad_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

mission_ad

  • mission_ad_id — BIGINT
  • ad_collection_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

mission_comment

  • mission_comment_id — BIGINT
  • mission_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

native_banner_ad

  • native_banner_ad_id — BIGINT
  • ad_group_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • ad_status — VARCHAR(255)
  • brand_name — VARCHAR(255)
  • icon_image_url — VARCHAR(255)
  • landing_url — TEXT
  • main_text — TEXT
  • sub_text — TEXT
  • cta_button_text — VARCHAR(255)
  • requires_review — VARCHAR(255)
  • detargeting_condition — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

rectangular_banner_ad

  • rectangular_banner_ad_id — BIGINT
  • ad_group_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • ad_status — VARCHAR(255)
  • image_url — VARCHAR(2048)
  • landing_url — TEXT
  • brand_name — TEXT
  • requires_review — VARCHAR(255)
  • detargeting_condition — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

splash_sheet_ad

  • splash_sheet_ad_id — BIGINT
  • ad_collection_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • ad_status — VARCHAR(255)
  • brand_name — VARCHAR(255)
  • background_image — TEXT
  • is_web_link — BOOLEAN
  • is_app_screen — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

target_strategy

  • ad_group_target — BIGINT
  • name — VARCHAR(255)
  • device — VARCHAR(255)
  • gender — VARCHAR(255)
  • min — INT
  • max — INT
  • is_all — BOOLEAN
  • business_group_id — BIGINT
  • is_all_placements — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP