mysql數(shù)據(jù)庫(kù)練習(xí)題-展示頁(yè)
2025-04-05 23:40本頁(yè)面
【正文】 91大熊和小寶貝200111085兒童0132149871如何最快的制作比薩200211114自助9247381001如何成為經(jīng)理人199905091商務(wù)2147428890最短小精悍的詩(shī)200105015文學(xué) 圖書表的表數(shù)據(jù) 訂單表(Tbl_Orders)倫理名物理名屬性主鍵外鍵訂單號(hào)OrderInt (4) 非空是顧客號(hào)CustomerInt(4)參照客戶表訂單日期OrderdateDate發(fā)貨日期ShipdateDate發(fā)貨地點(diǎn)ShipstreetVarchar (18)發(fā)貨城市ShipcityVarchar (15)發(fā)貨省ShipstateVarchar (2)郵編ShipzipVarchar (6) 訂單表的表結(jié)構(gòu)訂單號(hào)顧客號(hào)訂單日期發(fā)貨日期發(fā)貨地點(diǎn)發(fā)貨城市發(fā)貨省郵編100010052003033120030402奧體大街南京江蘇210019100110102003033120030401和會(huì)街南京江蘇210001100210112003033120030401南京路上海上海201100100310012003040120030401南京路上海上海201100100410202003040120030405歐風(fēng)街無(wú)錫江蘇214002100510182003040120030402南大街常州江蘇213000100610032003040120030402洋人街重慶重慶400015100710072003040120030404洋人街重慶重慶400015100810042003040220030403歐風(fēng)街無(wú)錫江蘇214002100910052004040320040405南大街常州江蘇213000101010192004040320040404和平街北京北京100000101110102003040320030405長(zhǎng)安街北京北京1000001012101720050403北京東路南京江蘇210001101310142005040320050404德化街鄭州河南450007101410072003040320030405和平街北京北京1000001015102020050331歐風(fēng)街無(wú)錫江蘇2140021016100320030331長(zhǎng)陽(yáng)街蘇州江蘇215500101710152005033120050405太合路合肥安徽2300011018100120030331江蘇路南京江蘇2100011019101820030331青陽(yáng)路合肥安徽2300011020100820030331梅山新村合肥安徽230001 訂單表的表數(shù)據(jù) 訂單詳細(xì)表(Tbl_Orderitems)倫理名物理名屬性主鍵外鍵訂單號(hào)Order1Int (4) 非空是參照訂單表明細(xì)編號(hào)ItemInt (2) 非空是圖書編號(hào)IsbnVarchar(10)數(shù)量QuantityInt (3) 訂單詳細(xì)表的表結(jié)構(gòu)訂單號(hào)明細(xì)編號(hào)圖書編號(hào)數(shù)量10001343721249011001192473810011100122491748320110021884317211321003188431721131100321059831198110033343721249011004124917483202100512147428890110061995978932111007139571364683100729959789321110073811794939111007488431721131100813437212490210091343721249011009204011407331101018843172113110111249174832011012181179493911101221915762492210123249174832011012404011407331101318843172113110141040114073321015134372124901101612491748320110171811794939111018134372124902101828843172113110191040114073311020134372124901 訂單詳細(xì)表的表數(shù)據(jù) 作者表(Tbl_Author)倫理名物理名屬性主鍵外鍵作者編號(hào)AuthorIdVarchar (4) 非空是姓名NameVarchar (20) 作者表的表結(jié)構(gòu)作者編號(hào)姓名S100薛明J100陳洪A100張二M100劉虎K100陳康P100王立A105吳明B100洪海P105李強(qiáng)W100宮立W105龔佩R100張青F100鐘漢W110韓青 作者表的表數(shù)據(jù) 圖書作者表(Tbl_BookAuthor)倫理名物理名屬性主鍵外鍵圖書編號(hào)IsbnVarchar (10) 非空是作者編號(hào)AuthorIdVarchar (4) 非空是 圖書作者表的表結(jié)構(gòu)圖書編號(hào)作者編號(hào)1059831198S1001059831198P1000401140733J1004981341710K1008843172113P1058843
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1