Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

OE
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

WAREHOUSES

Description

Warehouse data unspecific to any industry.

Columns

Column Datatype Nullable Default value Comment
WAREHOUSE_ID NUMBER(3,0) N   Primary key column.
WAREHOUSE_SPEC XMLTYPE(2000) Y    
WAREHOUSE_NAME VARCHAR2(35) Y    
LOCATION_ID NUMBER(4,0) Y   Primary key column, references hr.locations.location_id.
WH_GEO_LOCATION SDO_GEOMETRY(1) Y   SDO (spatial) column.

Primary key

Primary key Columns
WAREHOUSES_PK WAREHOUSE_ID

Indexes

Index Type Uniqueness Columns
SYS_IL0000029529C00003$$ LOB UNIQUE  
SYS_IL0000029529C00012$$ LOB UNIQUE  
SYS_IL0000029529C00013$$ LOB UNIQUE  
WAREHOUSES_PK NORMAL UNIQUE WAREHOUSE_ID
WHS_LOCATION_IX NORMAL NONUNIQUE LOCATION_ID

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N

Referenced by

Referenced by Constraint
INVENTORIES INVENTORIES_WAREHOUSES_FK

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005