Editing HR.COUNTRIES (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| HR.COUNTRIES | | HR.COUNTRIES | ||
Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| country table. Contains 25 rows. References with locations table. | | country table. Contains 25 rows. References with locations table. | ||
+ | |- | ||
|} | |} | ||
+ | |||
=== Columns === | === Columns === | ||
Line 18: | Line 20: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| COUNTRY_ID | | COUNTRY_ID | ||
| CHAR(2) | | CHAR(2) | ||
Line 25: | Line 27: | ||
| | | | ||
| Primary key of countries table. | | Primary key of countries table. | ||
− | |- | + | |- |
| COUNTRY_NAME | | COUNTRY_NAME | ||
| VARCHAR2(40) | | VARCHAR2(40) | ||
Line 31: | Line 33: | ||
| | | | ||
| Country name | | Country name | ||
− | |- | + | |- |
| REGION_ID | | REGION_ID | ||
| NUMBER | | NUMBER | ||
Line 44: | Line 46: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- |
| COUNTRY_C_ID_PK | | COUNTRY_C_ID_PK | ||
| COUNTRY_ID | | COUNTRY_ID | ||
Line 55: | Line 57: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| COUNTRY_ID_NN | | COUNTRY_ID_NN | ||
| "COUNTRY_ID" IS NOT NULL | | "COUNTRY_ID" IS NOT NULL | ||
Line 68: | Line 70: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[HR.REGIONS_(table)|HR.REGIONS]] | | [[HR.REGIONS_(table)|HR.REGIONS]] | ||
| REGION_ID | | REGION_ID | ||
Line 81: | Line 83: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[HR.LOCATIONS_(table)|HR.LOCATIONS]] | | [[HR.LOCATIONS_(table)|HR.LOCATIONS]] | ||
| COUNTRY_ID | | COUNTRY_ID | ||
| COUNTRY_ID | | COUNTRY_ID | ||
+ | |} | ||
+ | |||
+ | === Dependencies === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Reference Type | ||
+ | | '''Object Type | ||
+ | | '''Referencing Object | ||
+ | |||
+ | |- | ||
+ | | Select | ||
+ | | View | ||
+ | | [[OE.CUSTOMERS_VIEW_(view)|OE.CUSTOMERS_VIEW]] | ||
+ | |||
|} | |} |