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.5.1
• AD_COMPOSITE 4.7.2
• AD_FINALTEXT 4.7.2
• AD_FLTEXTN 4.7.2
• AD_GRAPHIC 4.7.2
• AD_HEADER 4.7.2
• AD_ID 4.7.2
• AD_PHOTO 4.7.2
• AD_SOURCETEXT 4.7.2
• AD_TEXTDOCS_NTAB 4.7.2
• AMOUNT_SOLD 4.11.7

---

C

• CALENBDAR_QUARTER_ID 4.11.8
• CALENDAR_MONTH_DESC 4.11.8
• CALENDAR_MONTH_ID 4.11.8
• CALENDAR_MONTH_NAME 4.11.8
• CALENDAR_MONTH_NUMBER 4.11.8
• CALENDAR_QUARTER_DESC 4.11.8
• CALENDAR_QUARTER_NUMBER 4.11.8
• CALENDAR_WEEK_NUMBER 4.11.8
• CALENDAR_YEAR 4.11.8
• CALENDAR_YEAR_ID 4.11.8
• CATALOG_URL 4.5.6
• CATEGORY_ID 4.5.6
• CHAIN_NO 4.9.1, 4.9.2
• CHANNEL_CLASS 4.11.1
• CHANNEL_CLASS_ID 4.11.1
• CHANNEL_DESC 4.11.1
• CHANNEL_ID 4.11.1, 4.11.2, 4.11.7
• CHANNEL_TOTAL 4.11.1
• CHANNEL_TOTAL_ID 4.11.1
• CITY 4.3.6
• COMMISSION_PCT 4.3.3
• CORRID 4.9.1, 4.9.2
• COUNTRY_ID 4.3.1, 4.11.3, 4.3.6, 4.11.4
• COUNTRY_ISO_CODE 4.11.3
• COUNTRY_NAME 4.3.1, 4.11.3
• COUNTRY_NAME_HIST 4.11.3
• COUNTRY_REGION 4.11.3
• COUNTRY_REGION_ID 4.11.3
• COUNTRY_SUBREGION 4.11.3
• COUNTRY_SUBREGION_ID 4.11.3
• COUNTRY_TOTAL 4.11.3
• COUNTRY_TOTAL_ID 4.11.3
• CREDIT_LIMIT 4.5.1
• CSCN 4.9.1, 4.9.2
• CUST_ADDRESS 4.5.1
• CUST_CITY 4.11.4
• CUST_CITY_ID 4.11.4
• CUST_CREDIT_LIMIT 4.11.4
• CUST_EFF_FROM 4.11.4
• CUST_EFF_TO 4.11.4
• CUST_EMAIL 4.5.1, 4.11.4
• CUST_FIRST_NAME 4.5.1, 4.11.4
• CUST_GENDER 4.11.4
• CUST_GEO_LOCATION 4.5.1
• CUST_ID 4.11.4, 4.11.7
• CUST_INCOME_LEVEL 4.11.4
• CUST_LAST_NAME 4.5.1, 4.11.4
• CUST_MAIN_PHONE_NUMBER 4.11.4
• CUST_MARITAL_STATUS 4.11.4
• CUST_POSTAL_CODE 4.11.4
• CUST_SRC_ID 4.11.4
• CUST_STATE_PROVINCE 4.11.4
• CUST_STATE_PROVINCE_ID 4.11.4
• CUST_STREET_ADDRESS 4.11.4
• CUST_TOTAL 4.11.4
• CUST_TOTAL_ID 4.11.4
• CUST_VALID 4.11.4
• CUST_YEAR_OF_BIRTH 4.11.4
• CUSTOMER_ID 4.5.1, 4.5.3

---

D

• Database Configuration Assistant
  • using to install Sample Schemas 2.1.1
• DATE_OF_BIRTH 4.5.1
• DAY_NAME 4.11.8
• DAY_NUMBER_IN_MONTH 4.11.8
• DAY_NUMBER_IN_WEEK 4.11.8
• DAYS_IN_CAL_MONTH 4.11.8
• DAYS_IN_CAL_QUARTER 4.11.8
• DAYS_IN_CAL_YEAR 4.11.8
• DAYS_IN_FIS_MONTH 4.11.8
• DAYS_IN_FIS_QUARTER 4.11.8
• DAYS_IN_FIS_YEAR 4.11.8
• DELAY 4.9.1, 4.9.2
• DEPARTMENT_ID 4.3.2, 4.3.3, 4.3.5
• DEPARTMENT_NAME 4.3.2
• DEPT table 1
• DEQ_TID 4.9.1, 4.9.2
• DEQ_TIME 4.9.1, 4.9.2
• DEQUEUE_MSGID 4.9.1, 4.9.2
• DSCN 4.9.1, 4.9.2

