This table contains information about the prices that customers pay.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
CUSTOMER_ID | int | No | Primary key component. Foreign key to ARF_USER.ID column. | |
DAY_ID | varchar | 40 | No | Primary key component. Foreign key to ARF_TIME_DAY.ID column. |
LAST_PURCHASE | timestamp | Yes | The last time the customer purchased a product on this day. | |
OCCURRENCES | int | No | The quantity of items purchased by the customer on this day. | |
MAX_PRICE | double | Yes | The maximum price paid (after discounts) for an item on this day. | |
MIN_PRICE | double | Yes | The minimum price paid (after discounts) for an item on this day. | |
AVERAGE_PRICE | double | Yes | The average price paid (after discounts) for the items on this day. | |
STANDARD_DEVIATION | double | Yes | The standard deviation of the prices (after discounts) of the items on this day. |