Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

SALES_TRANSACTIONS_EXT

Columns

Column Datatype Nullable Default value Comment
PROD_ID NUMBER(6,0) Y    
CUST_ID NUMBER(,) Y    
TIME_ID DATE Y    
CHANNEL_ID CHAR(1) Y    
PROMO_ID NUMBER(6,0) Y    
QUANTITY_SOLD NUMBER(3,0) Y    
AMOUNT_SOLD NUMBER(10,2) Y    
UNIT_COST NUMBER(10,2) Y    
UNIT_PRICE NUMBER(10,2) Y    

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005