CS

Tables (12)

CONTACTS (contacts)

  • CONTACT ID (contact_id) — NUMBER — Primary key — NOT NULL
  • FIRST NAME (first_name) — VARCHAR2(255) — NOT NULL
  • LAST_NAME (last_name) — VARCHAR2(255) — NOT NULL
  • EMAIL (email) — VARCHAR2(255) — NOT NULL
  • PHONE (phone) — VARCHAR2(20)
  • CUSTOMER ID (customer_id) — NUMBER — Foreign key → CUSTOMERS.CUSTOMER ID — NOT NULL

COUNTRIES (countries)

  • COUNTRY ID (country_id) — CHAR(2) — Primary key — NOT NULL
  • COUNTRY NAME (country_name) — VARCHAR2(40)
  • REGION ID (region_id) — NUMBER — Foreign key → REGIONS.REGION ID — NOT NULL

CUSTOMERS (customers)

  • CUSTOMER ID (customer_id) — NUMBER — Primary key — NOT NULL
  • NAME (name) — VARCHAR2(255) — NOT NULL
  • ADDRESS (address) — VARCHAR2(255)
  • WEBSITE (website) — VARCHAR2(255)
  • CREDIT LIMIT (credit_limit) — NUMBER(8,2)

EMPLOYEES (employees)

  • EMPLOYEE ID (employee_id) — NUMBER — Primary key — NOT NULL
  • FIRST NAME (first_name) — VARCHAR2(255)
  • LAST NAME (last_name) — VARCHAR2(255)
  • EMAIL (email) — VARCHAR2(255)
  • PHONE (phone) — VARCHAR2(50)
  • HIRE DATE (hire_date) — DATE
  • MANAGER ID (manager_id) — NUMBER — Foreign key → EMPLOYEES.EMPLOYEE ID — NOT NULL
  • JOB TITLE (job_title) — VARCHAR2(255)

INVENTORIES (inventories)

  • WAREHOUSE ID (warehouse_id2) — NUMBER(12,0) — Foreign key → WAREHOUSES.WAREHOUSE ID — NOT NULL
  • PRODUCT ID (product_id) — NUMBER(12,0) — Foreign key → PRODUCTS.PRODUCT ID — NOT NULL
  • QUANTITY (quantity) — NUMBER(8,0) — NOT NULL

LOCATIONS (locations)

  • LOCATION ID (location_id) — NUMBER — Primary key — NOT NULL
  • ADDRESS (address) — VARCHAR2(255) — NOT NULL
  • POSTAL CODE (postal_code) — VARCHAR2(20)
  • CITY (city) — VARCHAR2(50)
  • STATE (state) — VARCHAR2(50)
  • COUNTRY ID (country_id) — CHAR(2) — Foreign key → COUNTRIES.COUNTRY ID — NOT NULL

ORDER ITEMS (order_items)

  • ITEM ID (item_id) — NUMBER(12,0) — Primary key — NOT NULL
  • ORDER ID (order_id) — NUMBER(12,0) — Foreign key → ORDERS.ORDER ID — NOT NULL
  • QUANTITY (quantity) — NUMBER(8,2)
  • UNIT PRICE (unit_price) — NUMBER(8,2)
  • PRODUCT ID (product_id) — NUMBER(12,0) — Foreign key → PRODUCTS.PRODUCT ID — NOT NULL

ORDERS (orders)

  • ORDER ID (order_id) — NUMBER — Primary key — NOT NULL
  • CUSTOMER ID (customer_id) — NUMBER — Foreign key → CUSTOMERS.CUSTOMER ID — NOT NULL
  • STATUS (status) — VARCHAR2(20)
  • SALESMAN ID (salesman_id) — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE ID — NOT NULL
  • ORDER DATE (order_date) — DATE

PRODUCT CATEGORIES (product_categories)

  • CATEGORY ID (category_id) — NUMBER — Primary key — NOT NULL
  • CATEGORY NAME (category_name) — VARCHAR2(255)

PRODUCTS (products)

  • PRODUCT ID (product_id) — NUMBER — Primary key — NOT NULL
  • PRODUCT NAME (product_name) — VARCHAR2(255) — NOT NULL
  • DESCRIPTION (description) — VARCHAR2(2000)
  • STANDARD COST (standard_cost) — NUMBER(9,2)
  • LIST PRICE (list_price) — NUMBER(9,2)
  • CATEGORY ID (category_id) — NUMBER — Foreign key → PRODUCT CATEGORIES.CATEGORY ID — NOT NULL

REGIONS (regions)

  • REGION ID (region_id) — NUMBER — Primary key — NOT NULL
  • REGION NAME (region_name) — VARCHAR2(50)

WAREHOUSES (warehouses)

  • WAREHOUSE ID (warehouse_id) — NUMBER — Primary key — NOT NULL
  • WAREHOUSE NAME (warehouse_name) — VARCHAR2(255)
  • LOCATION ID (location_id) — NUMBER(12,0) — Foreign key → LOCATIONS.LOCATION ID — NOT NULL