create table pricebooks(
   id varchar(36) ,
   name varchar(255) not null,
   description varchar(255),
   isvalid tinyint(1),
   deleted tinyint(1),
   date_entered datetime,
   date_modified datetime,
   created_by varchar(36),
   primary key(id)
);

create table products_pricebooks(
   id varchar(36) ,
   product_id varchar(36),
   pricebook_id varchar(36),
   trade_price double,
   date_modified datetime,
   deleted tinyint(1),
   created_by varchar(36),
   primary key(id)
);