Project Oracle Demo Schema
Version v090502
Version Date 2009-05-02

Tables
AQ$_ORDERS_QUEUETABLE_G (IX)
Column Data Type Nullable Default PK / Index
MSGID RAW not null PK SYS_IOT_TOP_49905
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49905
NAME VARCHAR2 not null PK SYS_IOT_TOP_49905
ADDRESS# NUMBER not null PK SYS_IOT_TOP_49905
SIGN SYS.AQ$_SIG_PROP null
DBS_SIGN SYS.AQ$_SIG_PROP null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_ORDERS_QUEUETABLE_H (IX)
Column Data Type Nullable Default PK / Index
MSGID RAW not null PK SYS_IOT_TOP_49903
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49903
NAME VARCHAR2 not null PK SYS_IOT_TOP_49903
ADDRESS# NUMBER not null PK SYS_IOT_TOP_49903
DEQUEUE_TIME TIMESTAMP(6) null
TRANSACTION_ID VARCHAR2 null
DEQUEUE_USER VARCHAR2 null
PROPAGATED_MSGID RAW null
RETRY_COUNT NUMBER null
HINT ROWID null
SPARE RAW null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_ORDERS_QUEUETABLE_I (IX)
Column Data Type Nullable Default PK / Index
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49908
NAME VARCHAR2 not null PK SYS_IOT_TOP_49908
QUEUE# NUMBER not null PK SYS_IOT_TOP_49908
MSG_ENQ_TIME TIMESTAMP(6) not null PK SYS_IOT_TOP_49908
MSG_STEP_NO NUMBER not null PK SYS_IOT_TOP_49908
MSG_CHAIN_NO NUMBER not null PK SYS_IOT_TOP_49908
MSG_LOCAL_ORDER_NO NUMBER not null PK SYS_IOT_TOP_49908
MSGID RAW not null PK SYS_IOT_TOP_49908
HINT ROWID null
SPARE RAW null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_ORDERS_QUEUETABLE_S (IX)
Column Data Type Nullable Default PK / Index
SUBSCRIBER_ID NUMBER not null PK SYS_C005062
QUEUE_NAME VARCHAR2 not null
NAME VARCHAR2 null
ADDRESS VARCHAR2 null
PROTOCOL NUMBER null
SUBSCRIBER_TYPE NUMBER null
RULE_NAME VARCHAR2 null
TRANS_NAME VARCHAR2 null
RULESET_NAME VARCHAR2 null
NEGATIVE_RULESET_NAME VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_ORDERS_QUEUETABLE_T (IX)
Column Data Type Nullable Default PK / Index
NEXT_DATE TIMESTAMP(6) not null PK SYS_IOT_TOP_49901
TXN_ID VARCHAR2 not null PK SYS_IOT_TOP_49901
MSGID RAW not null PK SYS_IOT_TOP_49901
ACTION NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_STREAMS_QUEUE_TABLE_G (IX)
Column Data Type Nullable Default PK / Index
MSGID RAW not null PK SYS_IOT_TOP_49922
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49922
NAME VARCHAR2 not null PK SYS_IOT_TOP_49922
ADDRESS# NUMBER not null PK SYS_IOT_TOP_49922
SIGN SYS.AQ$_SIG_PROP null
DBS_SIGN SYS.AQ$_SIG_PROP null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_STREAMS_QUEUE_TABLE_H (IX)
Column Data Type Nullable Default PK / Index
MSGID RAW not null PK SYS_IOT_TOP_49920
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49920
NAME VARCHAR2 not null PK SYS_IOT_TOP_49920
ADDRESS# NUMBER not null PK SYS_IOT_TOP_49920
DEQUEUE_TIME TIMESTAMP(6) null
TRANSACTION_ID VARCHAR2 null
DEQUEUE_USER VARCHAR2 null
PROPAGATED_MSGID RAW null
RETRY_COUNT NUMBER null
HINT ROWID null
SPARE RAW null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_STREAMS_QUEUE_TABLE_I (IX)
Column Data Type Nullable Default PK / Index
SUBSCRIBER# NUMBER not null PK SYS_IOT_TOP_49925
NAME VARCHAR2 not null PK SYS_IOT_TOP_49925
QUEUE# NUMBER not null PK SYS_IOT_TOP_49925
MSG_ENQ_TID VARCHAR2 not null PK SYS_IOT_TOP_49925
SENDER# NUMBER not null PK SYS_IOT_TOP_49925
TXN_STEP# NUMBER not null PK SYS_IOT_TOP_49925
MSG_ENQ_TIME TIMESTAMP(6) not null PK SYS_IOT_TOP_49925
MSG_STEP_NO NUMBER not null PK SYS_IOT_TOP_49925
MSG_CHAIN_NO NUMBER not null PK SYS_IOT_TOP_49925
MSG_LOCAL_ORDER_NO NUMBER not null PK SYS_IOT_TOP_49925
MSGID RAW not null PK SYS_IOT_TOP_49925
HINT ROWID null
SPARE RAW null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_STREAMS_QUEUE_TABLE_S (IX)
Column Data Type Nullable Default PK / Index
SUBSCRIBER_ID NUMBER not null PK SYS_C005070
QUEUE_NAME VARCHAR2 not null
NAME VARCHAR2 null
ADDRESS VARCHAR2 null
PROTOCOL NUMBER null
SUBSCRIBER_TYPE NUMBER null
RULE_NAME VARCHAR2 null
TRANS_NAME VARCHAR2 null
RULESET_NAME VARCHAR2 null
NEGATIVE_RULESET_NAME VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
AQ$_STREAMS_QUEUE_TABLE_T (IX)
Column Data Type Nullable Default PK / Index
NEXT_DATE TIMESTAMP(6) not null PK SYS_IOT_TOP_49918
TXN_ID VARCHAR2 not null PK SYS_IOT_TOP_49918
MSGID RAW not null PK SYS_IOT_TOP_49918
ACTION NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
CAL_MONTH_SALES_MV (SH)
Column Data Type Nullable Default PK / Index
CALENDAR_MONTH_DESC VARCHAR2 not null
DOLLARS NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
CATEGORIES_TAB (OE)
Column Data Type Nullable Default PK / Index
CATEGORY_NAME VARCHAR2 null
CATEGORY_DESCRIPTION VARCHAR2 null
CATEGORY_ID NUMBER not null PK SYS_C005251
PARENT_CATEGORY_ID NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
CHANNELS (SH)
Column Data Type Nullable Default PK / Index
CHANNEL_ID NUMBER not null PK CHANNELS_PK
CHANNEL_DESC VARCHAR2 not null
CHANNEL_CLASS VARCHAR2 not null
CHANNEL_CLASS_ID NUMBER not null
CHANNEL_TOTAL VARCHAR2 not null
CHANNEL_TOTAL_ID NUMBER not null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
COSTS (SH) CHANNEL_ID CHANNEL_ID
SALES (SH) CHANNEL_ID CHANNEL_ID
Triggers
COSTS (SH)
Column Data Type Nullable Default PK / Index
PROD_ID NUMBER not null index COSTS_PROD_BIX
TIME_ID DATE not null index COSTS_TIME_BIX
PROMO_ID NUMBER not null
CHANNEL_ID NUMBER not null
UNIT_COST NUMBER not null
UNIT_PRICE NUMBER not null
Foreign Key Column Referenced Column
CHANNELS (SH) CHANNEL_ID CHANNEL_ID
PRODUCTS (SH) PROD_ID PROD_ID
PROMOTIONS (SH) PROMO_ID PROMO_ID
TIMES (SH) TIME_ID TIME_ID
Detail Table Column Referencing Column
Triggers
COUNTRIES (SH)
Column Data Type Nullable Default PK / Index
COUNTRY_ID NUMBER not null PK COUNTRIES_PK
COUNTRY_ISO_CODE CHAR(2) not null
COUNTRY_NAME VARCHAR2 not null
COUNTRY_SUBREGION VARCHAR2 not null
COUNTRY_SUBREGION_ID NUMBER not null
COUNTRY_REGION VARCHAR2 not null
COUNTRY_REGION_ID NUMBER not null
COUNTRY_TOTAL VARCHAR2 not null
COUNTRY_TOTAL_ID NUMBER not null
COUNTRY_NAME_HIST VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
CUSTOMERS (SH) COUNTRY_ID COUNTRY_ID
Triggers
COUNTRIES (HR)
Column Data Type Nullable Default PK / Index
COUNTRY_ID CHAR(2) not null PK COUNTRY_C_ID_PK
COUNTRY_NAME VARCHAR2 null
REGION_ID NUMBER null
Foreign Key Column Referenced Column
REGIONS (HR) REGION_ID REGION_ID
Detail Table Column Referencing Column
LOCATIONS (HR) COUNTRY_ID COUNTRY_ID
Triggers
CUSTOMERS (OE)
Column Data Type Nullable Default PK / Index
CUSTOMER_ID NUMBER not null PK CUSTOMERS_PK
CUST_FIRST_NAME VARCHAR2 not null
CUST_LAST_NAME VARCHAR2 not null index CUST_LNAME_IX
CUST_ADDRESS OE.CUST_ADDRESS_TYP null
PHONE_NUMBERS OE.PHONE_LIST_TYP null
NLS_LANGUAGE VARCHAR2 null
NLS_TERRITORY VARCHAR2 null
CREDIT_LIMIT NUMBER null
CUST_EMAIL VARCHAR2 null index CUST_EMAIL_IX
ACCOUNT_MGR_ID NUMBER null index CUST_ACCOUNT_MANAGER_IX
CUST_GEO_LOCATION MDSYS.SDO_GEOMETRY null
DATE_OF_BIRTH DATE null
MARITAL_STATUS VARCHAR2 null
GENDER VARCHAR2 null
INCOME_LEVEL VARCHAR2 null
Foreign Key Column Referenced Column
EMPLOYEES (HR) ACCOUNT_MGR_ID EMPLOYEE_ID
Detail Table Column Referencing Column
ORDERS (OE) CUSTOMER_ID CUSTOMER_ID
Triggers
CUSTOMERS (SH)
Column Data Type Nullable Default PK / Index
CUST_ID NUMBER not null PK CUSTOMERS_PK
CUST_FIRST_NAME VARCHAR2 not null
CUST_LAST_NAME VARCHAR2 not null
CUST_GENDER CHAR(1) not null index CUSTOMERS_GENDER_BIX
CUST_YEAR_OF_BIRTH NUMBER not null index CUSTOMERS_YOB_BIX
CUST_MARITAL_STATUS VARCHAR2 null index CUSTOMERS_MARITAL_BIX
CUST_STREET_ADDRESS VARCHAR2 not null
CUST_POSTAL_CODE VARCHAR2 not null
CUST_CITY VARCHAR2 not null
CUST_CITY_ID NUMBER not null
CUST_STATE_PROVINCE VARCHAR2 not null
CUST_STATE_PROVINCE_ID NUMBER not null
COUNTRY_ID NUMBER not null
CUST_MAIN_PHONE_NUMBER VARCHAR2 not null
CUST_INCOME_LEVEL VARCHAR2 null
CUST_CREDIT_LIMIT NUMBER null
CUST_EMAIL VARCHAR2 null
CUST_TOTAL VARCHAR2 not null
CUST_TOTAL_ID NUMBER not null
CUST_SRC_ID NUMBER null
CUST_EFF_FROM DATE null
CUST_EFF_TO DATE null
CUST_VALID VARCHAR2 null
Foreign Key Column Referenced Column
COUNTRIES (SH) COUNTRY_ID COUNTRY_ID
Detail Table Column Referencing Column
SALES (SH) CUST_ID CUST_ID
Triggers
DEPARTMENTS (HR)
Column Data Type Nullable Default PK / Index
DEPARTMENT_ID NUMBER not null PK DEPT_ID_PK
DEPARTMENT_NAME VARCHAR2 not null
MANAGER_ID NUMBER null
LOCATION_ID NUMBER null index DEPT_LOCATION_IX
Foreign Key Column Referenced Column
LOCATIONS (HR) LOCATION_ID LOCATION_ID
EMPLOYEES (HR) MANAGER_ID EMPLOYEE_ID
Detail Table Column Referencing Column
EMPLOYEES (HR) DEPARTMENT_ID DEPARTMENT_ID
JOB_HISTORY (HR) DEPARTMENT_ID DEPARTMENT_ID
Triggers
DR$SUP_TEXT_IDX$I (SH)
Column Data Type Nullable Default PK / Index
TOKEN_TEXT VARCHAR2 not null index DR$SUP_TEXT_IDX$X
TOKEN_TYPE NUMBER not null index DR$SUP_TEXT_IDX$X
TOKEN_FIRST NUMBER not null index DR$SUP_TEXT_IDX$X
TOKEN_LAST NUMBER not null index DR$SUP_TEXT_IDX$X
TOKEN_COUNT NUMBER not null index DR$SUP_TEXT_IDX$X
TOKEN_INFO BLOB null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
DR$SUP_TEXT_IDX$K (SH)
Column Data Type Nullable Default PK / Index
DOCID NUMBER null
TEXTKEY ROWID not null PK SYS_IOT_TOP_50215
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
DR$SUP_TEXT_IDX$N (SH)
Column Data Type Nullable Default PK / Index
NLT_DOCID NUMBER not null PK SYS_IOT_TOP_50220
NLT_MARK CHAR(1) not null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
DR$SUP_TEXT_IDX$R (SH)
Column Data Type Nullable Default PK / Index
ROW_NO NUMBER null
DATA BLOB null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
EMPLOYEES (HR)
Column Data Type Nullable Default PK / Index
EMPLOYEE_ID NUMBER not null PK EMP_EMP_ID_PK
FIRST_NAME VARCHAR2 null index EMP_NAME_IX
LAST_NAME VARCHAR2 not null index EMP_NAME_IX
EMAIL VARCHAR2 not null index EMP_EMAIL_UK
PHONE_NUMBER VARCHAR2 null
HIRE_DATE DATE not null
JOB_ID VARCHAR2 not null index EMP_JOB_IX
SALARY NUMBER null
COMMISSION_PCT NUMBER null
MANAGER_ID NUMBER null index EMP_MANAGER_IX
DEPARTMENT_ID NUMBER null index EMP_DEPARTMENT_IX
Foreign Key Column Referenced Column
DEPARTMENTS (HR) DEPARTMENT_ID DEPARTMENT_ID
JOBS (HR) JOB_ID JOB_ID
EMPLOYEES (HR) MANAGER_ID EMPLOYEE_ID
Detail Table Column Referencing Column
CUSTOMERS (OE) EMPLOYEE_ID ACCOUNT_MGR_ID
DEPARTMENTS (HR) EMPLOYEE_ID MANAGER_ID
EMPLOYEES (HR) EMPLOYEE_ID MANAGER_ID
JOB_HISTORY (HR) EMPLOYEE_ID EMPLOYEE_ID
ORDERS (OE) EMPLOYEE_ID SALES_REP_ID
Triggers
FWEEK_PSCAT_SALES_MV (SH)
Column Data Type Nullable Default PK / Index
WEEK_ENDING_DAY DATE not null index FW_PSC_S_MV_WD_BIX
PROD_SUBCATEGORY VARCHAR2 not null index FW_PSC_S_MV_SUBCAT_BIX
DOLLARS NUMBER null
CHANNEL_ID NUMBER not null index FW_PSC_S_MV_CHAN_BIX
PROMO_ID NUMBER not null index FW_PSC_S_MV_PROMO_BIX
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
INVENTORIES (OE)
Column Data Type Nullable Default PK / Index
PRODUCT_ID NUMBER not null PK INVENTORY_IX
index INV_PRODUCT_IX
WAREHOUSE_ID NUMBER not null PK INVENTORY_IX
QUANTITY_ON_HAND NUMBER not null
Foreign Key Column Referenced Column
PRODUCT_INFORMATION (OE) PRODUCT_ID PRODUCT_ID
WAREHOUSES (OE) WAREHOUSE_ID WAREHOUSE_ID
Detail Table Column Referencing Column
Triggers
JOB_HISTORY (HR)
Column Data Type Nullable Default PK / Index
EMPLOYEE_ID NUMBER not null PK JHIST_EMP_ID_ST_DATE_PK
index JHIST_EMPLOYEE_IX
START_DATE DATE not null PK JHIST_EMP_ID_ST_DATE_PK
END_DATE DATE not null
JOB_ID VARCHAR2 not null index JHIST_JOB_IX
DEPARTMENT_ID NUMBER null index JHIST_DEPARTMENT_IX
Foreign Key Column Referenced Column
DEPARTMENTS (HR) DEPARTMENT_ID DEPARTMENT_ID
EMPLOYEES (HR) EMPLOYEE_ID EMPLOYEE_ID
JOBS (HR) JOB_ID JOB_ID
Detail Table Column Referencing Column
Triggers
JOBS (HR)
Column Data Type Nullable Default PK / Index
JOB_ID VARCHAR2 not null PK JOB_ID_PK
JOB_TITLE VARCHAR2 not null
MIN_SALARY NUMBER null
MAX_SALARY NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
EMPLOYEES (HR) JOB_ID JOB_ID
JOB_HISTORY (HR) JOB_ID JOB_ID
Triggers
LOCATIONS (HR)
Column Data Type Nullable Default PK / Index
LOCATION_ID NUMBER not null PK LOC_ID_PK
STREET_ADDRESS VARCHAR2 null
POSTAL_CODE VARCHAR2 null
CITY VARCHAR2 not null index LOC_CITY_IX
STATE_PROVINCE VARCHAR2 null index LOC_STATE_PROVINCE_IX
COUNTRY_ID CHAR(2) null index LOC_COUNTRY_IX
Foreign Key Column Referenced Column
COUNTRIES (HR) COUNTRY_ID COUNTRY_ID
Detail Table Column Referencing Column
DEPARTMENTS (HR) LOCATION_ID LOCATION_ID
WAREHOUSES (OE) LOCATION_ID LOCATION_ID
Triggers
MVIEW$_EXCEPTIONS (SH)
Column Data Type Nullable Default PK / Index
OWNER VARCHAR2 not null
TABLE_NAME VARCHAR2 not null
DIMENSION_NAME VARCHAR2 not null
RELATIONSHIP VARCHAR2 not null
BAD_ROWID ROWID not null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
ONLINE_MEDIA (PM)
Column Data Type Nullable Default PK / Index
PRODUCT_ID NUMBER not null PK ONLINEMEDIA_PK
PRODUCT_PHOTO ORDSYS.ORDIMAGE null
PRODUCT_PHOTO_SIGNATURE ORDSYS.ORDIMAGESIGNATURE null
PRODUCT_THUMBNAIL ORDSYS.ORDIMAGE null
PRODUCT_VIDEO ORDSYS.ORDVIDEO null
PRODUCT_AUDIO ORDSYS.ORDAUDIO null
PRODUCT_TEXT CLOB null
PRODUCT_TESTIMONIALS ORDSYS.ORDDOC null
Foreign Key Column Referenced Column
PRODUCT_INFORMATION (OE) PRODUCT_ID PRODUCT_ID
Detail Table Column Referencing Column
Triggers
ORDER_ITEMS (OE)
Column Data Type Nullable Default PK / Index
ORDER_ID NUMBER not null PK ORDER_ITEMS_PK
index ITEM_ORDER_IX
index ORDER_ITEMS_UK
LINE_ITEM_ID NUMBER not null PK ORDER_ITEMS_PK
PRODUCT_ID NUMBER not null index ITEM_PRODUCT_IX
index ORDER_ITEMS_UK
UNIT_PRICE NUMBER null
QUANTITY NUMBER null
Foreign Key Column Referenced Column
ORDERS (OE) ORDER_ID ORDER_ID
PRODUCT_INFORMATION (OE) PRODUCT_ID PRODUCT_ID
Detail Table Column Referencing Column
Triggers
ORDERS (OE)
Column Data Type Nullable Default PK / Index
ORDER_ID NUMBER not null PK ORDER_PK
ORDER_DATE TIMESTAMP(6) WITH LOCAL TIME ZONE not null index ORD_ORDER_DATE_IX
ORDER_MODE VARCHAR2 null
CUSTOMER_ID NUMBER not null index ORD_CUSTOMER_IX
ORDER_STATUS NUMBER null
ORDER_TOTAL NUMBER null
SALES_REP_ID NUMBER null index ORD_SALES_REP_IX
PROMOTION_ID NUMBER null
Foreign Key Column Referenced Column
CUSTOMERS (OE) CUSTOMER_ID CUSTOMER_ID
EMPLOYEES (HR) SALES_REP_ID EMPLOYEE_ID
Detail Table Column Referencing Column
ORDER_ITEMS (OE) ORDER_ID ORDER_ID
Triggers
ORDERS_QUEUETABLE (IX)
Column Data Type Nullable Default PK / Index
Q_NAME VARCHAR2 null
MSGID RAW not null PK SYS_C005059
CORRID VARCHAR2 null
PRIORITY NUMBER null
STATE NUMBER null
DELAY TIMESTAMP(6) null
EXPIRATION NUMBER null
TIME_MANAGER_INFO TIMESTAMP(6) null
LOCAL_ORDER_NO NUMBER null
CHAIN_NO NUMBER null
CSCN NUMBER null
DSCN NUMBER null
ENQ_TIME TIMESTAMP(6) null
ENQ_UID VARCHAR2 null
ENQ_TID VARCHAR2 null
DEQ_TIME TIMESTAMP(6) null
DEQ_UID VARCHAR2 null
DEQ_TID VARCHAR2 null
RETRY_COUNT NUMBER null
EXCEPTION_QSCHEMA VARCHAR2 null
EXCEPTION_QUEUE VARCHAR2 null
STEP_NO NUMBER null
RECIPIENT_KEY NUMBER null
DEQUEUE_MSGID RAW null
SENDER_NAME VARCHAR2 null
SENDER_ADDRESS VARCHAR2 null
SENDER_PROTOCOL NUMBER null
USER_DATA IX.ORDER_EVENT_TYP null
USER_PROP SYS.ANYDATA null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
PRINT_MEDIA (PM)
Column Data Type Nullable Default PK / Index
PRODUCT_ID NUMBER not null PK PRINTMEDIA_PK
AD_ID NUMBER not null PK PRINTMEDIA_PK
AD_COMPOSITE BLOB null
AD_SOURCETEXT CLOB null
AD_FINALTEXT CLOB null
AD_FLTEXTN NCLOB null
AD_TEXTDOCS_NTAB PM.TEXTDOC_TAB null index SYS_C005057
AD_PHOTO BLOB null
AD_GRAPHIC BFILE null
AD_HEADER PM.ADHEADER_TYP null
Foreign Key Column Referenced Column
PRODUCT_INFORMATION (OE) PRODUCT_ID PRODUCT_ID
Detail Table Column Referencing Column
Triggers
PRODUCT_DESCRIPTIONS (OE)
Column Data Type Nullable Default PK / Index
PRODUCT_ID NUMBER not null PK PRD_DESC_PK
LANGUAGE_ID VARCHAR2 not null PK PRD_DESC_PK
TRANSLATED_NAME NVARCHAR2 not null index PROD_NAME_IX
TRANSLATED_DESCRIPTION NVARCHAR2 not null
Foreign Key Column Referenced Column
PRODUCT_INFORMATION (OE) PRODUCT_ID PRODUCT_ID
Detail Table Column Referencing Column
Triggers
PRODUCT_INFORMATION (OE)
Column Data Type Nullable Default PK / Index
PRODUCT_ID NUMBER not null PK PRODUCT_INFORMATION_PK
PRODUCT_NAME VARCHAR2 null
PRODUCT_DESCRIPTION VARCHAR2 null
CATEGORY_ID NUMBER null
WEIGHT_CLASS NUMBER null
WARRANTY_PERIOD INTERVAL YEAR(2) TO MONTH null
SUPPLIER_ID NUMBER null index PROD_SUPPLIER_IX
PRODUCT_STATUS VARCHAR2 null
LIST_PRICE NUMBER null
MIN_PRICE NUMBER null
CATALOG_URL VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
INVENTORIES (OE) PRODUCT_ID PRODUCT_ID
ONLINE_MEDIA (PM) PRODUCT_ID PRODUCT_ID
ORDER_ITEMS (OE) PRODUCT_ID PRODUCT_ID
PRODUCT_DESCRIPTIONS (OE) PRODUCT_ID PRODUCT_ID
PRINT_MEDIA (PM) PRODUCT_ID PRODUCT_ID
Triggers
PRODUCT_REF_LIST_NESTEDTAB (OE)
Column Data Type Nullable Default PK / Index
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
PRODUCTS (SH)
Column Data Type Nullable Default PK / Index
PROD_ID NUMBER not null PK PRODUCTS_PK
PROD_NAME VARCHAR2 not null
PROD_DESC VARCHAR2 not null
PROD_SUBCATEGORY VARCHAR2 not null index PRODUCTS_PROD_SUBCAT_IX
PROD_SUBCATEGORY_ID NUMBER not null
PROD_SUBCATEGORY_DESC VARCHAR2 not null
PROD_CATEGORY VARCHAR2 not null index PRODUCTS_PROD_CAT_IX
PROD_CATEGORY_ID NUMBER not null
PROD_CATEGORY_DESC VARCHAR2 not null
PROD_WEIGHT_CLASS NUMBER not null
PROD_UNIT_OF_MEASURE VARCHAR2 null
PROD_PACK_SIZE VARCHAR2 not null
SUPPLIER_ID NUMBER not null
PROD_STATUS VARCHAR2 not null index PRODUCTS_PROD_STATUS_BIX
PROD_LIST_PRICE NUMBER not null
PROD_MIN_PRICE NUMBER not null
PROD_TOTAL VARCHAR2 not null
PROD_TOTAL_ID NUMBER not null
PROD_SRC_ID NUMBER null
PROD_EFF_FROM DATE null
PROD_EFF_TO DATE null
PROD_VALID VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
COSTS (SH) PROD_ID PROD_ID
SALES (SH) PROD_ID PROD_ID
Triggers
PROMOTIONS (SH)
Column Data Type Nullable Default PK / Index
PROMO_ID NUMBER not null PK PROMO_PK
PROMO_NAME VARCHAR2 not null
PROMO_SUBCATEGORY VARCHAR2 not null
PROMO_SUBCATEGORY_ID NUMBER not null
PROMO_CATEGORY VARCHAR2 not null
PROMO_CATEGORY_ID NUMBER not null
PROMO_COST NUMBER not null
PROMO_BEGIN_DATE DATE not null
PROMO_END_DATE DATE not null
PROMO_TOTAL VARCHAR2 not null
PROMO_TOTAL_ID NUMBER not null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
COSTS (SH) PROMO_ID PROMO_ID
SALES (SH) PROMO_ID PROMO_ID
Triggers
PROMOTIONS (OE)
Column Data Type Nullable Default PK / Index
PROMO_ID NUMBER not null PK PROMO_ID_PK
PROMO_NAME VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
PURCHASEORDERS (OE)
Column Data Type Nullable Default PK / Index
SYS_NC_ROWINFO$ SYS.XMLTYPE null
Foreign Key Column Referenced Column
()
Detail Table Column Referencing Column
Triggers
REGIONS (HR)
Column Data Type Nullable Default PK / Index
REGION_ID NUMBER not null PK REG_ID_PK
REGION_NAME VARCHAR2 null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
COUNTRIES (HR) REGION_ID REGION_ID
Triggers
SALES (SH)
Column Data Type Nullable Default PK / Index
PROD_ID NUMBER not null index SALES_PROD_BIX
CUST_ID NUMBER not null index SALES_CUST_BIX
TIME_ID DATE not null index SALES_TIME_BIX
CHANNEL_ID NUMBER not null index SALES_CHANNEL_BIX
PROMO_ID NUMBER not null index SALES_PROMO_BIX
QUANTITY_SOLD NUMBER not null
AMOUNT_SOLD NUMBER not null
Foreign Key Column Referenced Column
CHANNELS (SH) CHANNEL_ID CHANNEL_ID
CUSTOMERS (SH) CUST_ID CUST_ID
PRODUCTS (SH) PROD_ID PROD_ID
PROMOTIONS (SH) PROMO_ID PROMO_ID
TIMES (SH) TIME_ID TIME_ID
Detail Table Column Referencing Column
Triggers
SALES_TRANSACTIONS_EXT (SH)
Column Data Type Nullable Default PK / Index
PROD_ID NUMBER null
CUST_ID NUMBER null
TIME_ID DATE null
CHANNEL_ID NUMBER null
PROMO_ID NUMBER null
QUANTITY_SOLD NUMBER null
AMOUNT_SOLD NUMBER null
UNIT_COST NUMBER null
UNIT_PRICE NUMBER null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
STREAMS_QUEUE_TABLE (IX)
Column Data Type Nullable Default PK / Index
Q_NAME VARCHAR2 null
MSGID RAW not null PK SYS_C005067
CORRID VARCHAR2 null
PRIORITY NUMBER null
STATE NUMBER null
DELAY TIMESTAMP(6) null
EXPIRATION NUMBER null
TIME_MANAGER_INFO TIMESTAMP(6) null
LOCAL_ORDER_NO NUMBER null
CHAIN_NO NUMBER null
CSCN NUMBER null
DSCN NUMBER null
ENQ_TIME TIMESTAMP(6) null
ENQ_UID VARCHAR2 null
ENQ_TID VARCHAR2 null
DEQ_TIME TIMESTAMP(6) null
DEQ_UID VARCHAR2 null
DEQ_TID VARCHAR2 null
RETRY_COUNT NUMBER null
EXCEPTION_QSCHEMA VARCHAR2 null
EXCEPTION_QUEUE VARCHAR2 null
STEP_NO NUMBER null
RECIPIENT_KEY NUMBER null
DEQUEUE_MSGID RAW null
SENDER_NAME VARCHAR2 null
SENDER_ADDRESS VARCHAR2 null
SENDER_PROTOCOL NUMBER null
USER_DATA SYS.ANYDATA null
USER_PROP SYS.ANYDATA null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
STYLESHEET_TAB (OE)
Column Data Type Nullable Default PK / Index
ID NUMBER null
STYLESHEET OE.XMLTYPE null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
SUBCATEGORY_REF_LIST_NESTEDTAB (OE)
Column Data Type Nullable Default PK / Index
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
SUPPLEMENTARY_DEMOGRAPHICS (SH)
Column Data Type Nullable Default PK / Index
CUST_ID NUMBER not null
EDUCATION VARCHAR2 null
OCCUPATION VARCHAR2 null
HOUSEHOLD_SIZE VARCHAR2 null
YRS_RESIDENCE NUMBER null
AFFINITY_CARD NUMBER null
BULK_PACK_DISKETTES NUMBER null
FLAT_PANEL_MONITOR NUMBER null
HOME_THEATER_PACKAGE NUMBER null
BOOKKEEPING_APPLICATION NUMBER null
PRINTER_SUPPLIES NUMBER null
Y_BOX_GAMES NUMBER null
OS_DOC_SET_KANJI NUMBER null
COMMENTS VARCHAR2 null index SUP_TEXT_IDX
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
SYS_IOT_OVER_49905 (IX)
Column Data Type Nullable Default PK / Index
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
SYS_IOT_OVER_49922 (IX)
Column Data Type Nullable Default PK / Index
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
TEXTDOCS_NESTEDTAB (PM)
Column Data Type Nullable Default PK / Index
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
Triggers
TIMES (SH)
Column Data Type Nullable Default PK / Index
TIME_ID DATE not null PK TIMES_PK
DAY_NAME VARCHAR2 not null
DAY_NUMBER_IN_WEEK NUMBER not null
DAY_NUMBER_IN_MONTH NUMBER not null
CALENDAR_WEEK_NUMBER NUMBER not null
FISCAL_WEEK_NUMBER NUMBER not null
WEEK_ENDING_DAY DATE not null
WEEK_ENDING_DAY_ID NUMBER not null
CALENDAR_MONTH_NUMBER NUMBER not null
FISCAL_MONTH_NUMBER NUMBER not null
CALENDAR_MONTH_DESC VARCHAR2 not null
CALENDAR_MONTH_ID NUMBER not null
FISCAL_MONTH_DESC VARCHAR2 not null
FISCAL_MONTH_ID NUMBER not null
DAYS_IN_CAL_MONTH NUMBER not null
DAYS_IN_FIS_MONTH NUMBER not null
END_OF_CAL_MONTH DATE not null
END_OF_FIS_MONTH DATE not null
CALENDAR_MONTH_NAME VARCHAR2 not null
FISCAL_MONTH_NAME VARCHAR2 not null
CALENDAR_QUARTER_DESC CHAR(7) not null
CALENDAR_QUARTER_ID NUMBER not null
FISCAL_QUARTER_DESC CHAR(7) not null
FISCAL_QUARTER_ID NUMBER not null
DAYS_IN_CAL_QUARTER NUMBER not null
DAYS_IN_FIS_QUARTER NUMBER not null
END_OF_CAL_QUARTER DATE not null
END_OF_FIS_QUARTER DATE not null
CALENDAR_QUARTER_NUMBER NUMBER not null
FISCAL_QUARTER_NUMBER NUMBER not null
CALENDAR_YEAR NUMBER not null
CALENDAR_YEAR_ID NUMBER not null
FISCAL_YEAR NUMBER not null
FISCAL_YEAR_ID NUMBER not null
DAYS_IN_CAL_YEAR NUMBER not null
DAYS_IN_FIS_YEAR NUMBER not null
END_OF_CAL_YEAR DATE not null
END_OF_FIS_YEAR DATE not null
Foreign Key Column Referenced Column
Detail Table Column Referencing Column
COSTS (SH) TIME_ID TIME_ID
SALES (SH) TIME_ID TIME_ID
Triggers
WAREHOUSES (OE)
Column Data Type Nullable Default PK / Index
WAREHOUSE_ID NUMBER not null PK WAREHOUSES_PK
WAREHOUSE_SPEC SYS.XMLTYPE null
WAREHOUSE_NAME VARCHAR2 null
LOCATION_ID NUMBER null index WHS_LOCATION_IX
WH_GEO_LOCATION MDSYS.SDO_GEOMETRY null
Foreign Key Column Referenced Column
LOCATIONS (HR) LOCATION_ID LOCATION_ID
Detail Table Column Referencing Column
INVENTORIES (OE) WAREHOUSE_ID WAREHOUSE_ID
Triggers
Views
ACCOUNT_MANAGERS (OE)
            
