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)
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)