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

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''table
+
| '''Table
 
| HR.LOCATIONS
 
| HR.LOCATIONS
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Locations table that contains specific address of a specific office,
 +
warehouse, and/or production site of a company. Does not store addresses /
 +
locations of customers. Contains 23 rows; references with the
 +
departments and countries tables.
 +
|}
 +
 
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| LOCATION_ID
 +
| NUMBER(4, 0)
 +
| not null
 +
|
 +
| Primary key of locations table
 +
|- valign="top"
 +
| STREET_ADDRESS
 +
| VARCHAR2(40)
 +
| null
 +
|
 +
| Street address of an office, warehouse, or production site of a company.
 +
Contains building number and street name
 +
|- valign="top"
 +
| POSTAL_CODE
 +
| VARCHAR2(12)
 +
| null
 +
|
 +
| Postal code of the location of an office, warehouse, or production site
 +
of a company.
 +
|- valign="top"
 +
| CITY
 +
| VARCHAR2(30)
 +
| not null
 +
|
 +
| 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)
 +
| null
 +
|
 +
| State or Province where an office, warehouse, or production site of a
 +
company is located.
 +
|- valign="top"
 +
| COUNTRY_ID
 +
| CHAR(2)
 +
| null
 +
|
 +
| Country where an office, warehouse, or production site of a company is
 +
located. Foreign key to country_id column of the countries table.
 +
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| LOC_ID_PK
 +
| LOCATION_ID
 +
|}
 +
 
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 
 +
|- valign="top"
 +
| LOC_CITY_IX
 +
|
 +
| CITY
 +
|- valign="top"
 +
| LOC_COUNTRY_IX
 +
|
 +
| COUNTRY_ID
 +
|- valign="top"
 +
| LOC_STATE_PROVINCE_IX
 +
|
 +
| STATE_PROVINCE
 +
|}
 +
 
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| LOC_CITY_NN
 +
| "CITY" IS NOT NULL
 +
|
 +
|}
 +
 
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 
 +
|- valign="top"
 +
| [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
 +
| COUNTRY_ID
 +
| COUNTRY_ID
 +
|}
 +
 
 +
=== Detail Tables ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''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
 
|}
 
|}

Latest revision as of 11:33, 27 August 2011

wikibot[edit]

Table HR.LOCATIONS
Description Locations table that contains specific address of a specific office,

warehouse, and/or production site of a company. Does not store addresses / locations of customers. Contains 23 rows; references with the departments and countries tables.

Columns[edit]

Column Data Type Nullable Default Description
LOCATION_ID NUMBER(4, 0) not null Primary key of locations table
STREET_ADDRESS VARCHAR2(40) null Street address of an office, warehouse, or production site of a company.

Contains building number and street name

POSTAL_CODE VARCHAR2(12) null Postal code of the location of an office, warehouse, or production site

of a company.

CITY VARCHAR2(30) not null A not null column that shows city where an office, warehouse, or

production site of a company is located.

STATE_PROVINCE VARCHAR2(25) null State or Province where an office, warehouse, or production site of a

company is located.

COUNTRY_ID CHAR(2) null Country where an office, warehouse, or production site of a company is

located. Foreign key to country_id column of the countries table.

Primary Key[edit]

Primary Key Columns
LOC_ID_PK LOCATION_ID

Indexes[edit]

Index Type Columns
LOC_CITY_IX CITY
LOC_COUNTRY_IX COUNTRY_ID
LOC_STATE_PROVINCE_IX STATE_PROVINCE

Check Constraints[edit]

Check Constraint Expression Description
LOC_CITY_NN "CITY" IS NOT NULL

Foreign Keys[edit]

Relation Column Referenced Column
HR.COUNTRIES COUNTRY_ID COUNTRY_ID

Detail Tables[edit]

Detail Table Column Referencing Column
HR.DEPARTMENTS LOCATION_ID LOCATION_ID
OE.WAREHOUSES LOCATION_ID LOCATION_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=HR.LOCATIONS_(table)&oldid=3051"