광고관리

테이블 (5)

ad(광고 메인) (광고_메인)

  • ad_id (Key) — int — 기본 키 — NOT NULL
  • ap_type (Field) — varchar(10)
  • show_type (Field2) — varchar(10)
  • control_code (Field3) — varchar(10)
  • ad_on (Field4) — varchar(1)
  • status (Field5) — varchar(10)
  • show_seq (Field6) — int
  • start_at (Field7) — timestamp
  • end_at (Field8) — timestamp
  • memo (Field9) — text
  • link_url (Field10) — varchar(500)
  • open_link (Field11) — varchar(1)
  • created_at (Field12) — timestamp
  • created_by (Field13) — varchar(30)
  • updated_at (Field14) — timestamp
  • updated_by (Field15) — varchar(30)
  • deleted_at (Field16) — timestamp

ad_detail(광고 콘텐츠) (Untitled)

  • ad_detail_id (Key) — int — 기본 키 — NOT NULL
  • ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
  • ad_type (Field2) — varchar(10)
  • file_key (Field3) — varchar(100)
  • file_name (Field4) — varchar(150)
  • mime_type (Field5) — varchar(10)
  • file_size (Field6) — long
  • width (Field7) — int
  • height (Field8) — int
  • text_body (Field9) — text

ad_history(광고 이력 관리) (Untitled2)

  • log_id (Key) — int — 기본 키 — NOT NULL
  • ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
  • chg_type (Field2) — varchar(10)
  • reason (Field3) — text
  • diff_json (Field4) — text
  • create_at (Field5) — timestamp
  • create_by (Field6) — varchar(30)

ad_target(단지 타겟) (Untitled3)

  • target_id (Key) — int — 기본 키 — NOT NULL
  • ad_id (Key22) — int — 외래 키 → ad_target_binding(광고 타겟 연결).ad_id — NOT NULL
  • binding_id (Key2) — int — 외래 키 → ad_target_binding(광고 타겟 연결).binding_id — NOT NULL
  • app_type (Field) — varchar(10)
  • blzn__id (Field2) — varchar(50)
  • blan_type (Field3) — varchar(50)
  • status (Field4) — varchar(10)
  • is_over_3y (Field5) — varchar(1)
  • memo (Field6) — text
  • created_at (Field7) — timestamp
  • created_by (Field8) — varchar(30)
  • updated_at (Field9) — timestamp
  • updated_by (Field10) — varchar(30)_
  • deleted_at (Field11) — timestamp

ad_target_binding(광고 타겟 연결) (Untitled4)

  • binding_id (Key) — int — 기본 키 — NOT NULL
  • ad_id (Key2) — int — 외래 키 → ad(광고 메인).ad_id — NOT NULL
  • target_type (Field2) — varchar(10)
  • target_id (Field3) — int
  • created_at (Field4) — timestamp
  • crated_by (Field5) — varchar(30)