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: 2011/08/27 11:07 by
wikibot
-
Uncategorized
(7)
»
public.getmanagedoutagefornodeinwindow_(function)
»
HR.SECURE_DML_(procedure)
»
HR.COUNTRIES_(table)
[X]
»
public.getoutagetimeinwindow_(function)
»
Sales.CountryRegionCurrency_(table)
»
OE.PRODUCTS_(view)
»
Sales.vSalesPerson_(view)
»
public.getmanagedoutagefornodeinwindow_(function)
»
HR.SECURE_DML_(procedure)
»
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
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.