HR.LOCATIONS (table) - Revision history

Bot at 09:33, 27 August 2011

2011-08-27T09:33:57Z

Bot at 05:14, 24 June 2010

2010-06-24T05:14:28Z

Bot at 07:26, 11 February 2010

2010-02-11T07:26:57Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:24Z

Bot at 18:56, 24 August 2009

2009-08-24T18:56:46Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.LOCATIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

2009-05-02T17:05:32Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.LOCATIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| 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
| not null
|
| LOC_ID_PK
|
|-
| STREET_ADDRESS
| VARCHAR2
| null
|
|
|
|-
| POSTAL_CODE
| VARCHAR2
| null
|
|
|
|-
| CITY
| VARCHAR2
| not null
|
|
| LOC_CITY_IX
|-
| STATE_PROVINCE
| VARCHAR2
| 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
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HR.LOCATIONS
@@ Line 11: / Line 11: @@
 locations of customers. Contains 23 rows; references with the
 departments and countries tables.
 |}
 === Columns ===
@@ Line 23: / Line 21: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | LOCATION_ID
 | NUMBER(4, 0)
@@ Line 30: / Line 28: @@
+|
 | Primary key of locations table
-|-
+|- valign="top"
 | STREET_ADDRESS
 | VARCHAR2(40)
@@ Line 37: / Line 35: @@
 | Street address of an office, warehouse, or production site of a company.
 Contains building number and street name
-|-
+|- valign="top"
 | POSTAL_CODE
 | VARCHAR2(12)
@@ Line 44: / Line 42: @@
 | Postal code of the location of an office, warehouse, or production site
 of a company.
-|-
+|- valign="top"
 | CITY
 | VARCHAR2(30)
@@ Line 51: / Line 49: @@
 | A not null column that shows city where an office, warehouse, or
 production site of a company is located.
-|-
+|- valign="top"
 | STATE_PROVINCE
 | VARCHAR2(25)
@@ Line 58: / Line 56: @@
 | State or Province where an office, warehouse, or production site of a
 company is located.
-|-
+|- valign="top"
 | COUNTRY_ID
 | CHAR(2)
@@ Line 72: / Line 70: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | LOC_ID_PK
 | LOCATION_ID
@@ Line 83: / Line 81: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | LOC_STATE_PROVINCE_IX
+|
 | STATE_PROVINCE
-|-
+|- valign="top"
 | LOC_COUNTRY_IX
+|
 | COUNTRY_ID
-|-
+|- valign="top"
 | LOC_CITY_IX
+|
@@ Line 104: / Line 102: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | LOC_CITY_NN
 | "CITY" IS NOT NULL
@@ Line 117: / Line 115: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
 | COUNTRY_ID
@@ Line 130: / Line 128: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
 | LOCATION_ID
 | LOCATION_ID
-|-
+|- valign="top"
 | [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]]
 | LOCATION_ID
 | LOCATION_ID
 |}