정산
테이블 (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)
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