HR.COUNTRIES (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Check Constraints 1.4 Foreign Keys 1.5 Detail Tables 1.6 Dependencies

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

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	OE.CUSTOMERS_VIEW