ʵÌå
Products(id, p_name, description, price, quantity) Item(id, product_id, quantity)
Shoppinglists(id, manipulator_type, total ,time) manipulator(id, m_name, password£¬type)
½âÊÍ
Ò»¸ö¹ºÎïÇåµ¥has manyÉÌÆ·Ïî(Item) Ò»¸öÉÌÆ·Ïîbelongs toÉÌÆ·ºÍ¹ºÎïÇåµ¥ ²Ù×÷Õß·ÖΪ¹ÜÀíÔ±ºÍ¹Ë¿Í
²Ù×÷
1.¹ÜÀíÔ±:
´´½¨ÉÌÆ· É趨ÉÌÆ·¸÷ÊôÐÔÖµ Éú³É¹ºÎïÇåµ¥Ôö²¹ÉÌÆ· ɾ³ýÉÌÆ· ä¯ÀÀ/²éѯ¹ºÎïÇåµ¥Áбí
2.¹Ë¿Í:
ä¯ÀÀÉÌÆ· Éú³É¹ºÎïÇåµ¥¹ºÂò(¼õÉÙ)ÉÌÆ·
(P.S.×¢²áʱ·ÀÖ¹¹Ë¿ÍÓû§×¢²áΪ¹ÜÀíÔ±)