AQ$ORDERS_QUEUETABLE (IX)
            
AQ$ORDERS_QUEUETABLE_R (IX)
            
AQ$ORDERS_QUEUETABLE_S (IX)
            
AQ$STREAMS_QUEUE_TABLE (IX)
            
AQ$STREAMS_QUEUE_TABLE_R (IX)
            
AQ$STREAMS_QUEUE_TABLE_S (IX)
            
BOMBAY_INVENTORY (OE)
            
CUSTOMERS_VIEW (OE)
            
DEPTVIEW (OE)
            
EMP_DETAILS_VIEW (HR)
            
OC_CORPORATE_CUSTOMERS (OE)
            
OC_CUSTOMERS (OE)
            
OC_INVENTORIES (OE)
            
OC_ORDERS (OE)
            
OC_PRODUCT_INFORMATION (OE)
            
ORDERS_VIEW (OE)
            
PRODUCT_PRICES (OE)
            
PRODUCTS (OE)
            
PROFITS (SH)
            
SYDNEY_INVENTORY (OE)
            
TORONTO_INVENTORY (OE)
            
Procedures
ADD_JOB_HISTORY (HR)
PROCEDURE add_job_history
  (  p_emp_id          job_history.employee_id%type
   , p_start_date      job_history.start_date%type
   , p_end_date        job_history.end_date%type
   , p_job_id          job_history.job_id%type
   , p_department_id   job_history.department_id%type
   )
