CALLDW.FACTS
PF* ID_TIME NUMBER
PF* ID_PHONERATE NUMBER PF* ID_LOCATION_CALLER NUMBER PF* ID_LOCATION_RECEIVER NUMBER
* PRICE FLOAT (126)
* NUMBEROFCALLS NUMBER
FACTS_PK (ID_TIME, ID_PHONERATE, ID_LOCATION_CALLER, ID_LOCATION_RECEIVER) CALLDW.PHONERATE
P * ID_PHONERATE NUMBER
* PHONERATETYPE CHAR (20 BYTE) PHONERATE_PK (ID_PHONERATE)
CALLDW.TIMEDIM
*
DAYOFMONTH DATE P
*
ID_TIME NUMBER
* DAYOFWEEK CHAR (15 BYTE)
* DATEMONTH CHAR (7 BYTE)
* DATEYEAR NUMBER TIMEDIM_PK (ID_TIME)
CALLDW.LOCATION P * ID_LOCATION
LOCATION
NUMBER
* CITY CHAR (20 BYTE)
* PROVINCE CHAR (20 BYTE)
* REGION CHAR (20 BYTE) LOCATION_PK (ID_LOCATION)