광고 자동화

테이블 (17)

ad_chart (차트데이터)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • subscribe_cycle_id (FK) — bigint — 외래 키 → subscribe_cycle.id — NOT NULL
  • reservation_cnt (Field) — int
  • kimcaddie_reservation_cnt (Field2) — int
  • new_user_cnt (Field3) — int
  • revenue (Field4) — bigint
  • view_cnt (Field5) — int
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime

ad_coupon (쿠폰 등록)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • subscribe_cycle_id (FK) — bigint — 외래 키 → subscribe_cycle.id — NOT NULL
  • min_amount (Field) — int
  • target_type (Field2) — enum
  • reusable (Field3) — boolean
  • usable_start_time (Field4) — time
  • usable_end_time (Field5) — time
  • valid_days (Field6) — int
  • issue_limit (Field7) — int
  • budget (Field8) — int
  • amount (Field9) — int
  • created_at (Field10) — datetime
  • updated_at (Field11) — datetime

ad_coupon_issue (쿠폰 발행)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_coupon_id (FK) — bigint — 외래 키 → ad_coupon.id — NOT NULL
  • user_id (FK2) — bigint — 외래 키 → user.user_id — NOT NULL
  • issued_at (Field) — datetime
  • used_at (Field2) — datetime
  • status (Field3) — enum
  • used_amount (Field4) — int
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

ad_kakao (카카오 광고)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • shop_id (Field) — bigint
  • send_count (Field2) — int
  • gender (Field3) — enum
  • applied_at (Field4) — datetime
  • requested_at (Field5) — datetime
  • sent_at (Field6) — datetime
  • total_amount (Field7) — int
  • status (Field8) — enum
  • reason (Field9) — varchar(255)
  • content (Field10) — varchar(500)
  • image_url (Field11) — varchar(255)
  • created_at (Field12) — datetime
  • updated_at (Field13) — datetime

ad_kakao_cancel (카카오 광고 취소)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_kakao_id (FK) — bigint — 외래 키 → ad_kakao.id — NOT NULL
  • canceled_at (Field) — datetime
  • created_at (Field2) — datetime

ad_kakao_target_age (카카오 광고 타켓 연령)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_kakao_id (FK) — bigint — 외래 키 → ad_kakao.id — NOT NULL
  • age_range (Field) — enum
  • created_at (Field2) — datetime

ad_kakao_target_region (카카오 광고 타켓 지역)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_kakao_id (FK) — bigint — 외래 키 → ad_kakao.id — NOT NULL
  • region_id (FK2) — bigint — 외래 키 → region.region_id — NOT NULL
  • created_at (Field) — datetime

ad_listing_plan (리스팅 광고 상품)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_listing_plan_name (Field) — varchar(20)
  • price (Field2) — int
  • coupon_qty (Field3) — int
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

ad_product (광고 상품)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_name (Field) — varchar(20)
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

ad_weekday (요일)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • ad_coupon_id (FK) — bigint — 외래 키 → ad_coupon.id — NOT NULL
  • weekday (Field) — enum

payment (결제)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • subscribe_cycle_id (FK) — bigint — 외래 키 → subscribe_cycle.id — NOT NULL
  • ad_kakao_id (FK2) — bigint — 외래 키 → ad_kakao.id — NOT NULL
  • payment_method_id (FK3) — bigint — 외래 키 → payment_method.id — NOT NULL
  • paid_at (Field) — datetime
  • amount (Field2) — int
  • status (Field3) — enum
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

payment_method (결제카드)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • billing_key (Field) — varchar(255)
  • masked_number (Field2) — varchar(20)
  • card_company (Field3) — varchar(20)
  • card_type (Field4) — enum
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

region (지역 참조)

  • region_id (Key) — bigint — 기본 키 — NOT NULL

shop (매장 테이블 참조)

  • shop_id (PK) — bigint — 기본 키 — NOT NULL
  • payment_method_id (FK) — bigint — 외래 키 → payment_method.id — NOT NULL

subscribe (구독)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • shop_id (FK) — bigint — 외래 키 → shop.shop_id — NOT NULL
  • ad_product_id (FK2) — bigint — 외래 키 → ad_product.id — NOT NULL
  • ad_listing_plan_id (FK3) — bigint — 외래 키 → ad_listing_plan.id — NOT NULL
  • status (Field) — enum
  • next_payment_date (Field2) — datetime
  • cancel_reason (Field3) — varchar(255)
  • canceled_at (Field4) — datetime
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

subscribe_cycle (구독 싸이클)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • subscribe_id (FK) — bigint — 외래 키 → subscribe.id — NOT NULL
  • started_at (Field) — date
  • ended_at (Field2) — date
  • status (Field3) — enum
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

user (유저 테이블 참조)

  • user_id (PK) — bigint — 기본 키 — NOT NULL