Index

A  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  W  

---

A

• ACCOUNT_MGR_ID 4.8.1
• AD_COMPOSITE 4.10.1
• AD_FINALTEXT 4.10.1
• AD_FLTEXTN 4.10.1
• AD_GRAPHIC 4.10.1
• AD_HEADER 4.10.1
• AD_ID 4.10.1
• AD_PHOTO 4.10.1
• AD_SOURCETEXT 4.10.1
• AD_TEXTDOCS_NTAB 4.10.1
• AMOUNT_SOLD 4.6.7

---

C

• CALENDAR_MONTH_DESC 4.6.8
• CALENDAR_MONTH_ID 4.6.8
• CALENDAR_MONTH_NAME 4.6.8
• CALENDAR_MONTH_NUMBER 4.6.8
• CALENDAR_QUARTER_DESC 4.6.8
• CALENDAR_QUARTER_ID 4.6.8
• CALENDAR_QUARTER_NUMBER 4.6.8
• CALENDAR_WEEK_NUMBER 4.6.8
• CALENDAR_YEAR 4.6.8
• CALENDAR_YEAR_ID 4.6.8
• CATALOG_URL 4.8.6
• CATEGORY_ID 4.8.6
• CHANNEL_CLASS 4.6.1
• CHANNEL_CLASS_ID 4.6.1
• CHANNEL_DESC 4.6.1
• CHANNEL_ID 4.6.1, 4.6.2, 4.6.7
• CHANNEL_TOTAL 4.6.1
• CHANNEL_TOTAL_ID 4.6.1
• CITY 4.2.6
• COMMISSION_PCT 4.2.3
• CO schema 1.4.2
  • objects 4.3
  • scripts 4.3
• COUNTRY_ID 4.2.1, 4.6.3, 4.2.6, 4.6.4
• COUNTRY_ISO_CODE 4.6.3
• COUNTRY_NAME 4.2.1, 4.6.3
• COUNTRY_REGION 4.6.3
• COUNTRY_REGION_ID 4.6.3
• COUNTRY_SUBREGION 4.6.3
• COUNTRY_SUBREGION_ID 4.6.3
• COUNTRY_TOTAL 4.6.3
• COUNTRY_TOTAL_ID 4.6.3
• CREDIT_LIMIT 4.8.1
• CUST_ADDRESS 4.8.1
• CUST_CITY 4.6.4
• CUST_CITY_ID 4.6.4
• CUST_CREDIT_LIMIT 4.6.4
• CUST_EFF_FROM 4.6.4
• CUST_EFF_TO 4.6.4
• CUST_EMAIL 4.6.4, 4.8.1
• CUST_FIRST_NAME 4.6.4, 4.8.1
• CUST_GENDER 4.6.4
• CUST_GEO_LOCATION 4.8.1
• CUST_ID 4.6.4, 4.6.7
• CUST_INCOME_LEVEL 4.6.4
• CUST_LAST_NAME 4.6.4, 4.8.1
• CUST_MAIN_PHONE_NUMBER 4.6.4
• CUST_MARITAL_STATUS 4.6.4
• CUST_POSTAL_CODE 4.6.4
• CUST_SRC_ID 4.6.4
• CUST_STATE_PROVINCE 4.6.4
• CUST_STATE_PROVINCE_ID 4.6.4
• CUST_STREET_ADDRESS 4.6.4
• CUST_TOTAL 4.6.4
• CUST_TOTAL_ID 4.6.4
• CUST_VALID 4.6.4
• CUST_YEAR_OF_BIRTH 4.6.4
• customer_id 4.4.1, 4.4.4, 4.4.6
• CUSTOMER_ID 4.8.1, 4.8.3

---

D

• DATE_OF_BIRTH 4.8.1
• DAY_NAME 4.6.8
• DAY_NUMBER_IN_MONTH 4.6.8
• DAY_NUMBER_IN_WEEK 4.6.8
• DAYS_IN_CAL_MONTH 4.6.8
• DAYS_IN_CAL_QUARTER 4.6.8
• DAYS_IN_CAL_YEAR 4.6.8
• DAYS_IN_FIS_MONTH 4.6.8
• DAYS_IN_FIS_QUARTER 4.6.8
• DAYS_IN_FIS_YEAR 4.6.8
• delivery_address 4.4.6
• DEPARTMENT_ID 4.2.2, 4.2.3, 4.2.5
• DEPARTMENT_NAME 4.2.2

