ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
HR.COUNTRIES_(table)
Print
RSS
Modified: 2010/06/24 06:52 by
wikibot
-
Uncategorized
(10)
»
SH.CHANNELS_(table)
»
HumanResources.Department_(table)
»
HR.COUNTRIES_(table)
[X]
»
IX.AQ$_ORDERS_QUEUETABLE_G_(table)
»
Production.ProductListPriceHistory_(table)
»
HR.EMP_DETAILS_VIEW_(view)
»
IX.STREAMS_QUEUE_TABLE_(table)
»
HumanResources.JobCandidate_(table)
»
IX.ORDERS_QUEUETABLE_(table)
»
public.vulnplugins_(table)
»
SH.CHANNELS_(table)
»
HumanResources.Department_(table)
»
HR.COUNTRIES_(table)
Edit
wikibot
Table
HR.COUNTRIES
Description
country table. Contains 25 rows. References with locations table.
Edit
Columns
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.
Edit
Primary Key
Primary Key
Columns
COUNTRY_C_ID_PK
COUNTRY_ID
Edit
Check Constraints
Check Constraint
Expression
Description
COUNTRY_ID_NN
"COUNTRY_ID" IS NOT NULL
Edit
Foreign Keys
Relation
Column
Referenced Column
HR.REGIONS
REGION_ID
REGION_ID
Edit
Detail Tables
Detail Table
Column
Referencing Column
HR.LOCATIONS
COUNTRY_ID
COUNTRY_ID
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Select
View
OE.CUSTOMERS_VIEW
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.