광고 자동화
테이블 (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