---

E

• EMAIL 4.2.3
• email_id 4.4.1
• EMPLOYEE_ID 4.2.3, 4.2.5
• END_DATE 4.2.5
• END_OF_CAL_MONTH 4.6.8
• END_OF_CAL_QUARTER 4.6.8
• END_OF_CAL_YEAR 4.6.8
• END_OF_FIS_MONTH 4.6.8
• END_OF_FIS_QUARTER 4.6.8
• END_OF_FIS_YEAR 4.6.8
• EO.ORDERS 4.8.3

---

F

• FIRST_NAME 4.2.3
• FISCAL_MONTH_DESC 4.6.8
• FISCAL_MONTH_ID 4.6.8
• FISCAL_MONTH_NAME 4.6.8
• FISCAL_MONTH_NUMBER 4.6.8
• FISCAL_QUARTER_DESC 4.6.8
• FISCAL_QUARTER_ID 4.6.8
• FISCAL_QUARTER_NUMBER 4.6.8
• FISCAL_WEEK_NUMBER 4.6.8
• FISCAL_YEAR 4.6.8
• FISCAL_YEAR_ID 4.6.8
• full_name 4.4.1

---

G

• GENDER 4.8.1

---

H

• HIRE_DATE 4.2.3
• HR.COUNTRIES 4.2.1
• HR.DEPARTMENTS 4.2.2
• HR.EMPLOYEES 4.2.3
• HR.JOB_HISTORY 4.2.5
• HR.JOBS 4.2.4
• HR.LOCATIONS 4.2.6
• HR.REGIONS 4.2.7
• HR schema
  • general description 1.4.1

---

I

• image_charset 4.4.3
• image_filename 4.4.3
• image_last_updated 4.4.3
• image_mime_type 4.4.3
• INCOME_LEVEL 4.8.1
• installation
  • GitHub 2
  • manual, of Sample Schemas 2
• inventory_id 4.4.7

---

J

• JOB_ID 4.2.3, 4.2.4, 4.2.5
• JOB_TITLE 4.2.4

---

L

• LANGUAGE_ID 4.8.5
• LAST_NAME 4.2.3
• latitude 4.4.2
• line_item_id 4.4.5
• LINE_ITEM_ID 4.8.4
• LIST_PRICE 4.8.6
• LOCATION_ID 4.2.2, 4.2.6, 4.8.7
• logo 4.4.2
• logo_charset 4.4.2
• logo_filename 4.4.2
• logo_last_updated 4.4.2
• logo_mime_type 4.4.2
• longitude 4.4.2

---

M

• MANAGER_ID 4.2.2, 4.2.3
• MARITAL_STATUS 4.8.1
• MAX_SALARY 4.2.4
• MIN_PRICE 4.8.6
• MIN_SALARY 4.2.4

---

N

• NLS_LANGUAGE 4.8.1
• NLS_TERRITORY 4.8.1

---

O

• OC subschema
  • general description 1.4.5
• OE.CUSTOMERS 4.8.1
• OE.INVENTORIES 4.8.2
• OE.ORDER_ITEMS 4.8.4
• OE.PRODUCT_DESCRIPTIONS 4.8.5
• OE.PRODUCT_INFORMATION 4.8.6
• OE.WAREHOUSES 4.8.7
• OE schema
  • general description 1.4.4
  • scripts 4.7
• ORDER_DATE 4.8.3
• order_datetime 4.4.4
• order_id 4.4.4, 4.4.5
• ORDER_ID 4.8.3, 4.8.4
• ORDER_MODE 4.8.3
• order_status 4.4.4
• ORDER_STATUS 4.8.3
• ORDER_TOTAL 4.8.3

---

P

• PHONE_NUMBER 4.2.3
• PHONE_NUMBERS 4.8.1
• physical_address 4.4.2
• PM.PRINT_MEDIA 4.10.1
• PM schema
  • general description 1.4.6
  • scripts 4.9
