Re: Best conception of a table

2018-05-12 Thread Adrian Klaver
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

Re: Best conception of a table

2018-05-11 Thread Laurenz Albe
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,

Best conception of a table

2018-05-11 Thread hmidi slim
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