SH COSTS (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| SH.COSTS
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| PROD_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| TIME_ID
| DATE(7)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| PROMO_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| CHANNEL_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| UNIT_COST
| NUMBER(10, 2)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| UNIT_PRICE
| NUMBER(10, 2)
| not null
| &nbsp;
| &nbsp;
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| COSTS_PROD_BIX
| &nbsp;
| PROD_ID
|- valign="top"
| COSTS_TIME_BIX
| &nbsp;
| TIME_ID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| SYS_C005082
| "PROD_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005083
| "TIME_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005084
| "PROMO_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005085
| "CHANNEL_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005086
| "UNIT_COST" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005087
| "UNIT_PRICE" IS NOT NULL
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[SH CHANNELS (table)|SH.CHANNELS]]
| CHANNEL_ID
| CHANNEL_ID
|- valign="top"
| [[SH PRODUCTS (table)|SH.PRODUCTS]]
| PROD_ID
| PROD_ID
|- valign="top"
| [[SH PROMOTIONS (table)|SH.PROMOTIONS]]
| PROMO_ID
| PROMO_ID
|- valign="top"
| [[SH TIMES (table)|SH.TIMES]]
| TIME_ID
| TIME_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

SH COSTS (table)
