0504
Tables (3)
Items (items)
- Item (item) — INT(11) — Primary key — NOT NULL
- Company (company) — VARCHAR(255)
- Create_time (create_time) — datetime
- Shelf_life (shelf_life) — VARCHAR(255)
- Name (name) — INT(11) — Foreign key → Store.Name — NOT NULL
My_Store (my_store)
- Store_id (store_id) — INT(11) — Primary key — NOT NULL
- Location (location) — VARCHAR(255)
- Number (number) — VARCHAR(255)
- Manager (manager) — VARCHAR(255)
Store (store)
- Name (name) — INT(11) — Primary key — NOT NULL
- Price (price) — INT(11)
- Store_id (store_id) — INT(11) — Foreign key → My_Store.Store_id — NOT NULL
- Post (post) — VARCHAR(255)