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 10: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
|
