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
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)