HR COUNTRIES (table)

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