배너

테이블 (3)

ad_campaigns (Untitled)

  • id (Key) — integer — 기본 키 — NOT NULL
  • name (Field) — varchar
  • order (Field2) — interger
  • link (Field3) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • published_at (Field6) — timestamp
  • ended_at (Field7) — timestamp

ad_placement (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • id — integer — 외래 키 → ads.id — NOT NULL
  • ad_id (Field) — integer
  • billboard_id (Field2)

ads

  • id — integer — 기본 키 — NOT NULL
  • ad_campaign_id (Key) — integer — 외래 키 → ad_campaigns.id — NOT NULL
  • media (Field2) — varchar
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp