HR

Basic Index   Expanded Index

Table Name:COUNTRIES
Description:country table. Contains 25 rows. References with locations table.
Primary Keys:COUNTRY_ID
FieldTypeDefaultsNulls?Comments
COUNTRY_IDCHAR (2)NoneNoPrimary key of countries table.
COUNTRY_NAMEVARCHAR2 (40)NoneYesCountry name
REGION_IDNUMBERNoneYesRegion ID for the country. Foreign key to region_id column in the departments table.

IndexTypeUnique?Fields
COUNTRY_C_ID_PKIOT - TOPYesCOUNTRY_ID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource TableSource Schema
COUNTR_REG_FKREGION_IDREGIONSHR

Primary Key as Foreign Key ConstraintAffected SchemaAffected TableAffected Field
LOC_C_ID_FKHRLOCATIONSCOUNTRY_ID

No triggers