---

E

• EEQ_UID 4.9.1, 4.9.2
• EMAIL 4.3.3
• EMPLOYEE_ID 4.3.3, 4.3.5
• EMP table 1
• END_DATE 4.3.5
• END_OF_CAL_MONTH 4.11.8
• END_OF_CAL_QUARTER 4.11.8
• END_OF_CAL_YEAR 4.11.8
• END_OF_FIS_MONTH 4.11.8
• END_OF_FIS_QUARTER 4.11.8
• END_OF_FIS_YEAR 4.11.8
• ENQ_TID 4.9.1, 4.9.2
• ENQ_TIME 4.9.1, 4.9.2
• ENQ_UID 4.9.1, 4.9.2
• EO.ORDERS 4.5.3
• EXCEPTION_QSCHEMA 4.9.1, 4.9.2
• EXCEPTION_QUEUE 4.9.1, 4.9.2
• EXPIRATION 4.9.1, 4.9.2

---

F

• FIRST_NAME 4.3.3
• FISCAL_MONTH_DESC 4.11.8
• FISCAL_MONTH_ID 4.11.8
• FISCAL_MONTH_NAME 4.11.8
• FISCAL_MONTH_NUMBER 4.11.8
• FISCAL_QUARTER_DESC 4.11.8
• FISCAL_QUARTER_ID 4.11.8
• FISCAL_QUARTER_NUMBER 4.11.8
• FISCAL_WEEK_NUMBER 4.11.8
• FISCAL_YEAR 4.11.8
• FISCAL_YEAR_ID 4.11.8

---

G

• GENDER 4.5.1

---

H

• HIRE_DATE 4.3.3
• HR.COUNTRIES 4.3.1
• HR.DEPARTMENTS 4.3.2
• HR.EMPLOYEES 4.3.3
• HR.JOB_HISTORY 4.3.5
• HR.JOBS 4.3.4
• HR.LOCATIONS 4.3.6
• HR.REGIONS 4.3.7
• HR schema
  • general description 1.4.1
  • installing 2.1.2

---

I

• INCOME_LEVEL 4.5.1
• installation
  • GitHub 2.2
  • manual, of Sample Schemas 2.2
  • using Database Configuration Assistant 2.1.1
• installing sample schema 2.1
• installing Sample Schemas 2
• Installing Sample Schemas 2.1
• IX.ORDERS_QUEUETABLE 4.9.1
• IX.STREAMS_QUEUE_TABLE 4.9.2
• IX schema
  • general description 1.4.5
  • scripts 4.8

---

J

• JOB_ID 4.3.3, 4.3.4, 4.3.5
• JOB_TITLE 4.3.4

---

L

• LANGUAGE_ID 4.5.5
• LAST_NAME 4.3.3
• LINE_ITEM_ID 4.5.4
• LIST_PRICE 4.5.6
• LOCAL_ORDER_NO 4.9.1, 4.9.2
• LOCATION_ID 4.3.2, 4.3.6, 4.5.7

---

M

• MANAGER_ID 4.3.2, 4.3.3
• MARITAL_STATUS 4.5.1
• MAX_SALARY 4.3.4
• MIN_PRICE 4.5.6
• MIN_SALARY 4.3.4
• MSGID 4.9.1, 4.9.2

---

N

• NLS_LANGUAGE 4.5.1
• NLS_TERRITORY 4.5.1

---

O

• OC subschema
  • general description 1.4.3
• OE.CUSTOMERS 4.5.1
• OE.INVENTORIES 4.5.2
• OE.ORDER_ITEMS 4.5.4
• OE.PRODUCT_DESCRIPTIONS 4.5.5
• OE.PRODUCT_INFORMATION 4.5.6
• OE.WAREHOUSES 4.5.7
• OE schema
  • general description 1.4.2
  • scripts 4.4
• ORDER_DATE 4.5.3
• ORDER_ID 4.5.3, 4.5.4
• ORDER_MODE 4.5.3
• ORDER_STATUS 4.5.3
• ORDER_TOTAL 4.5.3

---

P

• PHONE_NUMBER 4.3.3
• PHONE_NUMBERS 4.5.1
• PM.ONLINE_MEDIA 4.7.1
• PM.PRINT_MEDIA 4.7.2
• PM schema
  • general description 1.4.4
  • scripts 4.6
