˵µ½Êý¾Ý¿â£¬ÎÒÈÏΪ²»Äܲ»ÏÈ̸Êý¾Ý½á¹¹¡£1996Ä꣬ÔÚÎÒ³õÈë´óѧѧϰ¼ÆËã»ú±à³Ìʱ£¬µ±Ê±µÄÀÏʦ¾Í¸æËßÎÒÃÇ˵£º¼ÆËã»ú³ÌÐò£½Êý¾Ý½á¹¹£«Ëã·¨¡£¾¡¹ÜÏÖÔڵijÌÐò¿ª·¢ÒÑÓÉÃæÏò¹ý³ÌΪÖ÷Öð²½¹ý¶Éµ½ÃæÏò¶ÔÏóΪÖ÷£¬µ«ÎÒ»¹ÊÇÉîÉîÔÞͬ8ÄêÇ°ÀÏʦµÄ¸æËßÎÒÃǵĹ«Ê½£º¼ÆËã»ú³ÌÐò£½Êý¾Ý½á¹¹£«Ëã·¨¡£ÃæÏò¶ÔÏóµÄ³ÌÐò¿ª·¢£¬Òª×öµÄµÚÒ»¼þʾÍÊÇ£¬ÏÈ·ÖÎöÕû¸ö³ÌÐòÖÐÐè´¦ÀíµÄÊý¾Ý£¬´ÓÖÐÌáÈ¡³ö³éÏóÄ£°å£¬ÒÔÕâ¸ö³éÏóÄ£°åÉè¼ÆÀ࣬ÔÙÔÚÆäÖÐÖð²½Ìí¼Ó´¦ÀíÆäÊý¾ÝµÄº¯Êý(¼´Ëã·¨)£¬×îºó£¬ÔÙ¸øÀàÖеÄÊý¾Ý³ÉÔ±ºÍº¯Êý»®·Ö·ÃÎÊȨÏÞ£¬´Ó¶øʵÏÖ·â×°¡£
¡¡¡¡Êý¾Ý¿âµÄ×î³õ³ûÐξÝ˵Դ×ÔÃÀ¹úÒ»¸öÄÌÅ£³¡µÄ¼ÇÕ˱¡(Ö½Öʵģ¬Óɴ˿ɼû£¬Êý¾Ý¿â²¢²»Ò»¶¨ÊÇ´æ´¢ÔÚµçÄÔÀïµÄÊý¾Ý^_^)£¬ÀïÃæ¼Ç¼µÄÊǸÃÄÌÅ£³¡µÄÊÕÖ§ÕËÄ¿£¬³ÌÐòÔ±ÔÚ½«ÆäÕûÀí¡¢Â¼Èëµ½µçÄÔÖÐʱ´ÓÖÐÊܵ½Æô·¢¡£µ±°´Õչ涨ºÃµÄÊý¾Ý½á¹¹Ëù²É¼¯µ½µÄÊý¾ÝÁ¿´óµ½Ò»¶¨³Ì¶Èºó£¬³öÓÚ³ÌÐòÖ´ÐÐЧÂʵĿ¼ÂÇ£¬³ÌÐòÔ±½«ÆäÖеļìË÷¡¢¸üÐÂά»¤µÈ¹¦ÄÜ·ÖÀë³öÀ´£¬×ö³Éµ¥¶Àµ÷ÓõÄÄ£¿é£¬Õâ¸öÄ£¿éºóÀ´¾ÍÂýÂý·¢Õ¹¡¢Ñݱä³ÉÏÖÔÚÎÒÃÇËù½Ó´¥µ½µÄÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)----³ÌÐò¿ª·¢ÖеÄÒ»¸öÖØÒª·ÖÖ§¡£
¡¡¡¡ÏÂÃæ½øÈëÕýÌ⣬Ê×ÏÈ°´ÎÒ¸öÈËËù½Ó´¥¹ýµÄ³ÌÐò¸øÊý¾Ý¿âÉè¼ÆÈËÔ±µÄ¹¦µ×·ÖÒ»ÏÂÀࣺ
¡¡¡¡£±¡¢Ã»ÓÐϵͳѧϰ¹ýÊý¾Ý½á¹¹µÄ³ÌÐòÔ±¡£ÕâÀà³ÌÐòÔ±µÄ×÷Æ·ÍùÍùÖ»ÊÇËûÃǵļ´ÐËÍæ¾ß£¬ËûÃÇÍùÍùÏ°¹ßÖ»Éè¼ÆÓÐÏ޵ļ¸¸ö±í£¬ÊµÏÖijÀ๦ÄܵÄÊý¾ÝÈ«²¿ÈûÔÚÒ»¸ö±íÖУ¬¸÷±íÖ®¼ä¼¸ºõºÁÎÞ¹ØÁª¡£ÍøÉϲ»ÉÙµÄÃâ·Ñ¹ÜÀíÈí¼þ¶¼ÊÇÕâÑùµÄ¶«Î÷£¬µ±³ÌÐò¹¦ÄÜÓÐÏÞ£¬Êý¾ÝÁ¿²»¶àµÄʱºò£¬Æä³ÌÐòÔËÐÐÆðÀ´Ã»ÓÐʲôÎÊÌ⣬µ«ÊÇÈç¹ûÓÃÆä¹ÜÀí±È½ÏÖØÒªµÄÊý¾Ý£¬·çÏÕÐԷdz£´ó¡£
¡¡¡¡£²¡¢ÏµÍ³Ñ§Ï°¹ýÊý¾Ý½á¹¹£¬µ«ÊÇ»¹Ã»Óпª·¢¹ý¶Ô³ÌÐòЧÂÊÒªÇó±È½Ï¸ßµÄ¹ÜÀíÈí¼þµÄ³ÌÐòÔ±¡£ÕâÀàÈ˶à°ë¸Õ´ÓѧУ±ÏÒµ²»¾Ã£¬ËûÃÇÔÚÉè¼ÆÊý¾Ý¿â±í½á¹¹Ê±£¬Ñϸñ°´Õս̿ÆÊéÉϵĹ涨£¬ËÀ¿ÛE-RͼºÍ3NF(±ð»ÒÐÄ£¬ËùÓеÄÊý¾Ý¿âÉè¼Æ¸ßÊÖ¶¼ÊÇ´ÓÕâÒ»²½¿ªÊ¼µÄ)¡£ËûÃǵÄ×÷Æ·£¬¶ÔÓÚÒ»°ãµÄaccessÐÍÇáÁ¿¼¶µÄ¹ÜÀíÈí¼þ£¬ÒѾ¹»Óᣵ«ÊÇÒ»µ©¸ÃϵͳÐèÒªÌí¼Óй¦ÄÜ£¬ÔÓеÄÊý¾Ý¿â±í²î²»¶àµÃ½øÐдó»»Ñª¡£
¡¡¡¡£³¡¢µÚ¶þÀà³ÌÐòÔ±£¬ÔÚ¾Àú¹ýÊý´Î³ÌÐòЧÂʵÄÌáÉý£¬ÒÔ¼°¹¦ÄÜÉý¼¶µÄÕÛÌÚºó£¬ÖÕÓÚÉý¼¶³ÉΪÊý¾Ý¿âÉè¼ÆµÄÀÏÄñ£¬µÚÒ»Àà³ÌÐòÔ±ÑÛÖеĸßÈË¡£ÕâÀà³ÌÐòÔ±¿ÉÒÔʤÈζþÊ®¸ö±íÒÔÉϵÄÖÐÐÍÉÌÒµÊý¾Ý¹ÜÀíϵͳµÄ¿ª·¢¹¤×÷¡£ËûÃÇÖªµÀ¸ÃÔÚʲôÑùµÄÇé¿öϱ£ÁôÒ»¶¨µÄÈßÓàÊý¾ÝÀ´Ìá¸ß³ÌÐòЧÂÊ£¬¶øÇÒÆäÉè¼ÆµÄÊý¾Ý¿â¿ÉÍØÕ¹ÐԽϺ㬵±Óû§ÐèÒªÌí¼Óй¦ÄÜʱ£¬ÔÓÐÊý¾Ý¿â±íÖ»Ðè×öÉÙÁ¿Ð޸ļ´¿É¡£
¡¡¡¡£´¡¢ÔÚ¾Àú¹ýÉÏÊ®¸öÀàËÆÊý¾Ý¿â¹ÜÀíÈí¼þµÄÖظ´Éè¼Æºó£¬µÚÈýÀà³ÌÐòÔ±Öмá³ÖÏÂÀ´Ã»ÓÐתÐУ¬¶øÊÇÏ£Íû´ÓÖÐÕÒ³ö¡°ÍµÀÁ¡±ÇÏÃŵÄÓÐÐÄÈË»áÂýÂý¾õÎò£¬´Ó¶øÍê³ÉÁ¿±äµ½ÖʱäµÄת»»¡£ËûÃÇËùÉè¼ÆµÄÊý¾Ý¿â±í½á¹¹ÓÐÒ»¶¨µÄÔ¶¼û£¬Äܹ»Ô¤²âµ½Î´À´¹¦ÄÜÉý¼¶ËùÐèÒªµÄÊý¾Ý£¬´Ó¶øÔ¤ÏÈÁôÏ·ü±Ê¡£ÕâÀà³ÌÐòԱĿǰ´ó¶à½ú¼¶³ÉÊý¾ÝÍÚ¾ò·½ÃæµÄ¸ß¼¶Èí¼þ¿ª·¢ÈËÔ±¡£
¡¡¡¡£µ¡¢µÚÈýÀà³ÌÐòÔ±»òµÚËÄÀà³ÌÐòÔ±£¬ÔÚ¶ÔÏÖÓеĸ÷¼ÒÊý¾Ý¿â¹ÜÀíϵͳµÄÔÀíºÍ¿ª·¢¶¼ÓÐÒ»¶¨µÄ×êÑкó£¬ÒªÃ´ÔÚÆä»ù´¡ÉϽøÐжþ´Î¿ª·¢£¬ÒªÃ´×ÔÐпª·¢Ò»Ì×ÓÐ×ÔÖ÷°æȨµÄͨÓÃÊý¾Ý¿â¹ÜÀíϵͳ¡£
¡¡¡¡ÎÒ¸öÈËÕý´¦ÓÚµÚÈýÀàµÄÄ©ÆÚ£¬ËùÒÔÏÂÃæËùÁгöµÄһЩÉè¼Æ¼¼ÇÉÖ»ÊʺϵڶþÀàºÍ²¿·ÖµÚÈýÀàÊý¾Ý¿âÉè¼ÆÈËÔ±¡£Í¬Ê±£¬ÓÉÓÚÎÒºÜÉÙÅöµ½ÓÐÐËȤÔÚÕâ·½ÃæÉî×êÏÂÈ¥µÄͬÐУ¬ËùÒÔÎÄÖÐÄÑÃâ³öÏÖ´íÎóºÍÒÅ©£¬ÔÚ´ËÏÈÐÐÉùÃ÷£¬»¶Ó´ó¼ÒÖ¸Õý£¬²»Òª²Ø˽Ŷ8)
¡¡¡¡Ò»¡¢Ê÷Ð͹ØϵµÄÊý¾Ý±í
¡¡¡¡²»ÉÙ³ÌÐòÔ±ÔÚ½øÐÐÊý¾Ý¿âÉè¼ÆµÄʱºò¶¼Óöµ½¹ýÊ÷Ð͹ØϵµÄÊý¾Ý£¬ÀýÈç³£¼ûµÄÀà±ð±í£¬¼´Ò»¸ö´óÀ࣬ÏÂÃæÓÐÈô¸É¸ö×ÓÀ࣬ijЩ×ÓÀàÓÖÓÐ×ÓÀàÕâÑùµÄÇé¿ö¡£µ±Àà±ð²»È·¶¨£¬Óû§Ï£Íû¿ÉÒÔÔÚÈÎÒâÀà±ðÏÂÌí¼ÓеÄ×ÓÀ࣬»òÕßɾ³ýij¸öÀà±ðºÍÆäϵÄËùÓÐ×ÓÀ࣬¶øÇÒÔ¤¼ÆÒÔºóÆäÊýÁ¿»áÖð²½Ôö³¤£¬´ËʱÎÒÃǾͻῼÂÇÓÃÒ»¸öÊý¾Ý±íÀ´±£´æÕâЩÊý¾Ý¡£°´Õս̿ÆÊéÉϵĽ̵¼£¬µÚ¶þÀà³ÌÐòÔ±´ó¸Å»áÉè¼Æ³öÀàËÆÕâÑùµÄÊý¾Ý±í½á¹¹£º
Àà±ð±í_1(Type_table_1)
Ãû³Æ¡¡¡¡¡¡¡¡¡¡ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ËµÃ÷
type_id ¡¡ int ¡¡ ÎÞÖظ´¡¡¡¡ Àà±ð±êʶ£¬Ö÷¼ü
type_name¡¡¡¡ char(50) ²»ÔÊÐíΪ¿Õ ÀàÐÍÃû³Æ£¬²»ÔÊÐíÖظ´
type_father int ²»ÔÊÐíΪ¿Õ ¸ÃÀà±ðµÄ¸¸Àà±ð±êʶ£¬Èç¹ûÊǶ¥½ÚµãµÄ»°É趨Ϊij¸öΨһֵ
¡¡¡¡ÕâÑùµÄÉè¼Æ¶ÌС¾«º·£¬ÍêÈ«Âú×ã3NF£¬¶øÇÒ¿ÉÒÔÂú×ãÓû§µÄËùÓÐÒªÇó¡£ÊDz»ÊÇÕâÑù¾ÍÐÐÄØ£¿´ð°¸ÊÇNO£¡Why£¿
¡¡¡¡ÎÒÃÇÀ´¹À¼ÆÒ»ÏÂÓû§Ï£ÍûÈçºÎÂÞÁгöÕâ¸ö±íµÄÊý¾ÝµÄ¡£¶ÔÓû§¶øÑÔ£¬Ëûµ±È»ÆÚÍû°´ËûËùÉ趨µÄ²ã´Î¹Øϵһ´ÎÂÞÁгöËùÓеÄÀà±ð£¬ÀýÈçÕâÑù£º
×ÜÀà±ð
¡¡¡¡Àà±ð1
¡¡¡¡¡¡¡¡Àà±ð1.1
¡¡¡¡¡¡¡¡¡¡¡¡Àà±ð1.1.1
¡¡¡¡¡¡¡¡Àà±ð1.2
¡¡¡¡Àà±ð2
¡¡¡¡¡¡¡¡Àà±ð2.1
¡¡¡¡Àà±ð3
¡¡¡¡¡¡¡¡Àà±ð3.1
¡¡¡¡¡¡¡¡Àà±ð3.2
¡¡¡¡¡¡
¡¡¡¡¿´¿´ÎªÁËʵÏÖÕâÑùµÄÁбíÏÔʾ(Ê÷µÄÏÈÐò±éÀú)£¬Òª¶ÔÉÏÃæµÄ±í½øÐжàÉٴμìË÷£¿×¢Ò⣬¾¡¹ÜÀà±ð1.1.1¿ÉÄÜÊÇÔÚÀà±ð3.2Ö®ºóÌí¼ÓµÄ¼Ç¼£¬´ð°¸ÈÔÈ»ÊÇN´Î¡£ÕâÑùµÄЧÂʶÔÓÚÉÙÁ¿µÄÊý¾ÝûʲôӰÏ죬µ«ÊÇÈÕºóÀàÐÍÀ©³äµ½ÊýÊ®ÌõÉõÖÁÉÏ°ÙÌõ¼Ç¼ºó£¬µ¥µ¥ÁÐÒ»´ÎÀàÐ;ÍÒª¼ìË÷ÊýÊ®´Î¸Ã±í£¬Õû¸ö³ÌÐòµÄÔËÐÐЧÂʾͲ»¸Ò¹§Î¬ÁË¡£»òÐíµÚ¶þÀà³ÌÐòÔ±»á˵£¬ÄÇÎÒÔÙ½¨Ò»¸öÁÙʱÊý×é»òÁÙʱ±í£¬×¨Ãű£´æÀàÐͱíµÄÏÈÐò±éÀú½á¹û£¬ÕâÑùÖ»ÔÚµÚÒ»´ÎÔËÐÐʱ¼ìË÷ÊýÊ®´Î£¬ÔÙ´ÎÂÞÁÐËùÓеÄÀàÐ͹Øϵʱ¾ÍÖ±½Ó¶ÁÄǸöÁÙʱÊý×é»òÁÙʱ±í¾ÍÐÐÁË¡£Æäʵ£¬Óò»×ÅÔÙÈ¥·ÖÅäÒ»¿éеÄÄÚ´æÀ´±£´æÕâЩÊý¾Ý£¬Ö»Òª¶ÔÊý¾Ý±í½øÐÐÒ»¶¨µÄÀ©³ä£¬ÔÙ¶ÔÌí¼ÓÀàÐ͵ÄÊýÁ¿½øÐÐÒ»ÏÂÔ¼Êø¾ÍÐÐÁË£¬ÒªÍê³ÉÉÏÃæµÄÁбíÖ»ÐèÒ»´Î¼ìË÷¾ÍÐÐÁË¡£ÏÂÃæÊÇÀ©³äºóµÄÊý¾Ý±í½á¹¹£º
Àà±ð±í_2(Type_table_2)
Ãû³Æ¡¡¡¡¡¡¡¡¡¡ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
type_id ¡¡ int ¡¡ ÎÞÖظ´¡¡¡¡ Àà±ð±êʶ£¬Ö÷¼ü
type_name¡¡¡¡ char(50) ²»ÔÊÐíΪ¿Õ ÀàÐÍÃû³Æ£¬²»ÔÊÐíÖظ´
type_father int ²»ÔÊÐíΪ¿Õ ¸ÃÀà±ðµÄ¸¸Àà±ð±êʶ£¬Èç¹ûÊǶ¥½ÚµãµÄ»°É趨Ϊij¸öΨһֵ
type_layer char(6) ÏÞ¶¨3²ã,³õʼֵΪ000000 Àà±ðµÄÏÈÐò±éÀú£¬Ö÷ҪΪ¼õÉÙ¼ìË÷Êý¾Ý¿âµÄ´ÎÊý
¡¡¡¡°´ÕÕÕâÑùµÄ±í½á¹¹£¬ÎÒÃÇÀ´¿´¿´ÉÏÃæÀý×ӼǼÔÚ±íÖеÄÊý¾ÝÊÇÔõÑùµÄ£º
type_id type_name type_father type_layer
1 ×ÜÀà±ð 0 000000
2 Àà±ð1 1 010000
3 Àà±ð1.1 2 010100
4 Àà±ð1.2 2 010200
5 Àà±ð2 1 020000
6 Àà±ð2.1 5 020100
7 Àà±ð3 1 030000
8 Àà±ð3.1 7 030100
9 Àà±ð3.2 7 030200
10 Àà±ð1.1.1 3 010101
¡¡
¡¡¡¡ÏÖÔÚ°´type_layerµÄ´óСÀ´¼ìË÷һϣºSELECT * FROM Type_table_2 ORDER BY type_layer
Áгö¼Ç¼¼¯ÈçÏ£º
type_id type_name type_father type_layer
1 ×ÜÀà±ð 0 000000
2 Àà±ð1 1 010000
3 Àà±ð1.1 2 010100
10 Àà±ð1.1.1 3 010101
4 Àà±ð1.2 2 010200
5 Àà±ð2 1 020000
6 Àà±ð2.1 5 020100
7 Àà±ð3 1 030000
8 Àà±ð3.1 7 030100
9 Àà±ð3.2 7 030200
¡¡
¡¡¡¡ÏÖÔÚÁгöµÄ¼Ç¼˳ÐòÕýºÃÊÇÏÈÐò±éÀúµÄ½á¹û¡£ÔÚ¿ØÖÆÏÔʾÀà±ðµÄ²ã´Îʱ£¬Ö»Òª¶Ôtype_layer×Ö¶ÎÖеÄÊýÖµ½øÐÐÅжϣ¬Ã¿2λһ×飬Èç´óÓÚ0ÔòÏòÓÒÒÆ2¸ö¿Õ¸ñ¡£µ±È»£¬ÎÒÕâ¸öÀý×ÓÖÐÉ趨µÄÏÞÖÆÌõ¼þÊÇ×î¶à3²ã£¬Ã¿²ã×î¶à¿ÉÉè99¸ö×ÓÀà±ð£¬Ö»Òª°´Óû§µÄÐèÇóÇé¿öÐÞ¸ÄÒ»ÏÂtype_layerµÄ³¤¶ÈºÍλÊý£¬¼´¿É¸ü¸ÄÏÞÖƲãÊýºÍ×ÓÀà±ðÊý¡£Æäʵ£¬ÉÏÃæµÄÉè¼Æ²»µ¥µ¥Ö»ÔÚÀà±ð±íÖÐÓõ½£¬ÍøÉÏijЩ¿É°´Ê÷ÐÍÁбíÏÔʾµÄÂÛ̳³ÌÐò´ó¶à²ÉÓÃÀàËƵÄÉè¼Æ¡£
¡¡¡¡»òÐíÓÐÈËÈÏΪ£¬Type_table_2ÖеÄtype_father×Ö¶ÎÊÇÈßÓàÊý¾Ý£¬¿ÉÒÔ³ýÈ¥¡£Èç¹ûÕâÑù£¬ÔÚ²åÈ롢ɾ³ýij¸öÀà±ðµÄʱºò£¬¾ÍµÃ¶Ôtype_layer µÄÄÚÈݽøÐбȽϷ±ËöµÄÅж¨£¬ËùÒÔÎÒ²¢Ã»ÓÐÏûÈ¥type_father×ֶΣ¬ÕâÒ²Õý·ûºÏÊý¾Ý¿âÉè¼ÆÖÐÊʵ±±£ÁôÈßÓàÊý¾ÝµÄÀ´½µµÍ³ÌÐò¸´ÔӶȵÄÔÔò£¬ºóÃæÎÒ»á¾ÙÒ»¸ö¹ÊÒâÔö¼ÓÊý¾ÝÈßÓàµÄ°¸Àý¡£
¡¡¡¡
¡¡¡¡¶þ¡¢ÉÌÆ·ÐÅÏ¢±íµÄÉè¼Æ
¡¡¡¡¼ÙÉèÄãÊÇÒ»¼Ò°Ù»õ¹«Ë¾µçÄÔ²¿µÄ¿ª·¢ÈËÔ±£¬Ä³ÌìÀÏ°åÒªÇóÄãΪ¹«Ë¾¿ª·¢Ò»Ì×ÍøÉϵç×ÓÉÌÎñƽ̨£¬¸Ã°Ù»õ¹«Ë¾ÓÐÊýǧÖÖÉÌÆ·³öÊÛ£¬²»¹ýÄ¿Ç°½ö´òËãÏÈÔÚÍøÉÏÏúÊÛÊýÊ®ÖÖ·½±ãÔËÊäµÄÉÌÆ·£¬µ±È»£¬ÒÔºó¿ÉÄÜ»á½ÐøÔڸõç×ÓÉÌÎñƽ̨ÉÏÔö¼ÓеÄÉÌÆ·³öÊÛ¡£ÏÖÔÚ¿ªÊ¼½øÐиÃƽ̨Êý¾Ý¿âµÄÉÌÆ·ÐÅÏ¢±íµÄÉè¼Æ¡£Ã¿ÖÖ³öÊÛµÄÉÌÆ·¶¼»áÓÐÏàͬµÄÊôÐÔ£¬ÈçÉÌÆ·±àºÅ£¬ÉÌÆ·Ãû³Æ£¬ÉÌÆ·ËùÊôÀà±ð£¬Ïà¹ØÐÅÏ¢£¬¹©»õ³§ÉÌ£¬ÄÚº¬¼þÊý£¬¿â´æ£¬½ø»õ¼Û£¬ÏúÊÛ¼Û£¬ÓŻݼۡ£ÄãºÜ¿ì¾ÍÉè¼Æ³ö4¸ö±í£ºÉÌÆ·ÀàÐͱí(Wares_type)£¬¹©»õ³§É̱í(Wares_provider)£¬ÉÌÆ·ÐÅÏ¢±í(Wares_info)£º
ÉÌÆ·ÀàÐͱí(Wares_type)
Ãû³Æ¡¡¡¡¡¡¡¡¡¡ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
type_id ¡¡ int ¡¡ ÎÞÖظ´¡¡¡¡ Àà±ð±êʶ£¬Ö÷¼ü
type_name¡¡¡¡ char(50) ²»ÔÊÐíΪ¿Õ ÀàÐÍÃû³Æ£¬²»ÔÊÐíÖظ´
type_father int ²»ÔÊÐíΪ¿Õ ¸ÃÀà±ðµÄ¸¸Àà±ð±êʶ£¬Èç¹ûÊǶ¥½ÚµãµÄ»°É趨Ϊij¸öΨһֵ
type_layer char(6) ÏÞ¶¨3²ã,³õʼֵΪ000000 Àà±ðµÄÏÈÐò±éÀú£¬Ö÷ҪΪ¼õÉÙ¼ìË÷Êý¾Ý¿âµÄ´ÎÊý
¹©»õ³§É̱í(Wares_provider)
Ãû³Æ¡¡¡¡¡¡¡¡¡¡ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
provider_id int ¡¡ ÎÞÖظ´¡¡¡¡ ¹©»õÉ̱êʶ£¬Ö÷¼ü
provider_name char(100) ²»ÔÊÐíΪ¿Õ ¹©»õÉÌÃû³Æ
ÉÌÆ·ÐÅÏ¢±í(Wares_info)
Ãû³Æ¡¡¡¡¡¡¡¡ ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
wares_id int ¡¡ ÎÞÖظ´¡¡¡¡ ÉÌÆ·±êʶ£¬Ö÷¼ü
wares_name char(100) ²»ÔÊÐíΪ¿Õ ÉÌÆ·Ãû³Æ
wares_type¡¡¡¡ int ²»ÔÊÐíΪ¿Õ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ÉÌÆ·ÀàÐͱêʶ£¬ºÍWares_type.type_id¹ØÁª
wares_info char(200) ÔÊÐíΪ¿Õ Ïà¹ØÐÅÏ¢
provider int ²»ÔÊÐíΪ¿Õ ¹©»õ³§É̱êʶ£¬ºÍWares_provider.provider_id¹ØÁª
setnum int ³õʼֵΪ1 ÄÚº¬¼þÊý£¬Ä¬ÈÏΪ1
stock int ³õʼֵΪ0 ¿â´æ£¬Ä¬ÈÏΪ0
buy_price money ²»ÔÊÐíΪ¿Õ ½ø»õ¼Û
sell_price money ²»ÔÊÐíΪ¿Õ ÏúÊÛ¼Û
discount money ²»ÔÊÐíΪ¿Õ ÓŻݼÛ
¡¡¡¡ÄãÄÃ×ÅÕâ3¸ö±í¸øÀÏ°å¼ì²é£¬ÀÏ°åÏ£ÍûÄܹ»ÔÙÌí¼ÓÒ»¸öÉÌƷͼƬµÄ×ֶΣ¬²»¹ýÖ»ÓÐÒ»²¿·ÖÉÌÆ·ÓÐͼƬ¡£OK£¬ÄãÔÚÉÌÆ·ÐÅÏ¢±í(Wares_info)ÖÐÔö¼ÓÁËÒ»¸öhaspicµÄBOOLÐÍ×ֶΣ¬È»ºóÔÙ½¨ÁËÒ»¸öбí----ÉÌƷͼƬ±í(Wares_pic)£º
ÉÌƷͼƬ±í(Wares_pic)
Ãû³Æ¡¡¡¡¡¡¡¡ ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
pic_id int ¡¡ ÎÞÖظ´¡¡¡¡ ÉÌƷͼƬ±êʶ£¬Ö÷¼ü
wares_id int ²»ÔÊÐíΪ¿Õ ËùÊôÉÌÆ·±êʶ£¬ºÍWares_info.wares_id¹ØÁª
pic_address¡¡ char(200) ²»ÔÊÐíΪ¿Õ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ͼƬ´æ·Å·¾¶
¡¡¡¡³ÌÐò¿ª·¢Íê³Éºó£¬ÍêÈ«Âú×ãÀÏ°åÄ¿Ç°µÄÒªÇó£¬ÓÚÊÇÕýʽÆôÓá£Ò»¶Îʱ¼äºó£¬ÀÏ°å´òËãÔÚÕâÌ×ƽ̨ÉÏÍƳöеÄÉÌÆ·ÏúÊÛ£¬ÆäÖУ¬Ä³ÀàÉÌÆ·È«²¿¶¼ÐèÌí¼Ó¡°³¤¶È¡±µÄÊôÐÔ¡£µÚÒ»ÂÖÕÛÌÚÀ´ÁË¡¡µ±È»£¬Äã°´ÕÕÌí¼ÓÉÌƷͼƬ±íµÄÀÏ·½·¨£¬ÔÚÉÌÆ·ÐÅÏ¢±í(Wares_info)ÖÐÔö¼ÓÁËÒ»¸öhaslengthµÄBOOLÐÍ×ֶΣ¬ÓÖ½¨ÁËÒ»¸öбí----ÉÌÆ·³¤¶È±í(Wares_length)£º
ÉÌÆ·³¤¶È±í(Wares_length)
Ãû³Æ¡¡¡¡¡¡¡¡ ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
length_id int ¡¡ ÎÞÖظ´¡¡¡¡ ÉÌƷͼƬ±êʶ£¬Ö÷¼ü
wares_id int ²»ÔÊÐíΪ¿Õ ËùÊôÉÌÆ·±êʶ£¬ºÍWares_info.wares_id¹ØÁª
length¡¡ char(20) ²»ÔÊÐíΪ¿Õ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ÉÌÆ·³¤¶È˵Ã÷
¡¡¡¡¸Õ¸Õ¸ÄÍêû¶à¾Ã£¬ÀÏ°åÓÖ´òËãÉÏÒ»ÅúеÄÉÌÆ·£¬Õâ´ÎijÀàÉÌÆ·È«²¿ÐèÒªÌí¼Ó¡°¿í¶È¡±µÄÊôÐÔ¡£ÄãÒ§ÁËÒ§ÑÀ£¬ÓÖÕÕ·½×¥Ò©£¬Ìí¼ÓÁËÉÌÆ·¿í¶È±í(Wares_width)¡£ÓÖ¹ýÁËÒ»¶Îʱ¼ä£¬ÀÏ°åÐÂÉϵÄÉÌÆ·ÖÐÓÐһЩÐèÒªÌí¼Ó¡°¸ß¶È¡±µÄÊôÐÔ£¬ÄãÊDz»ÊÇ¿ªÊ¼¾õµÃÄãËùÉè¼ÆµÄÊý¾Ý¿â°´ÕÕÕâÖÖ·½Ê½Ôö³¤ÏÂÈ¥£¬ºÜ¿ì¾ÍÄܱä³ÉÒ»¸öÃÔ¹¬ÄØ£¿ÄÇô£¬ÓÐûÓÐʲô°ì·¨¶ôÖÆÕâÖÖ²»¿ÉÔ¤¼ûÐÔ£¬µ«È´ÀàËÆÖظ´µÄÊý¾Ý¿âÅòÕÍÄØ£¿ÎÒÔÚÔĶÁ¡¶Ãô½ÝÈí¼þ¿ª·¢£ºÔÔò¡¢Ä£Ê½Óëʵ¼ù¡·Öз¢ÏÖ×÷Õß¾Ù¹ýÀàËƵÄÀý×Ó£º7.3¡¡¡°Copy¡±³ÌÐò¡£ÆäÖУ¬Îҷdz£ÔÞͬÃô½ÝÈí¼þ¿ª·¢Õâ¸ö¹Ûµã£ºÔÚ×î³õ¼¸ºõ²»½øÐÐÔ¤ÏÈÉè¼Æ£¬µ«ÊÇÒ»µ©ÐèÇó·¢Éú±ä»¯£¬´Ëʱ×÷ΪһÃû×·Çó׿ԽµÄ³ÌÐòÔ±£¬Ó¦¸Ã´ÓÍ·Éó²éÕû¸ö¼Ü¹¹Éè¼Æ£¬ÔÚ´Ë´ÎÐÞ¸ÄÖÐÉè¼Æ³öÄܹ»Âú×ãÈÕºóÀàËÆÐ޸ĵÄϵͳ¼Ü¹¹¡£ÏÂÃæÊÇÎÒÔÚÐèÒªÌí¼Ó¡°³¤¶È¡±µÄÊôÐÔʱËùÌṩµÄÐ޸ķ½°¸£º
¡¡¡¡È¥µôÉÌÆ·ÐÅÏ¢±í(Wares_info)ÖеÄhaspic×ֶΣ¬Ìí¼ÓÉÌÆ·¶îÍâÊôÐÔ±í(Wares_ex_property)ºÍÉÌÆ·¶îÍâÐÅÏ¢±í(Wares_ex_info)2¸ö±íÀ´Íê³ÉÌí¼ÓÐÂÊôÐԵŦÄÜ¡£
ÉÌÆ·¶îÍâÊôÐÔ±í(Wares_ex_property)
Ãû³Æ¡¡¡¡¡¡¡¡ ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
ex_pid int ¡¡ ÎÞÖظ´¡¡¡¡ ÉÌÆ·¶îÍâÊôÐÔ±êʶ£¬Ö÷¼ü
p_name char(20) ²»ÔÊÐíΪ¿Õ ¶îÍâÊôÐÔÃû³Æ
ÉÌÆ·¶îÍâÐÅÏ¢±í(Wares_ex_info)
Ãû³Æ¡¡¡¡¡¡¡¡ ÀàÐÍ¡¡¡¡¡¡¡¡Ô¼ÊøÌõ¼þ¡¡¡¡¡¡ ˵Ã÷
ex_iid int ¡¡ ÎÞÖظ´¡¡¡¡ ÉÌÆ·¶îÍâÐÅÏ¢±êʶ£¬Ö÷¼ü
wares_id int ²»ÔÊÐíΪ¿Õ ËùÊôÉÌÆ·±êʶ£¬ºÍWares_info.wares_id¹ØÁª
property_id¡¡ int ²»ÔÊÐíΪ¿Õ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ÉÌÆ·¶îÍâÊôÐÔ±êʶ£¬ºÍWares_ex_property.ex_pid¹ØÁª
property_value char(200) ²»ÔÊÐíΪ¿Õ ÉÌÆ·¶îÍâÊôÐÔÖµ
¡¡¡¡ÔÚÉÌÆ·¶îÍâÊôÐÔ±í(Wares_ex_property)ÖÐÌí¼Ó2Ìõ¼Ç¼£º
ex_pid p_name
1 ÉÌƷͼƬ
2 ÉÌÆ·³¤¶È
¡¡¡¡ÔÙÔÚÕû¸öµç×ÓÉÌÎñƽ̨µÄºǫ́¹ÜÀí¹¦ÄÜÖÐ×·¼ÓÒ»ÏîÉÌÆ·¶îÍâÊôÐÔ¹ÜÀíµÄ¹¦ÄÜ£¬ÒÔºóÌí¼ÓеÄÉÌƷʱ³öÏÖеÄÊôÐÔ£¬Ö»ÐèÀûÓøù¦ÄÜÍùÉÌÆ·¶îÍâÊôÐÔ±í(Wares_ex_property)ÖÐÌí¼ÓÒ»Ìõ¼Ç¼¼´¿É¡£²»Òªº¦Å±仯£¬±»µÚÒ»¿Å×Óµ¯»÷Öв¢²»ÊÇ»µÊ£¬»µµÄÊDZ»Ïàͬ¹ìµÀ·ÉÀ´µÄµÚ¶þ¿Å¡¢µÚÈý¿Å×Óµ¯»÷ÖС£µÚÒ»¿Å×Óµ¯À´µÃÔ½Ô磬ËùÊܵÄÉËÔ½ÖØ£¬Ö®ºóµÄµÖ¿¹Á¦Ò²Ô½Ç¿8)(´ýÐø)
sgh2005 ÓÚ 2005-12-26 09:47:18·¢±í:
ºÃÎÄ£¬Ö§³Ö
win-linux ÓÚ 2005-10-15 00:21:27·¢±í:
ÊܽÌÁË
8g ÓÚ 2005-08-21 00:39:07·¢±í:
Ö§³Ö