IS
BEGIN
  INSERT INTO job_history (employee_id, start_date, end_date,
                           job_id, department_id)
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;
SECURE_DML (HR)
PROCEDURE secure_dml
IS
BEGIN
  IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
        OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN
	RAISE_APPLICATION_ERROR (-20205,
		'You may only make changes during normal office hours');
  END IF;
END secure_dml;
Functions
GET_PHONE_NUMBER_F (OE)
FUNCTION get_phone_number_f
  (p_in INTEGER, p_phonelist phone_list_typ)
RETURN VARCHAR2 AS
  TYPE phone_list IS VARRAY(5) OF VARCHAR2(25);
  phone_out varchar2(25) := null;
  v_size INTEGER;
BEGIN
    IF p_phonelist.FIRST IS NULL OR
       p_in > (p_phonelist.LAST + 1) - p_phonelist.FIRST THEN
      RETURN phone_out;
    ELSE
      phone_out := p_phonelist(p_in);
      RETURN phone_out;
    END IF;
END;
Synonyms
Schemas
Types
ADHEADER_TYP (PM)
CREATE TYPE PM.ADHEADER_TYP FROM  NOT NULL
CATALOG_TYP (OE)
CREATE TYPE OE.CATALOG_TYP FROM  NOT NULL
CATEGORY_TYP (OE)
CREATE TYPE OE.CATEGORY_TYP FROM  NOT NULL
COMPOSITE_CATEGORY_TYP (OE)
CREATE TYPE OE.COMPOSITE_CATEGORY_TYP FROM  NOT NULL
CORPORATE_CUSTOMER_TYP (OE)
CREATE TYPE OE.CORPORATE_CUSTOMER_TYP FROM  NOT NULL
CUST_ADDRESS_TYP (OE)
CREATE TYPE OE.CUST_ADDRESS_TYP FROM  NOT NULL
CUSTOMER_TYP (OE)
CREATE TYPE OE.CUSTOMER_TYP FROM  NOT NULL
INVENTORY_LIST_TYP (OE)
CREATE TYPE OE.INVENTORY_LIST_TYP FROM  NOT NULL
INVENTORY_TYP (OE)
CREATE TYPE OE.INVENTORY_TYP FROM  NOT NULL
LEAF_CATEGORY_TYP (OE)
CREATE TYPE OE.LEAF_CATEGORY_TYP FROM  NOT NULL
ORDER_EVENT_TYP (IX)
CREATE TYPE [IX].ORDER_EVENT_TYP FROM  NOT NULL
ORDER_ITEM_LIST_TYP (OE)
CREATE TYPE OE.ORDER_ITEM_LIST_TYP FROM  NOT NULL
ORDER_ITEM_TYP (OE)
CREATE TYPE OE.ORDER_ITEM_TYP FROM  NOT NULL
ORDER_LIST_TYP (OE)
CREATE TYPE OE.ORDER_LIST_TYP FROM  NOT NULL
ORDER_TYP (OE)
CREATE TYPE OE.ORDER_TYP FROM  NOT NULL
PHONE_LIST_TYP (OE)
CREATE TYPE OE.PHONE_LIST_TYP FROM  NOT NULL
PRODUCT_INFORMATION_TYP (OE)
CREATE TYPE OE.PRODUCT_INFORMATION_TYP FROM  NOT NULL
PRODUCT_REF_LIST_TYP (OE)
CREATE TYPE OE.PRODUCT_REF_LIST_TYP FROM  NOT NULL
SUBCATEGORY_REF_LIST_TYP (OE)
CREATE TYPE OE.SUBCATEGORY_REF_LIST_TYP FROM  NOT NULL
SYS_YOID0000050342$ (OE)
CREATE TYPE OE.SYS_YOID0000050342$ FROM  NOT NULL
SYS_YOID0000050344$ (OE)
CREATE TYPE OE.SYS_YOID0000050344$ FROM  NOT NULL
SYS_YOID0000050346$ (OE)
CREATE TYPE OE.SYS_YOID0000050346$ FROM  NOT NULL
SYS_YOID0000050348$ (OE)
CREATE TYPE OE.SYS_YOID0000050348$ FROM  NOT NULL
SYS_YOID0000050350$ (OE)
CREATE TYPE OE.SYS_YOID0000050350$ FROM  NOT NULL
TEXTDOC_TAB (PM)
CREATE TYPE PM.TEXTDOC_TAB FROM  NOT NULL
TEXTDOC_TYP (PM)
CREATE TYPE PM.TEXTDOC_TYP FROM  NOT NULL
WAREHOUSE_TYP (OE)
CREATE TYPE OE.WAREHOUSE_TYP FROM  NOT NULL
XDBPO_ACTION_COLLECTION (OE)
CREATE TYPE OE.XDBPO_ACTION_COLLECTION FROM  NOT NULL
XDBPO_ACTION_TYPE (OE)
CREATE TYPE OE.XDBPO_ACTION_TYPE FROM  NOT NULL
XDBPO_ACTIONS_TYPE (OE)
CREATE TYPE OE.XDBPO_ACTIONS_TYPE FROM  NOT NULL
XDBPO_LINEITEM_COLLECTION (OE)
CREATE TYPE OE.XDBPO_LINEITEM_COLLECTION FROM  NOT NULL
XDBPO_LINEITEM_TYPE (OE)
CREATE TYPE OE.XDBPO_LINEITEM_TYPE FROM  NOT NULL
XDBPO_LINEITEMS_TYPE (OE)
CREATE TYPE OE.XDBPO_LINEITEMS_TYPE FROM  NOT NULL
XDBPO_PART_TYPE (OE)
CREATE TYPE OE.XDBPO_PART_TYPE FROM  NOT NULL
XDBPO_REJECTION_TYPE (OE)
CREATE TYPE OE.XDBPO_REJECTION_TYPE FROM  NOT NULL
XDBPO_SHIPINSTRUCTIONS_TYPE (OE)
CREATE TYPE OE.XDBPO_SHIPINSTRUCTIONS_TYPE FROM  NOT NULL
XDBPO_TYPE (OE)
CREATE TYPE OE.XDBPO_TYPE FROM  NOT NULL
XML Schema Collections

generated by dbscript