• POSTAL_CODE 4.3.6
• PRD_CATEGORY_ID 4.11.5
• PRD_EFF_FROM 4.11.5
• PRD_MIN_PRICE 4.11.5
• PRD_PACK_SIZE 4.11.5
• PRIORITY 4.9.1, 4.9.2
• PRMO_CATEGORY_ID 4.11.6
• PROD_CATEGORY 4.11.5
• PROD_CATEGORY_DESC 4.11.5
• PROD_DESC 4.11.5
• PROD_EFF_TO 4.11.5
• PROD_ID 4.11.2, 4.11.7, 4.11.5
• PROD_LIST_PRICE 4.11.5
• PROD_NAME 4.11.5
• PROD_SRC_ID 4.11.5
• PROD_STATUS 4.11.5
• PROD_SUBCATEGORY 4.11.5
• PROD_SUBCATEGORY_DESC 4.11.5
• PROD_SUBCATEGORY_ID 4.11.5
• PROD_SUPPLIER_ID 4.11.5
• PROD_TOTAL 4.11.5
• PROD_TOTAL_ID 4.11.5
• PROD_UNIT_OF_MEASURE 4.11.5
• PROD_VALID 4.11.5
• PROD_WEIGHT_CLASS 4.11.5
• PRODUCT_AUDIO 4.7.1
• PRODUCT_DESCRIPTION 4.5.6
• PRODUCT_ID 4.5.2, 4.7.2, 4.5.4, 4.5.5, 4.5.6, 4.7.1
• PRODUCT_NAME 4.5.6
• PRODUCT_PHOTO 4.7.1
• PRODUCT_PHOTO_SIGNATURE 4.7.1
• PRODUCT_STATUS 4.5.6
• PRODUCT_TESTIMONIALS 4.7.1
• PRODUCT_TEXT 4.7.1
• PRODUCT_THUMBNAIL 4.7.1
• PRODUCT_VIDEO 4.7.1
• PROMO_BEGIN_DATE 4.11.6
• PROMO_CATEGORY 4.11.6
• PROMO_COST 4.11.6
• PROMO_END_DATE 4.11.6
• PROMO_ID 4.11.2, 4.11.6, 4.11.7
• PROMO_NAME 4.11.6
• PROMO_SUBCATEGORY 4.11.6
• PROMO_SUBCATEGORY_ID 4.11.6
• PROMO_TOTAL 4.11.6
• PROMO_TOTAL_ID 4.11.6
• PROMOTION_ID 4.5.3

---

Q

• Q_NAME 4.9.1, 4.9.2
• QUANTITY 4.5.4
• QUANTITY_ON_HAND 4.5.2
• QUANTITY_SOLD 4.11.7

---

R

• RECIPIENT_KEY 4.9.1, 4.9.2
• REGION_ID 4.3.1, 4.3.7
• REGION_NAME 4.3.7
• resetting the Sample Schemas 2.2.1
• RETRY_COUNT 4.9.1, 4.9.2

---

S

• SALARY 4.3.3
• SALES_REP_ID 4.5.3
• sample schema 2.1
• Sample Schema
  • scripts
    • OE 4.4
    • PM 4.6
  • scripts, general information 4
• Sample Schemas
  • design principles 1.2
  • general information 1.1
  • installing 2
  • scripts
    • master 4.1
• SCOTT schema 1
• SENDER_ADDRESS 4.9.1, 4.9.2
• SENDER_NAME 4.9.1, 4.9.2
• SENDER_PROTOCOL 4.9.1, 4.9.2
• SH.CHANNELS 4.11.1
• SH.COSTS 4.11.2
• SH.COUNTRIES 4.11.3
• SH.CUSTOMERS 4.11.4
• SH.PRODUCTS 4.11.5
• SH.SALES 4.11.7
• SH.TIMES 4.11.8
• SH schema
  • general description 1.4.6
  • scripts 4.10
• START_DATE 4.3.5
• STATE 4.9.1, 4.9.2
• STATE_PROVINCE 4.3.6
• STEP_NO 4.9.1, 4.9.2
• STREET_ADDRESS 4.3.6
• SUPPLIER_ID 4.5.6

---

T

• TIME_DESC 4.11.2
• TIME_ID 4.11.7, 4.11.8
• TIME_MANAGER_INFO 4.9.1, 4.9.2
• TRANSLATED_DESCRIPTION 4.5.5
• TRANSLATED_NAME 4.5.5

---

U

• UNIT_COST 4.11.2
• UNIT_PRICE 4.5.4, 4.11.2
• USER_DATA 4.9.1, 4.9.2
• USER_PROP 4.9.1, 4.9.2

---

W

• WAREHOUSE__NAME 4.5.7
• WAREHOUSE_ID 4.5.2, 4.5.7
• WAREHOUSE_SPEC 4.5.7
• WARRANTY_PERIOD 4.5.6
• WEEK_ENDING_DAY 4.11.8
• WEEK_ENDING_DAY_ID 4.11.8
• WEIGHT_CLASS 4.5.6
• WH_GEO_LOCATION 4.5.7