market_db

Tables (9)

categories (tb_categories)

  • categoryid (Key) — int(11) — Primary key — NOT NULL
  • categoryname (Field) — varchar(255)
  • description (Field2) — varchar(255)

customers (tb_customers)

  • customerid (Key) — int(11) — Primary key — NOT NULL
  • customername (Field) — varchar(255)
  • contactname (Field2) — varchar(255)
  • City (Field3) — varchar(255)
  • address (Field4) — varchar(255)
  • postalcode (Field5) — varchar(255)
  • Field6 — varchar(255)

employees (tb_employees)

  • employeeid (Key) — int(11) — Primary key — NOT NULL
  • lastname (Field) — varchar(255)
  • firstname (Field2) — varchar(255)
  • birthdate (Field3) — date
  • photo (Field4) — varchar(255)
  • notes (Field5) — varchar(255)

example (Untitled)

    order (tb_order)

    • orderid (Key) — int(11) — Primary key — NOT NULL
    • orderdate (Field3) — date
    • shipperid (Key3) — int(11) — Foreign key → shippers.shipperid — NOT NULL
    • employeeid (Key4) — int(11) — Foreign key → employees.employeeid — NOT NULL
    • customerid (Key2) — int(11) — Foreign key → customers.customerid — NOT NULL

    orderdetails (tb_orderdetails)

    • orderdetailid (Key) — int(11) — Primary key — NOT NULL
    • quantity (Field3) — int(11)
    • orderid (Key2) — int(11) — Foreign key → order.orderid — NOT NULL
    • productid (Key3) — int(11) — Foreign key → products.productid — NOT NULL

    products (tb_products)

    • productid (Key) — int(11) — Primary key — NOT NULL
    • productname (Field) — varchar(255)
    • unit (Field4) — varchar(255)
    • price (Field5) — decimal(5,2)
    • supplierid (Key2) — int(11) — Foreign key → suppliers.supplierid — NOT NULL
    • categoryid (Key3) — int(11) — Foreign key → categories.categoryid — NOT NULL

    shippers (tb_shippers)

    • shipperid (Key) — int(11) — Primary key — NOT NULL
    • shippername (Field) — varchar(255)
    • phone (Field2) — varchar(255)

    suppliers (tb_suppliers)

    • supplierid (Key) — int(11) — Primary key — NOT NULL
    • suppliername (Field) — varchar(255)
    • contactname (Field2) — varchar(255)
    • address (Field3) — varchar(255)
    • city (Field4) — varchar(255)
    • postalcode (Field5) — varchar(255)
    • country (Field6) — varchar(255)
    • phone (Field7) — varchar(255)