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)