Difference between revisions of "HR.LOCATIONS (table)"

From dbscript Online Help
Jump to: navigation, search
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
| '''table
+
| '''Table
 
| HR.LOCATIONS
 
| HR.LOCATIONS
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
 +
| COUNTRY_ID
 +
| COUNTRY_ID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
 +
| LOCATION_ID
 +
| LOCATION_ID
 +
|-
 +
| [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]]
 +
| LOCATION_ID
 +
| LOCATION_ID
 
|}
 
|}

Revision as of 20:00, 24 August 2009

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