On 05/11/2018 03:54 PM, hmidi slim wrote:
Hi,
I want to get some different opinions and tips about two different
conception.
I want to create a table named proudct_price_period
createtableproduct_price_period {
id integer,
product_id integer,
occupation_type_id integer,
price_mode_id integer,
p
hmidi slim wrote:
> To clarify the purpose of the table 'product_price_period': If I have a
> product
> and I choose period like [2018-05-01, 2018-05-31] and in the days_checked =
> [0,2,3].
> The values of days_checked are the indexes of the week's day.
> In this case 0 => sunday, 2 => tuesday,
Hi,
I want to get some different opinions and tips about two different
conception.
I want to create a table named proudct_price_period
create table product_price_period {
id integer ,
product_id integer,
occupation_type_id integer,
price_mode_id integer,
price_period daterange,
days_checked integer