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 »
Back
History
HR.LOCATIONS_(table)
== 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 2.0.36. Some of the icons created by
FamFamFam
.