ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
HR.LOCATIONS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(10)
»
IX.STREAMS_QUEUE_TABLE_(table)
»
public.location_specific_status_changes_(table)
»
HR.LOCATIONS_(table)
[X]
»
Sales.ContactCreditCard_(table)
»
HumanResources.Department_(table)
»
Production.ProductListPriceHistory_(table)
»
IX.AQ$_ORDERS_QUEUETABLE_G_(table)
»
SH.FWEEK_PSCAT_SALES_MV_(table)
»
IX.ORDERS_QUEUETABLE_(table)
»
Sales.SalesOrderDetail_(table)
»
IX.STREAMS_QUEUE_TABLE_(table)
»
public.location_specific_status_changes_(table)
»
HR.LOCATIONS_(table)
Edit
wikibot
Table
HR.LOCATIONS
Column
Data Type
Nullable
Default
PK
Index
LOCATION_ID
NUMBER(4, 0)
not null
LOC_ID_PK
STREET_ADDRESS
VARCHAR2(40)
null
POSTAL_CODE
VARCHAR2(12)
null
CITY
VARCHAR2(30)
not null
LOC_CITY_IX
STATE_PROVINCE
VARCHAR2(25)
null
LOC_STATE_PROVINCE_IX
COUNTRY_ID
CHAR(2)
null
LOC_COUNTRY_IX
Relation
Column
Referenced Column
HR.COUNTRIES
COUNTRY_ID
COUNTRY_ID
Detail Table
Column
Referencing Column
HR.DEPARTMENTS
LOCATION_ID
LOCATION_ID
OE.WAREHOUSES
LOCATION_ID
LOCATION_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.