Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: OE WAREHOUSES (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:19


wikibot

TableOE.WAREHOUSES
DescriptionWarehouse data unspecific to any industry.

Columns

ColumnData TypeNullableDefaultDescription
WAREHOUSE_IDNUMBER(3, 0)not null Primary key column.
WAREHOUSE_SPECSYS.XMLTYPEnull  
WAREHOUSE_NAMEVARCHAR2(35)null  
LOCATION_IDNUMBER(4, 0)null  
WH_GEO_LOCATIONMDSYS.SDO_GEOMETRYnull Primary key column, references hr.locations.location_id.

Primary Key

Primary KeyColumns
WAREHOUSES_PKWAREHOUSE_ID

Indexes

IndexTypeColumns
WHS_LOCATION_IX LOCATION_ID

Foreign Keys

RelationColumnReferenced Column
HR.LOCATIONSLOCATION_IDLOCATION_ID

Detail Tables

Detail TableColumnReferencing Column
OE.INVENTORIESWAREHOUSE_IDWAREHOUSE_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.