Method for Managing Database according to Order on Fashion supply Chain Management System

摘要

PURPOSE: A method for operating a database according to an order in integrated fashion commodity management system is provided to systematically manage partial delivery or split delivery generated in physical distribution. CONSTITUTION: A purchaser selects desired commodities at an on-line shopping mall and orders the selected commodities through a terminal capable of inputting an order of a commodity(S100). An on-line shopping mall server receives the order and grants an order number to it(S110). The shopping mall server creates an order master table for the order and order detail tables for the commodities of the order(S120). The shopping mall server confirms whether the commodity price is inputted for the order(S130). If the commodity price is inputted for the order, the shopping mall server delivers the commodities to the purchaser and creates commodity delivery tables to manage delivery information(S140). Then the shopping mall server updates the order master table and the order detail tables(S150).