0504_workshop
Tables (3)
Product (products)
- Product_id (product_id) — BIGINT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Price (price)
Stock (stocks)
- Stock_id (stock_id) — BININT(11) — Primary key — NOT NULL
- Product_id (product_id) — BIGINT(11) — Foreign key → Product.Product_id — NOT NULL
- Store_id (store_id) — BIGINT(11) — Foreign key → Store.Store_id — NOT NULL
- Expiration_Date (expiration_date)
Store (stores)
- Store_id (store_id) — BIGINT(11) — Primary key — NOT NULL
- Adress (adress) — VARCHAR(255)
- Name (name) — VARCHAR(255)
- Phone_number (phone_number) — VARCHAR(255)
- Manager (manager) — VARCHAR(255)