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