【文章內(nèi)容簡介】 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )商品退庫s p xx*o**oooooooooos p i ds p n a m exi n g h a ol b i dl b n a m edwj h p r i cech p r i ces cj jk cs lk czjm i n n u mcs n a m es t a t ebzV a r i a b l e ch a r a ct e r s ( 1 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 1 0 )L o n g f l o a tL o n g f l o a tL o n g f l o a tI n t e g e rL o n g f l o a tI n t e g e rV a r i a b l e ch a r a ct e r s ( 5 0 )V a r i a b l e ch a r a ct e r s ( 1 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )商品s p l bool b i dl b n a m ep i dS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 2 0 )I n t e g e r商品類別s p d w*d w i dd w n a m eS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 2 0 )貨物單位r o l e m e n ur o l e i dm e n u i dI n t e g e rI n t e g e r角色菜單r o l e*or o l e i dr o l e n a m ebzS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 1 0 0 )角色表m e n u*oo*oom e n u i dm e n u n a m ep i dm e n u u r lm e n u t yp eo r d e r n u mi co nI n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 1 0 0 )I n t e g e rI n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )菜單目錄kh*ooook h i dk h n a m el xr e nl xt e la d d r e s sbzS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 5 0 )V a r i a b l e ch a r a ct e r s ( 3 0 )V a r i a b l e ch a r a ct e r s ( 3 0 )V a r i a b l e ch a r a ct e r s ( 5 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )客戶j h d s p**ooooooooidd j i ds p i ds p n a m es p d ws p xi n g h a ol b i dl b n a m edjslzjS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 1 4 )V a r i a b l e ch a r a ct e r s ( 1 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )L o n g f l o a tI n t e g e rL o n g f l o a t進(jìn)貨單商品j h doo*ooooood j i dg ys i dg ys n a m er i q iyf j es f j ej ys t a t eu s e r i du s e r n a m ebzV a r i a b l e ch a r a ct e r s ( 1 4 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 5 0 )D a t eL o n g f l o a tL o n g f l o a tV a r i a b l e ch a r a ct e r s ( 2 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )進(jìn)貨單g ys*oooog ys i dn a m el xr e nl xt e la d d r e s sbzS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 5 0 )V a r i a b l e ch a r a ct e r s ( 3 0 )V a r i a b l e ch a r a ct e r s ( 3 0 )V a r i a b l e ch a r a ct e r s ( 5 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )供應(yīng)商ck d s p**ooooooooidd j i ds p i ds p n a m es p d ws p xi n g h a ol b i dl b n a m edjslzjS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 1 4 )V a r i a b l e ch a r a ct e r s ( 1 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )L o n g f l o a tI n t e g e rL o n g f l o a t銷售單商品ck doo*oooooood j i dk h i dk h n a m er i q iyf j es f j ecb j ej ys t a t eu s e r i du s e r n a m ebzV a r i a b l e ch a r a ct e r s ( 1 4 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 5 0 )D a t eL o n g f l o a tL o n g f l o a tL o n g f l o a tV a r i a b l e ch a r a ct e r s ( 2 )I n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )銷售出庫b yd s p**ooooooidd j i ds p i ds p n a m es p d ws p xi n g h a odjslzjS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 1 4 )V a r i a b l e ch a r a ct e r s ( 1 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )L o n g f l o a tI n t e g e rL o n g f l o a t報(bào)溢單商品b yd*oood j i dr i q iu s e r i du s e r n a m ebzV a r i a b l e ch a r a ct e r s ( 1 4 )D a t eI n t e g e rV a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 0 )報(bào)溢單b s d s p**ooooooidd j i ds p i ds p n a m es p d ws p xi n g h a odjslzjS e r i a l ( 1 1 )V a r i a b l e ch a r a ct e r s ( 1 4 )V a r i a b l e ch a r a ct e r s ( 1 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )V a r i a b l e ch a r a ct e r s ( 2 0 )L o n g f l o a tI n t e g e rL o n g f l o a t報(bào)損單商品 圖 41 數(shù)據(jù)庫邏輯關(guān)系圖 圖 42 數(shù)據(jù)表的關(guān)系圖 14 表 43 數(shù)據(jù)庫數(shù)據(jù)表中英文對(duì)照 銷售出庫 ckd 客戶 kh 銷售單商品 ckdsp 進(jìn)貨單 jhd 進(jìn)貨單商品 jhdsp 供應(yīng)商 gys 客戶退貨 tkd 客戶退貨商品 tkdsp 商品退庫 thd 退貨單商品 thdsp 菜單目錄 menu 角色菜單 rolemenu 角色表 role 用戶表 users 報(bào)損單 bsd 報(bào)損單商品 bsdsp 報(bào)溢單 byd 報(bào)溢單商品 bydsp 商品 spxx 商品類別 splb VIEW vusermenu 貨物單位 spdw 15 部分 SQL 語句： DROP TABLE IF EXISTS `spxx`。 CREATE TABLE `spxx` ( `spid` varchar(10) NOT NULL COMMENT 39。商品 id39。, `spname` varchar(20) NOT NULL COMMENT 39。貨物名稱 39。, `xinghao` varchar(20) default NULL COMMENT 39。型號(hào) 39。, `lbid` int(11) NOT NULL COMMENT 39。類別 id39。, `lbname` varchar(20) NOT NULL, `dw` varchar(10) default NULL COMMENT 39。單位 39。, `jhprice` double default 39。039。, `chprice` double default 39。039。, `kcsl` int(11) default 39。039。,`kczj` dou