order-fulfillment

Tables (22)

channel (판매처)

  • Key — Primary key — NOT NULL

cutoff_policy (주문 마감)

  • Key — Primary key — NOT NULL

delivery (배송)

  • pk (id) — Primary key — NOT NULL
  • Key (delivery_route_code) — Foreign key → delivery_route.Key — NOT NULL
  • Key (vehicle_id) — Foreign key → vehicle.Key — NOT NULL
  • Key (driver_id) — Foreign key → driver.Key — NOT NULL

delivery_route (배송코스)

  • Key (code) — Primary key — NOT NULL

delivery_route_node (배송코스별 경유지)

  • Key — Primary key — NOT NULL
  • Key (delivery_route_code) — Foreign key → delivery_route.Key — NOT NULL
  • Key (delivery_zone_code) — Foreign key → zone.Key — NOT NULL

driver (배송 담당자)

  • Key — Primary key — NOT NULL

loading_center (상차 가능 센터)

  • Key — Primary key — NOT NULL
  • Key (delivery_route_code) — Foreign key → delivery_route.Key — NOT NULL
  • Key (logistics_center_code) — Foreign key → logistics_center.Key — NOT NULL

logistics_center (물류센터)

  • Key (code) — Primary key — NOT NULL
  • Key (zone_code) — Foreign key → zone.Key — NOT NULL

order (주문)

  • PK (id) — Primary key — NOT NULL
  • index (channel_id) — Foreign key → channel.Key — NOT NULL
  • index (delivery_zone_code) — Foreign key → zone.Key — NOT NULL

order_item (주문 아이템)

  • Key — Primary key — NOT NULL
  • index (order_id) — Foreign key → order.PK — NOT NULL
  • index (sku_oms_code) — Foreign key → sku_oms.Key — NOT NULL

order_item_tms (주문아이템t)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → order_tms.PK — NOT NULL

order_tms (주문 tms)

  • PK (id) — Primary key — NOT NULL
  • index (order_id) — Foreign key → order.PK — NOT NULL
  • index (delivery_id) — Foreign key → delivery.pk — NOT NULL

outbound (출고)

  • Key (id) — Primary key — NOT NULL
  • Key (warehouse_code) — Foreign key → warehouse.Key — NOT NULL
  • index (order_id) — Foreign key → order.PK — NOT NULL
  • Key (center_code) — Foreign key → logistics_center.Key — NOT NULL

outbound_item (출고 아이템)

  • PK (id) — Primary key — NOT NULL
  • Key (outboud_id) — Foreign key → outbound.Key — NOT NULL
  • Key (sku_code) — Foreign key → sku.Key — NOT NULL

route_schedule (배송 회차)

  • Key — Primary key — NOT NULL
  • Key (delivery_route_code) — Foreign key → delivery_route.Key — NOT NULL

sku (상품)

  • Key (code) — Primary key — NOT NULL

sku_mapping_oms (상품 매핑)

  • PK (id) — Primary key — NOT NULL
  • index (channel_id) — Foreign key → channel.Key — NOT NULL
  • index (sku_oms_code) — Foreign key → sku_oms.Key — NOT NULL

sku_oms (oms상품)

  • Key — Primary key — NOT NULL

stock (재고)

  • Key — Primary key — NOT NULL
  • Key (sku_code) — Foreign key → sku.Key — NOT NULL
  • Key (warehouse_code) — Foreign key → warehouse.Key — NOT NULL

vehicle (배송 수단)

  • Key — Primary key — NOT NULL

warehouse (창고)

  • Key (code) — Primary key — NOT NULL
  • Key (Key2) — Foreign key → logistics_center.Key — NOT NULL

zone (권역)

  • Key (code) — Primary key — NOT NULL
  • Key (parent_code) — Foreign key → zone.Key — NOT NULL