place_ad

Tables (3)

dsp_place_ad_ip (아이피 리스트 등록)

  • idx — int — Primary key — NOT NULL
  • sg_idx (전략번호) — int
  • address_ip (아이피) — varchar
  • reg_date (등록일자) — datetime
  • reg_uid (담당자) — varchar

place_info

  • idx — int — Primary key — NOT NULL
  • place (장소) — varchar
  • reg_date (등록일자) — datetime
  • nstat (활성/비활성) — enum(on,off)
  • ad_manager (담당자명) — varchar

place_ip

  • idx — int — Primary key — NOT NULL
  • place_idx (place_info의 idx) — int — Foreign key → place_info.idx — NOT NULL
  • sg_idx (전략번호) — int
  • ip (아이피) — varchar
  • reg_date (등록일자) — datetime