shopping

Tables (8)

affiliate_campaigns

  • campaign_id — BIGINT — 캠페인
  • affiliate_partner_id — bigint — Foreign key → affiliate_partners.affiliate_partner_id — NOT NULL — 제휴처
  • campaign_code — varchar(50) — NOT NULL — 캠페인
  • campaign_name — varchar(150) — NOT NULL — 캠페인명
  • landing_url — varchar(500) — 랜딩
  • inpath1_default — varchar(100) — 기본
  • inpath2_default — varchar(100) — 기본
  • commission_rate — decimal(5,2) — NOT NULL — 수수료율
  • status — varchar(20) — NOT NULL — ACTIVE
  • started_at — datetime — 시작일시
  • ended_at — datetime — 종료일시
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

affiliate_click_logs

  • click_log_id — BIGINT — 클릭로그
  • affiliate_partner_id — bigint — Foreign key → affiliate_partners.affiliate_partner_id — 제휴처
  • campaign_id — bigint — Foreign key → affiliate_campaigns.campaign_id — 캠페인
  • inpath1 — varchar(100) — 유입경로1
  • inpath2 — varchar(100) — 유입경로2
  • click_key — varchar(100) — 클릭
  • user_id — bigint — Foreign key → users.user_id — 회원
  • session_id — varchar(100) — 세션
  • ip_address — varchar(45) — 접속
  • referer_url — varchar(500) — 리퍼러
  • landing_url — varchar(500) — 랜딩
  • user_agent — varchar(500) — 브라우저
  • clicked_at — datetime — NOT NULL — 클릭일시
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

affiliate_partners

  • affiliate_partner_id — BIGINT — 제휴처
  • partner_code — varchar(50) — NOT NULL — 제휴처
  • partner_name — varchar(150) — NOT NULL — 제휴처명
  • business_no — varchar(30) — 사업자번호
  • contact_name — varchar(100) — 담당자명
  • contact_email — varchar(150) — 담당자
  • contact_phone — varchar(20) — 담당자
  • bank_name — varchar(100) — 은행명
  • bank_account_no — varchar(100) — 계좌번호
  • account_holder_name — varchar(100) — 예금주
  • settlement_cycle — varchar(20) — NOT NULL — DAILY
  • default_commission_rate — decimal(5,2) — NOT NULL — 기본
  • status — varchar(20) — NOT NULL — ACTIVE
  • started_at — date — 시작일
  • ended_at — date — 종료일
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

affiliate_settlement_items

  • settlement_item_id — BIGINT — 정산상세
  • settlement_id — bigint — Foreign key → affiliate_settlements.settlement_id — NOT NULL — 정산
  • attribution_id — bigint — Foreign key → order_affiliate_attributions.attribution_id — NOT NULL — 주문귀속
  • base_amount — decimal(12,2) — NOT NULL — 기준금액
  • commission_rate — decimal(5,2) — NOT NULL — 수수료율
  • commission_amount — decimal(12,2) — NOT NULL — 수수료금액
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

affiliate_settlements

  • settlement_id — BIGINT — 정산
  • affiliate_partner_id — bigint — Foreign key → affiliate_partners.affiliate_partner_id — NOT NULL — 제휴처
  • settlement_year — int — NOT NULL — 정산연도
  • settlement_month — int — Foreign key → affiliate_settlements.settlement_id — NOT NULL — 정산월
  • settlement_status — varchar(20) — NOT NULL — READY
  • total_base_amount — decimal(14,2) — NOT NULL — 기준금액
  • total_commission_amount — decimal(14,2) — NOT NULL — 수수료
  • adjustment_amount — decimal(14,2) — NOT NULL — 조정금액
  • final_settlement_amount — decimal(14,2) — NOT NULL — 최종
  • requested_at — datetime — 정산요청일시
  • paid_at — datetime — 지급일시
  • memo — varchar(500) — 메모
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

order_affiliate_attributions

  • attribution_id — BIGINT — 주문귀속
  • order_id — bigint — Foreign key → orders.order_id — NOT NULL — 주문
  • affiliate_partner_id — bigint — Foreign key → affiliate_partners.affiliate_partner_id — NOT NULL — 제휴처
  • campaign_id — bigint — Foreign key → affiliate_campaigns.campaign_id — 캠페인
  • click_log_id — bigint — Foreign key → affiliate_click_logs.click_log_id — 클릭로그
  • inpath1 — varchar(100) — Foreign key → order_affiliate_attributions.attribution_id — 유입경로1
  • inpath2 — varchar(100) — 유입경로2
  • attribution_model — varchar(20) — NOT NULL — LAST_CLICK
  • base_amount — decimal(12,2) — NOT NULL — 정산기준금액
  • commission_rate — decimal(5,2) — NOT NULL — 수수료율
  • expected_commission_amount — decimal(12,2) — NOT NULL — 예상
  • confirmed_commission_amount — decimal(12,2) — 확정
  • settlement_status — varchar(20) — NOT NULL — PENDING
  • confirmed_at — datetime — 확정일시
  • settled_at — datetime — 정산완료일시
  • memo — varchar(500) — 메모
  • created_at — datetime — NOT NULL — 등록일
  • created_by — bigint — 등록자
  • updated_at — datetime — NOT NULL — 수정일
  • updated_by — bigint — 수정자

orders

  • order_id — bigint — 주문
  • order_no — varchar(50)
  • user_id — bigint
  • paid_amount — decimal(12,2)
  • order_status — varchar(30)

users

  • user_id — bigint — 회원
  • login_id — varchar(50)
  • user_name — varchar(100)