mysql數(shù)據(jù)庫練習(xí)題-wenkub
2023-04-11 23:40:03 本頁面
【正文】 Books)倫理名物理名屬性主鍵外鍵圖書編號IsbnVarchar (10) 非空是書名TitleVarchar(300)出版日期PubdateDate出版社IDPubidInt(2)成本CostNumeric(5,2)售價RetailNumeric (5,2)種別CategoryVarchar (12)圖 圖書編號書名出版日期出版社ID成本售價種別1059831198一天中10分鐘的身體成分200101214健康0401140733米奇的復(fù)仇20011212122家庭生活4981341710用牙簽造車20020818259兒童8843172113數(shù)據(jù)庫的實現(xiàn)1999060433155計算機(jī)3437212490用蘑菇烹飪200002284烹飪3957136468數(shù)據(jù)庫法寶2001113034775計算機(jī)1915762492電腦手冊2001012132125計算機(jī)9959789321電子商務(wù)的道路2002030223754計算機(jī)2491748320教育孩子_輕松方法20000717548家庭生活0299282519烹飪之路2000091141928烹飪8117949391大熊和小寶貝200111085兒童0132149871如何最快的制作比薩200211114自助9247381001如何成為經(jīng)理人199905091商務(wù)2147428890最短小精悍的詩200105015文學(xué) 圖書表的表數(shù)據(jù) 訂單表(Tbl_Orders)倫理名物理名屬性主鍵外鍵訂單號OrderInt (4) 非空是顧客號CustomerInt(4)參照客戶表訂單日期OrderdateDate發(fā)貨日期ShipdateDate發(fā)貨地點ShipstreetVarchar (18)發(fā)貨城市ShipcityVarchar (15)發(fā)貨省ShipstateVarchar (2)郵編ShipzipVarchar (6) 訂單表的表結(jié)構(gòu)訂單號顧客號訂單日期發(fā)貨日期發(fā)貨地點發(fā)貨城市發(fā)貨省郵編100010052003033120030402奧體大街南京江蘇210019100110102003033120030401和會街南京江蘇210001100210112003033120030401南京路上海上海201100100310012003040120030401南京路上海上海201100100410202003040120030405歐風(fēng)街無錫江蘇214002100510182003040120030402南大街常州江蘇213000100610032003040120030402洋人街重慶重慶400015100710072003040120030404洋人街重慶重慶400015100810042003040220030403歐風(fēng)街無錫江蘇214002100910052004040320040405南大街常州江蘇213000101010192004040320040404和平街北京北京100000101110102003040320030405長安街北京北京1000001012101720050403北京東路南京江蘇210001101310142005040320050404德化街鄭州河南450007101410072003040320030405和平街北京北京1000001015102020050331歐風(fēng)街無錫江蘇2140021016100320030331長陽街蘇州江蘇215500101710152005033120050405太合路合肥安徽2300011018100120030331江蘇路南京江蘇2100011019101820030331青陽路合肥安徽2300011020100820030331梅山新村合肥安徽230001 訂單表的表數(shù)據(jù) 訂單詳細(xì)表(Tbl_Orderitems)倫理名物理名屬性主鍵外鍵訂單號Order1Int (4) 非空是參照訂單表明細(xì)編號ItemInt (2) 非空是圖書編號IsbnVarchar(10)數(shù)量QuantityInt (3) 訂單詳細(xì)表的表結(jié)構(gòu)訂單號明細(xì)編號圖書編號數(shù)量100013437212490110011924738100111001224917483201100218843172113210031884317211311003210598311981100333437212490110041249174832021005121474288901100619959789321110071395713646831007299597893211100738117949391110074884317211311008134372124902100913437212490110092040114073311010188431721131101112491748320110121811794939111012219157624922101232491748320110124040114073311013188431721
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1