oracle sample

Tables (12)

CONTACTS

  • CONTACT_ID — NUMBER — Primary key — NOT NULL
  • CUSTOMER_ID — NUMBER — Foreign key → CUSTOMERS.CUSTOMER_ID — NOT NULL
  • FIRST_NAME — VARCHAR2(255) — NOT NULL
  • LAST_NAME — VARCHAR2(255) — NOT NULL
  • E_MAIL — VARCHAR2(255) — NOT NULL
  • PHONE — NUMBER

COUNTRIES (COUTRIES)

  • COUNTRY_ID — CHAR(2) — Primary key — NOT NULL
  • COUNTRY_NAME — VARCHAR2(40) — NOT NULL
  • Field

CUSTOMERS

  • CUSTOMER_ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(255) — NOT NULL
  • ADDRESS — VARCHAR2(255)
  • WEBSITE — VARCHAR2(255)
  • CREDIT_LIMIT — NUMBER

EMPLOYEES

  • EMPLOYEE_ID — NUMBER — Primary key — NOT NULL
  • FIRST_NAME — VARCHAR(255) — NOT NULL
  • LAST_NAME — VARCHAR(255) — NOT NULL
  • E_MAIL — VARCHAR(255) — NOT NULL
  • PHONE — VARCHAR(50) — NOT NULL
  • HIRE_DATE — DATE — NOT NULL
  • JOB_TITLE — VARCHAR(255) — NOT NULL

INVENTORIES

  • QUANTITY — NUMBER — NOT NULL

LOCATIONS

  • LOCATION_ID — NUMBER — Primary key — NOT NULL
  • ADDRESS — VARCHAR2(255) — NOT NULL
  • POSTAL_CODE — VARCHAR2(20)
  • CITY — VARCHAR(50)
  • STATE — VARCHAR(50)

ORDERS

  • ORDER_ID — NUMBER — Primary key — NOT NULL
  • STATUS — VARCHAR(20) — NOT NULL
  • Field

ORDER_ITEMS

    PRODUCTS

    • PRODUCT_ID — NUMBER — Primary key — NOT NULL
    • PRODUCT_NAME — VARCHAR2(255) — NOT NULL
    • DESCRIPTION — VARCHAR2(2000)
    • STANDARD_COST — NUMBER
    • LIST_PRICE — NUMBER

    PRODUCT_CATEGORIES

    • CATEGORY_ID — NUMBER — Primary key — NOT NULL
    • CATEGORY_NAME — VARCHAR2(255) — NOT NULL

    REGIONS

    • REGION_ID — NUMBER — Primary key — NOT NULL
    • REGION_NAME — VARCHAR2(50) — NOT NULL

    WAREHOUSES

    • WAREHOUSE_ID — NUMBER — Primary key — NOT NULL
    • WAREHOUSE_NAME — VARCHAR(255)