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)