HR
| Table Name: | COUNTRIES |
| Description: | country table. Contains 25 rows. References with locations table. |
| Primary Keys: | COUNTRY_ID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| COUNTRY_ID | CHAR (2) | None | No | Primary key of countries table. |
| COUNTRY_NAME | VARCHAR2 (40) | None | Yes | Country name |
| REGION_ID | NUMBER | None | Yes | Region ID for the country. Foreign key to region_id column in the departments table. |
| Index | Type | Unique? | Fields |
|---|---|---|---|
| COUNTRY_C_ID_PK | IOT - TOP | Yes | COUNTRY_ID |
| Internal Foreign Key Constraint | Affected Field | Source Table | Source Schema |
|---|---|---|---|
| COUNTR_REG_FK | REGION_ID | REGIONS | HR |
| Primary Key as Foreign Key Constraint | Affected Schema | Affected Table | Affected Field |
|---|---|---|---|
| LOC_C_ID_FK | HR | LOCATIONS | COUNTRY_ID |