Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: HR COUNTRIES (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/24 07:58


wikibot

TableHR.COUNTRIES
Descriptioncountry table. Contains 25 rows. References with locations table.

Columns

ColumnData TypeNullableDefaultDescription
COUNTRY_IDCHAR(2)not null Primary key of countries table.
COUNTRY_NAMEVARCHAR2(40)null Country name
REGION_IDNUMBERnull Region ID for the country. Foreign key to region_id column in the departments table.

Primary Key

Primary KeyColumns
COUNTRY_C_ID_PKCOUNTRY_ID

Check Constraints

Check ConstraintExpressionDescription
COUNTRY_ID_NN"COUNTRY_ID" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
HR.REGIONSREGION_IDREGION_ID

Detail Tables

Detail TableColumnReferencing Column
HR.LOCATIONSCOUNTRY_IDCOUNTRY_ID

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewOE.CUSTOMERS_VIEW

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