HR.COUNTRIES (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table HR.COUNTRIES
Description country table. Contains 25 rows. References with locations table.

Columns

Column Data Type Nullable Default Description
COUNTRY_ID CHAR(2) not null Primary key of countries table.
COUNTRY_NAME VARCHAR2(40) null Country name
REGION_ID NUMBER null Region ID for the country. Foreign key to region_id column in the departments table.

Primary Key

Primary Key Columns
COUNTRY_C_ID_PK COUNTRY_ID

Check Constraints

Check Constraint Expression Description
COUNTRY_ID_NN "COUNTRY_ID" IS NOT NULL

Foreign Keys

Relation Column Referenced Column
HR.REGIONS REGION_ID REGION_ID

Detail Tables

Detail Table Column Referencing Column
HR.LOCATIONS COUNTRY_ID COUNTRY_ID