Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableHR.LOCATIONS
DescriptionLocations table that contains specific address of a specific office,

Columns

ColumnData TypeNullableDefaultDescription
LOCATION_IDNUMBER(4, 0)not null Primary key of locations table
STREET_ADDRESSVARCHAR2(40)null Street address of an office, warehouse, or production site of a company.
POSTAL_CODEVARCHAR2(12)null Postal code of the location of an office, warehouse, or production site
CITYVARCHAR2(30)not null A not null column that shows city where an office, warehouse, or
STATE_PROVINCEVARCHAR2(25)null State or Province where an office, warehouse, or production site of a
COUNTRY_IDCHAR(2)null Country where an office, warehouse, or production site of a company is

Primary Key

Primary KeyColumns
LOC_ID_PKLOCATION_ID

Indexes

IndexTypeColumns
LOC_CITY_IX CITY
LOC_COUNTRY_IX COUNTRY_ID
LOC_STATE_PROVINCE_IX STATE_PROVINCE

Check Constraints

Check ConstraintExpressionDescription
LOC_CITY_NN"CITY" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
HR.COUNTRIESCOUNTRY_IDCOUNTRY_ID

Detail Tables

Detail TableColumnReferencing Column
HR.DEPARTMENTSLOCATION_IDLOCATION_ID
OE.WAREHOUSESLOCATION_IDLOCATION_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.