배너
테이블 (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