• POSTAL_CODE 4.2.6
• PROD_CATEGORY 4.6.5
• PROD_CATEGORY_DESC 4.6.5
• PROD_CATEGORY_ID 4.6.5
• PROD_DESC 4.6.5
• PROD_EFF_FROM 4.6.5
• PROD_EFF_TO 4.6.5
• PROD_ID 4.6.2, 4.6.7, 4.6.5
• PROD_LIST_PRICE 4.6.5
• PROD_MIN_PRICE 4.6.5
• PROD_NAME 4.6.5
• PROD_PACK_SIZE 4.6.5
• PROD_SRC_ID 4.6.5
• PROD_STATUS 4.6.5
• PROD_SUBCATEGORY 4.6.5
• PROD_SUBCATEGORY_DESC 4.6.5
• PROD_SUBCATEGORY_ID 4.6.5
• PROD_TOTAL 4.6.5
• PROD_TOTAL_ID 4.6.5
• PROD_UNIT_OF_MEASURE 4.6.5
• PROD_VALID 4.6.5
• PROD_WEIGHT_CLASS 4.6.5
• PRODUCT_DESCRIPTION 4.8.6
• product_details 4.4.3
• product_id 4.4.3, 4.4.5, 4.4.7
• PRODUCT_ID 4.8.2, 4.10.1, 4.8.4, 4.8.5, 4.8.6
• product_image 4.4.3
• product_inventory 4.4.7
• product_name 4.4.3
• PRODUCT_NAME 4.8.6
• PRODUCT_STATUS 4.8.6
• PROMO_BEGIN_DATE 4.6.6
• PROMO_CATEGORY 4.6.6
• PROMO_CATEGORY_ID 4.6.6
• PROMO_COST 4.6.6
• PROMO_END_DATE 4.6.6
• PROMO_ID 4.6.2, 4.6.6, 4.6.7
• PROMO_NAME 4.6.6
• PROMO_SUBCATEGORY 4.6.6
• PROMO_SUBCATEGORY_ID 4.6.6
• PROMO_TOTAL 4.6.6
• PROMO_TOTAL_ID 4.6.6
• PROMOTION_ID 4.8.3

---

Q

• quantity 4.4.5
• QUANTITY 4.8.4
• QUANTITY_ON_HAND 4.8.2
• QUANTITY_SOLD 4.6.7

---

R

• REGION_ID 4.2.1, 4.2.7
• REGION_NAME 4.2.7
• resetting the Sample Schemas 2.2

---

S

• SALARY 4.2.3
• SALES_REP_ID 4.8.3
• Sample Schema
  • scripts
    • OE 4.7
    • PM 4.9
  • scripts, general information 4
• Sample Schemas
  • design principles 1.2
  • general information 1.1
• SH.CHANNELS 4.6.1
• SH.COSTS 4.6.2
• SH.COUNTRIES 4.6.3
• SH.CUSTOMERS 4.6.4
• SH.PRODUCTS 4.6.5
• SH.SALES 4.6.7
• SH.TIMES 4.6.8
• shipment_id 4.4.5, 4.4.6
• shipment_status 4.4.6
• SH schema
  • general description 1.4.3
  • scripts 4.5
• START_DATE 4.2.5
• STATE_PROVINCE 4.2.6
• store_id 4.4.2, 4.4.4, 4.4.6, 4.4.7
• store_name 4.4.2
• STREET_ADDRESS 4.2.6
• SUPPLIER_ID 4.6.5, 4.8.6

---

T

• table
  • description 4.4, 4.4.1, 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7
• TIME_ID 4.6.2, 4.6.7, 4.6.8
• TRANSLATED_DESCRIPTION 4.8.5
• TRANSLATED_NAME 4.8.5

---

U

• UNIT_COST 4.6.2
• unit_price 4.4.3, 4.4.5
• UNIT_PRICE 4.6.2, 4.8.4

---

W

• WAREHOUSE__NAME 4.8.7
• WAREHOUSE_ID 4.8.2, 4.8.7
• WAREHOUSE_SPEC 4.8.7
• WARRANTY_PERIOD 4.8.6
• web_address 4.4.2
• WEEK_ENDING_DAY 4.6.8
• WEEK_ENDING_DAY_ID 4.6.8
• WEIGHT_CLASS 4.8.6
• WH_GEO_LOCATION 4.8.7