ScrewTurn Wiki

Edit

wikibot

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

Edit

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.

Edit

Primary Key

Primary KeyColumns
COUNTRY_C_ID_PKCOUNTRY_ID

Edit

Check Constraints

Check ConstraintExpressionDescription
COUNTRY_ID_NN"COUNTRY_ID" IS NOT NULL 

Edit

Foreign Keys

RelationColumnReferenced Column
HR.REGIONSREGION_IDREGION_ID

Edit

Detail Tables

Detail TableColumnReferencing Column
HR.LOCATIONSCOUNTRY_IDCOUNTRY_ID

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