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.

 
loading table of contents...