From dbscript Online Help
|
|
Line 86: |
Line 86: |
| | 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
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[OE.CUSTOMERS_VIEW_(view)|OE.CUSTOMERS_VIEW]]
| |
− |
| |
| |} | | |} |
Latest revision as of 11:33, 27 August 2011
wikibot[edit]
Table
|
HR.COUNTRIES
|
Description
|
country table. Contains 25 rows. References with locations table.
|
Columns[edit]
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[edit]
Primary Key
|
Columns
|
COUNTRY_C_ID_PK
|
COUNTRY_ID
|
Check Constraints[edit]
Check Constraint
|
Expression
|
Description
|
COUNTRY_ID_NN
|
"COUNTRY_ID" IS NOT NULL
|
|
Foreign Keys[edit]
Relation
|
Column
|
Referenced Column
|
HR.REGIONS
|
REGION_ID
|
REGION_ID
|
Detail Tables[edit]
Detail Table
|
Column
|
Referencing Column
|
HR.LOCATIONS
|
COUNTRY_ID
|
COUNTRY_ID
|