Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
HR LOCATIONS (table)
Modified on 2011/08/27 12:09
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | 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 |}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.