   id                        bigint auto_increment not null,
   name                      varchar(255) not null,
   price                     decimal(38) not null,
-  quantity                  integer,
-  transaction_id            bigint,
-  product_id                bigint,
+  quantity                  integer not null,
+  transaction_id            bigint not null,
+  product_id                bigint not null,
   constraint pk_transaction_product primary key (id))
 ;
 

  last_name                 varchar(255) not null,
  beer_name                 varchar(255),
  status_id                 bigint not null,
  balance                   decimal(38),
  constraint pk_user primary key (id))
;


  id                        bigint auto_increment not null,
  name                      varchar(255) not null,
  price                     decimal(38) not null,
  quantity                  integer not null,
  constraint pk_product primary key (id))
;

create table status (
  id                        bigint auto_increment not null,
  name                      varchar(255) not null,
  constraint pk_status primary key (id))
;

create table stocktaking (
  id                        bigint auto_increment not null,
  created                   datetime not null,
  users                     longtext,
  products                  longtext,
  transactions              longtext,
