0504
Tables (4)
Category (category)
- Category id (category_id) — INT(11) — Primary key — NOT NULL
- Category Name (category_name) — VARCHAR(255)
Master (master)
- Key — Primary key — NOT NULL
- Product id (product_id) — INT(11) — Foreign key → Product.Product id — NOT NULL
- Category id (category_id) — INT(11) — Foreign key → Product.Category id — NOT NULL
- Store id (store_id) — INT(11) — Foreign key → Store.Store id — NOT NULL
Product (product)
- Product id (product_id) — INT(11) — Primary key — NOT NULL
- Category id (category_id) — INT(11) — Foreign key → Category.Category id — NOT NULL
- Product Name (product_name) — VARCHAR(255)
- Product Price (product_price) — INT(11)
- Product Count (product_count) — INT(11)
Store (store)
- Store id (store_id) — INT(11) — Primary key — NOT NULL
- Store Name (store_name) — VARCHAR(255)
- Store Location (Store_location) — VARCHAR(255)