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)

Untitled

    customer

    • Custid (custid) — INT(11) — Primary key — NOT NULL
    • Name (name) — VARCHAR(10)
    • Email (email) — VARCHAR(50)
    • Phone (phone) — VARCHAR(50)