정산

테이블 (14)

daily_job (Untitled2)

  • job_date — 기본 키 — NOT NULL
  • job_id — 외래 키 → job.id — NOT NULL
  • delivery_policy_history_id — 외래 키 → delivery_policy_history.id — NOT NULL

delivery_policy (Untitled6)

  • id — 기본 키 — NOT NULL

delivery_policy_add_fee (Untitled8)

  • id — 기본 키 — NOT NULL
  • delivery_policy_id — 외래 키 → delivery_policy.id — NOT NULL

delivery_policy_add_fee_history (Untitled7)

  • id — 기본 키 — NOT NULL
  • delivery_policy_add_fee_id — 외래 키 → delivery_policy_add_fee.id — NOT NULL
  • base_fee_type (요금 타입(기본, 소형))
  • day_of_week (요일(1:일, 2:월, 7: 토))
  • area_additional_fee (지역별 추가요금)
  • shared_day_additional_fee (회사 지정 추가 요금?)
  • holiday_eve_additional_fee (공휴일 전날 추가요금)
  • day_of_week_additional_fee (요일별 추가 요금)
  • holiday_additional_fee (공휴일 추가 요금)
  • valid_from (적용일(시작))
  • valid_to (적용일(끝))

delivery_policy_history (Untitled5)

  • id — 기본 키 — NOT NULL
  • delivery_policy_id — 외래 키 → delivery_policy.id — NOT NULL
  • standard_fee (기본요금)
  • valid_from (적용일(시작))
  • valid_to (적용일(끝))
  • small_fee (소형요금)

delivery_policy_promotion (Untitled9)

  • id — 기본 키 — NOT NULL
  • delivery_policy_id — 외래 키 → delivery_policy.id — NOT NULL
  • base_camp_region_id
  • promotion_id
  • id (Key) — 외래 키 → promotion.id — NOT NULL

job (Untitled3)

  • id — 기본 키 — NOT NULL
  • delivery_policy_id — 외래 키 → delivery_policy.id — NOT NULL

promotion (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • promotion_name
  • promotion_start_date (프로모션 적용일(시작))
  • promotion_end_date (프로모션 적용일(끝))
  • promotion_fee (금액)

promotion_history (Untitled11)

  • id — 기본 키 — NOT NULL
  • promotion_id — 외래 키 → promotion.id — NOT NULL
  • fee_type (요금타입(기본,소형))
  • day_of_week (요일)
  • promotion_fee (금액)
  • valid_from (프로모션 적용일(시작))
  • valid_to (프로모션 적용일(끝))

settlement_dedeuction (Untitled14)

  • id — 기본 키 — NOT NULL
  • user_job_settlement_id — 외래 키 → user_job_settlement.id — NOT NULL
  • deduction_type (공제금액 타입)
  • fee (공제 금액)

settlement_settings (Untitled13)

  • id — 기본 키 — NOT NULL
  • name (설정값 이름)
  • value (설정값)
  • type (데이터 타입)
  • valid_from (유효기간(시작))
  • valid_to (유효기간(끝))
  • description (설정값 설명)

user_job (Untitled)

  • user_id — 기본 키 — NOT NULL
  • job_id — 외래 키 → daily_job.job_id — NOT NULL
  • job_date — 외래 키 → daily_job.job_date — NOT NULL

user_job_settlement (Untitled4)

  • id — 기본 키 — NOT NULL
  • user_id — 외래 키 → user_job.user_id — NOT NULL
  • job_id — 외래 키 → user_job.job_id — NOT NULL
  • job_date — 외래 키 → user_job.job_date — NOT NULL
  • delivery_type (배송타입)
  • box_count (박스수)
  • income (수입)
  • decudtion_fee (공제금액)
  • delivery_policy_history_id — 외래 키 → delivery_policy_history.id — NOT NULL
  • delivery_policy_add_fee_history_id — 외래 키 → delivery_policy_add_fee_history.id — NOT NULL
  • last_settlement_date_time (마지막 정산 시점)

user_job_settlement_promotion_history (Untitled12)

  • user_job_settlement_id — 외래 키 → user_job_settlement.id — NOT NULL
  • promotion_history_id — 외래 키 → promotion_history.id — NOT NULL