SQLite format 3 @ ¿ + ¿ .È ø J Í7ó³ ô€ ©J ]3yindexix_readbook_barcodereadbook CREATE INDEX ix_readbook_barcode ON readbook (barcode)] 3yindexix_readbook_card_idreadbookCREATE INDEX ix_readbook_card_id ON readbook (card_id)ƒi ‡%tablereadbookreadbookCREATE TABLE readbook ( id INTEGER NOT NULL, barcode VARCHAR(6), card_id VARCHAR(8), start_date VARCHAR(13), borrow_admin VARCHAR(6), end_date VARCHAR(13), return_admin VARCHAR(6), due_date VARCHAR(13), PRIMARY KEY (id), FOREIGN KEY(barcode) REFERENCES inventory (barcode), FOREIGN KEY(card_id) REFERENCES student (card_id), FOREIGN KEY(borrow_admin) REFERENCES admin (admin_id), FOREIGN KEY(return_admin) REFERENCES admin (admin_id) )ƒ …atableinventoryinventoryCREATE TABLE inventory ( barcode VARCHAR(6) NOT NULL, isbn VARCHAR(13), storage_date VARCHAR(13), location VARCHAR(32), withdraw BOOLEAN, status BOOLEAN, admin VARCHAR(6), PRIMARY KEY (barcode), FOREIGN KEY(isbn) REFERENCES book (isbn), CHECK (withdraw IN (0, 1)), CHECK (status IN (0, 1)), FOREIGN KEY(admin) REFERENCES admin (admin_id) )1E indexsqlite_autoindex_inventory_1inventory ‚R„{tablestudentstudentCREATE TABLE student ( card_id VARCHAR(8) NOT NULL, student_id VARCHAR(9), student_name VARCHAR(32), sex VARCHAR(2), telephone VARCHAR(11), enroll_date VARCHAR(13), valid_date VARCHAR(13), loss BOOLEAN, debt BOOLEAN, PRIMARY KEY (card_id), CHECK (loss IN (0, 1)), CHECK (debt IN (0, 1)) )-A indexsqlite_autoindex_student_1student9‚UtablebookbookCREATE TABLE book ( isbn VARCHAR(13) NOT NULL, book_name VARCHAR(64), author VARCHAR(64), press VARCHAR(32), class_name VARCHAR(64), PRIMARY KEY (isbn) )'; indexsqlite_autoindex_book_1book.‚;tableadminadminCREATE TABLE admin ( admin_id VARCHAR(6) NOT NULL, admin_name VARCHAR(32), password VARCHAR(24), "right" VARCHAR(32), PRIMARY KEY (admin_id) ))= indexsqlite_autoindex_admin_1admin gÏœg 3C201803李丹清2222入库 借书 还书 注销.5201802任雯倩111111入库 借书 还书 /C201801李华123入库 借书 还书 注销 à öëà 201803 201802 201801 ú £Lèˆ · G š:ìˆ ú  'wK7+9787115373991Flask Web开发: 基于Pythonçš„Web应用开发实战(美) 格林布戈著;安道译人民邮电出版社计算机技术b'1-C19787810823620ERP原理与实践苟娟琼,常丹北京交通大学出版社管理社会科学L'17%9787543862326中国知青终结邓贤湖南人民出版社中国文学^ '%7O9787302423287机器学习周志华清华大学出版社自动化技术、计算机技术f 'WC!9787115275790JavaScript 高级程序设计-第3版[美] Nicholas C. Zakas 著李松峰曹力 译C'%79787226044094音乐词典高天康甘肃人民出版社音乐n'137O9787115488763Python深度学习弗朗索瓦.肖莱人民邮电出版社自动化技术、计算机技术Y'+)M978710800982x万历十五年[美]黄仁宇生活.读书.新知三联书店中国史t'o719787302292609 用友ERP生产管理系统实验教程:U8.72版张莉莉清华大学出版社管理社会科学^'%7O9787121204869移动设计傅小贞电子工业出版社自动化技术、计算机技术b'37O9787115335500深入浅出node.js朴灵人民邮电出版社自动化技术、计算机技术U'1719787040273243管理信息系统黄梯云高等教育出版社管理社会科学['=71978704015109XERP原理与应用实训汪清明高等教育出版社管理社会科学 ïÝ•_˃¹q§M;) '9787115373991 '9787810823620'9787543862326'9787302423287 '9787115275790 '9787226044094'9787115488763'978710800982x'9787302292609'9787121204869'9787115335500'9787040273243' 978704015109X ²g I #''16000003161001227任雯女1889020943314726592000001593446400000I #''16000002161001228丹清女1836789000114726592000001593446400000L #''16000001161001222许致立女1892190272214726592000001593446400000 Ú ôçÚ 1600000316000002 16000001 %½ ¹r+äV È  :ó¬eאI » t - æ Ÿ X ʃ<õ®g Ù’K½ E%''; 102348978711537399115472224000001楼,02书架,3层,4排201801E$'';102347978711537399115472224000001楼,02书架,3层,4排201801E#'';102346978711537399115472224000001楼,02书架,3层,4排201801E"''; 102345978730242328715471304510001楼,02书架,3层,4排201801E!''; 203773978781082362015173280000002楼,03书架,7层,7排201802E ''; 203772978781082362015173280000002楼,03书架,7层,7排201802E''; 203771978781082362015173280000002楼,03书架,7层,7排201802E''; 411362978754386232615169824000004楼,11书架,3层,6排201801E''; 411361978754386232615169824000004楼,11书架,3层,6排201801E''; 308373978711527579015163776000003楼,08书架,3层,7排201801E''; 308372978711527579015163776000003楼,08书架,3层,7排201801E''; 308371978711527579015163776000003楼,08书架,3层,7排201801E''; 401282978722604409415157728000004楼,01书架,2层,8排201801E''; 401281978722604409415157728000004楼,01书架,2层,8排201801E''; 309333978711548876315150816000003楼,09书架,3层,3排201801E''; 309332978711548876315150816000003楼,09书架,3层,3排201801E''; 309331978711548876315150816000003楼,09书架,3层,3排201801E''; 310323978710800982x15175872000003楼,10书架,3层,2排201802E''; 310322978710800982x15175872000003楼,10书架,3层,2排201802E''; 310321978710800982x15175872000003楼,10书架,3层,2排201802E''; 104345978712120486915148224000001楼,04书架,3层,4排201801E''; 104344978712120486915463584000001楼,04书架,3层,4排201801E''; 104343978711533550015149952000001楼,04书架,3层,4排201801E''; 104342978711533550015149952000001楼,04书架,3层,4排201801E ''; 104341978711533550015149952000001楼,04书架,3层,4排201801E''; 202332978704027324315157728000002楼,02书架,3层,3排201802E'';202331978704027324315157728000002楼,02书架,3层,3排201802E ''; 201233978704015109X15151680000002楼,01书架,2层,3排201801E ''; 201232978704015109X15151680000002楼,01书架,2层,3排201801E''; 201231978704015109X15151680000002楼,01书架,2层,3排201801E''; 211413978730229260915147360000002楼,11书架,4层,1排201801E''; 211412978730229260915147360000002楼,11书架,4层,1排201801E''; 211411978730229260915147360000002楼,11书架,4层,1排201801E''; 102344978730242328715147360000001楼,02书架,3层,4排201801E''; 102343978730242328715147360000001楼,02书架,3层,4排201801E''; 102342978730242328715147360000001楼,02书架,3层,4排201801E'';102341978730242328715147360000001楼,02书架,3层,4排201801 À ˆö©ëˆ“Õž´àÊ ãØÍ;0%ùî· 203773! 203772 203771 411362 411361 308373 308372 308371 401282 401281 309333 309332 309331 310323 310322 310321 104345 104344 104343 104342 104341 202332 102347 202331 211411 102341 309333 310322 203773 310321 102342 102341 %j öëàÕ‹€ujrg\QF©ž“ˆ}¬¡–Ê¿´ãØÍ;0%ùî· 102348% 102347$ 102346# 102345" 203773! 203772 203771 411362 411361 308373 308372 308371 401282 401281 309333 309332 309331 310323 310322 310321 104345 104344 104343 104342 104341 202332 202331 201233 201232 201231 211413 211412 211411 102344 102343 102342 102341 T ´hЄ ÿK Æ  T 97 ' '10234716000001154722240000020180115506784000007 ' '20233116000003154722240000020180115506784000007 ' '2114111600000315472224000002018011550678400000J '''309333160000011546358400000201801154722240000020180115498144000007 ' '1023411600000115472224000002018011550678400000J '''31032216000002154601280000020180115468768000002018021549468800000J '''20377316000001154601280000020180115467904000002018021549468800000J '''31032116000001154601280000020180115467904000002018011549468800000J '''10234216000002154592640000020180115468768000002018011549382400000J '''10234116000001154437120000020180115467040000002018011547827200000 ¶ rôÚͦ™rçÀŒ 1600000116000003 16000003 1600000116000001 16000002160000011600000116000002 16000001