Constraints

12 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

FK_CONTACTS_CUSTOMERS

CONTACTS.CUSTOMER_ID

CUSTOMERS.CUSTOMER_ID

Cascade on delete

FK_ORDER_ITEMS_ORDERS

ORDER_ITEMS.ORDER_ID

ORDERS.ORDER_ID

Cascade on delete

FK_ORDER_ITEMS_PRODUCTS

ORDER_ITEMS.PRODUCT_ID

PRODUCTS.PRODUCT_ID

Cascade on delete

FK_LOCATIONS_COUNTRIES

LOCATIONS.COUNTRY_ID

COUNTRIES.COUNTRY_ID

Cascade on delete

FK_WAREHOUSES_LOCATIONS

WAREHOUSES.LOCATION_ID

LOCATIONS.LOCATION_ID

Cascade on delete

FK_COUNTRIES_REGIONS

COUNTRIES.REGION_ID

REGIONS.REGION_ID

Cascade on delete

FK_EMPLOYEES_MANAGER

EMPLOYEES.MANAGER_ID

EMPLOYEES.EMPLOYEE_ID

Cascade on delete

FK_PRODUCTS_CATEGORIES

PRODUCTS.CATEGORY_ID

PRODUCT_CATEGORIES.CATEGORY_ID

Cascade on delete

FK_ORDERS_CUSTOMERS

ORDERS.CUSTOMER_ID

CUSTOMERS.CUSTOMER_ID

Cascade on delete

FK_ORDERS_EMPLOYEES

ORDERS.SALESMAN_ID

EMPLOYEES.EMPLOYEE_ID

Null on delete

FK_INVENTORIES_WAREHOUSES

INVENTORIES.WAREHOUSE_ID

WAREHOUSES.WAREHOUSE_ID

Cascade on delete

FK_INVENTORIES_PRODUCTS

INVENTORIES.PRODUCT_ID

PRODUCTS.PRODUCT_ID

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint