COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
COUNTRY_ID | CHAR(2 BYTE) | No | null | 1 | Primary key of countries table. |
COUNTRY_NAME | VARCHAR2(40 BYTE) | Yes | null | 2 | Country name |
REGION_ID | NUMBER | Yes | null | 3 | Region ID for the country. Foreign key to region_id column in the departments table. |