From dbscript Online Help
wikibot
| Table
|
OE.WAREHOUSES
|
| Description
|
Warehouse data unspecific to any industry.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| WAREHOUSE_ID
|
NUMBER(3, 0)
|
not null
|
|
Primary key column.
|
| WAREHOUSE_SPEC
|
SYS.XMLTYPE
|
null
|
|
|
| WAREHOUSE_NAME
|
VARCHAR2(35)
|
null
|
|
|
| LOCATION_ID
|
NUMBER(4, 0)
|
null
|
|
|
| WH_GEO_LOCATION
|
MDSYS.SDO_GEOMETRY
|
null
|
|
Primary key column, references hr.locations.location_id.
|
Primary Key
| Primary Key
|
Columns
|
| WAREHOUSES_PK
|
WAREHOUSE_ID
|
Indexes
| Index
|
Type
|
Columns
|
| WHS_LOCATION_IX
|
|
LOCATION_ID
|
Foreign Keys
| Relation
|
Column
|
Referenced Column
|
| HR.LOCATIONS
|
LOCATION_ID
|
LOCATION_ID
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| OE.INVENTORIES
|
WAREHOUSE_ID
|
WAREHOUSE_ID
|
