fisaai6
Tables (4)
Orders (orders)
- Orderid (orderid) — INT — Primary key — NOT NULL
- Custid (custid2) — INT(11) — Foreign key → customer.Custid — NOT NULL
- Productid (productid) — INT(11) — Foreign key → Product.Productid — NOT NULL
- Orderdate (orderdate) — DATE
Product
- Productid (productid) — INT(11) — Primary key — NOT NULL
- Product_name (product_name) — VARCHAR(20)
- Price (price) — INT(11)
- Quantity (quantity) — INT(11)
customer
- Custid (custid) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(10)
- Email (email) — VARCHAR(50)
- Phone (phone) — VARCHAR(50)