Difference between revisions of "OE.PROMOTIONS (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.PROMOTIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...)
 
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| OE.PROMOTIONS
 
| OE.PROMOTIONS
|-
 
 
|}
 
|}
  
 
+
=== 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 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
+
 
+
|- valign="top"
|-
 
 
| PROMO_ID
 
| PROMO_ID
| NUMBER
+
| NUMBER(6, 0)
 
| not null
 
| not null
 
|  
 
|  
| PROMO_ID_PK
 
 
|  
 
|  
|-
+
|- valign="top"
 
| PROMO_NAME
 
| PROMO_NAME
| VARCHAR2
+
| VARCHAR2(20)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PROMO_ID_PK
 +
| PROMO_ID
 
|}
 
|}

Latest revision as of 07:15, 24 June 2010

wikibot[edit]

Table OE.PROMOTIONS

Columns[edit]

Column Data Type Nullable Default Description
PROMO_ID NUMBER(6, 0) not null
PROMO_NAME VARCHAR2(20) null

Primary Key[edit]

Primary Key Columns
PROMO_ID_PK PROMO_ID