study_w3schools_erds

Tables (8)

CATEGORIES (Untitled3)

  • CATEGORY_ID — VARCHAR(50) — Primary key — NOT NULL
  • CATEGORY_NAME (Field) — VARCHAR(50)
  • DESCRIPTION (Field2) — VARCHAR(50)

CUSTOMERS (Untitled4)

  • CUSTOMER_ID — VARCHAR(50) — Primary key — NOT NULL
  • CUSTOMERNAME (CUSTOMER_NAME) — VARCHAR(50)
  • CONTACTNAME (CONTACT_NAME) — VARCHAR(50)
  • ADDRESS — VARCHAR(50)
  • CITY — VARCHAR(50)
  • POSTALCODE — VARCHAR(50)
  • COUNTRY — VARCHAR(50)

EMPLOYEES (Untitled6)

  • EMPLOYEE_ID (Key) — VARCHAR(50) — Primary key — NOT NULL
  • LASTNAME (Field) — VARCHAR(50)
  • FISRSTNAME (Field2) — VARCHAR(50)
  • BIRTHDATE (Field3) — VARCHAR(50)
  • PHOTO (Field4) — VARCHAR(50)
  • NOTES (Field5) — VARCHAR(50)

ORDERDETAILS (Untitled2)

  • ORDERDETAIL_ID — VARCHAR(50) — Primary key — NOT NULL
  • ORDER_ID (ORDER_ID2) — VARCHAR(50) — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — VARCHAR(50) — Foreign key → PRODUCTS.PRODUCT_ID — NOT NULL
  • CATEGORY_ID (Key) — VARCHAR(50) — Foreign key → PRODUCTS.CATEGORY_ID — NOT NULL
  • EMPLOYEE_ID (Key2) — VARCHAR(50) — Foreign key → ORDERS.EMPLOYEE_ID — NOT NULL
  • SHIPPER_ID (Key22) — VARCHAR(50) — Foreign key → ORDERS.SHIPPER_ID — NOT NULL
  • CUSTOMER_ID (CUSTOMER_ID2) — VARCHAR(50) — Foreign key → ORDERS.CUSTOMER_ID — NOT NULL
  • SUPPLIER_ID (SUPPLIER_ID2) — VARCHAR(50) — Foreign key → PRODUCTS.SUPPLIER_ID — NOT NULL
  • QUANTITY — VARCHAR(50)

ORDERS (Untitled)

  • ORDER_ID — VARCHAR(50) — Primary key — NOT NULL
  • EMPLOYEE_ID (Key) — VARCHAR(50) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
  • SHIPPER_ID (Key2) — VARCHAR(50) — Foreign key → SHIPPERS.SHIPPER_ID — NOT NULL
  • CUSTOMER_ID (CUSTOMER_ID2) — VARCHAR(50) — Foreign key → CUSTOMERS.CUSTOMER_ID — NOT NULL
  • ORDER_DATE — VARCHAR(50)

PRODUCTS

  • PRODUCT_ID — VARCHAR(50) — Primary key — NOT NULL
  • CATEGORY_ID (Key) — VARCHAR(50) — Foreign key → CATEGORIES.CATEGORY_ID — NOT NULL
  • SUPPLIER_ID (SUPPLIER_ID2) — VARCHAR(50) — Foreign key → SUPPLIERS.SUPPLIER_ID — NOT NULL
  • UNIT — VARCHAR(50)
  • PRICE — VARCHAR(50)

SHIPPERS

  • SHIPPER_ID (Key) — VARCHAR(50) — Primary key — NOT NULL
  • SHIPPER_NAME (Field) — VARCHAR(50)
  • PHONE (Field2) — VARCHAR(50)

SUPPLIERS (Untitled5)

  • SUPPLIER_ID — VARCHAR(50) — Primary key — NOT NULL
  • SUPPLIER_NAME — VARCHAR(50)
  • CONTACT_NAME — VARCHAR(50)
  • ADDRESS — VARCHAR(50)
  • CITYC (CITY) — VARCHAR(50)
  • POSTALCODE — VARCHAR(50)
  • COUNTRY — VARCHAR(50)
  • PHONE — VARCHAR(50)