Difference between revisions of "SH.CAL MONTH SALES MV (table)"

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 22: Line 22:
 
| VARCHAR2(8)
 
| VARCHAR2(8)
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|-
 +
| SYS_C005197
 +
| "CALENDAR_MONTH_DESC" IS NOT NULL
 
|  
 
|  
 
|}
 
|}

Revision as of 08:29, 11 February 2010

wikibot

Table SH.CAL_MONTH_SALES_MV


Columns

Column Data Type Nullable Default Description
CALENDAR_MONTH_DESC VARCHAR2(8) not null
DOLLARS NUMBER null

Check Constraints

Check Constraint Expression Description
SYS_C005197 "CALENDAR_MONTH_DESC" IS NOT NULL