| Id |
int(10)
|
|
|
|
| version |
int(11)
|
|
|
|
| nameproduct |
varchar(255)
|
latin1_swedish_ci
|
|
|
| typeproduct |
varchar(255)
|
latin1_swedish_ci
|
|
|
| formatproduct |
varchar(255)
|
utf8_general_ci
|
|
|
| appearance |
varchar(255)
|
latin1_swedish_ci
|
|
|
| servingsize |
varchar(255)
|
latin1_swedish_ci
|
|
|
| servingsachet |
varchar(255)
|
latin1_swedish_ci
|
|
|
| servingunits |
varchar(10)
|
utf8_general_ci
|
|
|
| energyserving |
varchar(255)
|
latin1_swedish_ci
|
|
|
| energy100 |
varchar(255)
|
latin1_swedish_ci
|
|
|
| fatserving |
varchar(100)
|
utf8_general_ci
|
|
|
| fat100 |
varchar(100)
|
utf8_general_ci
|
|
|
| saturedserving |
varchar(100)
|
utf8_general_ci
|
|
|
| satured100 |
varchar(100)
|
utf8_general_ci
|
|
|
| carboserving |
varchar(100)
|
utf8_general_ci
|
|
|
| carbo100 |
varchar(100)
|
utf8_general_ci
|
|
|
| sugarserving |
varchar(100)
|
utf8_general_ci
|
|
|
| sugar100 |
varchar(100)
|
utf8_general_ci
|
|
|
| polyolsserving |
varchar(100)
|
utf8_general_ci
|
|
|
| polyols100 |
varchar(100)
|
utf8_general_ci
|
|
|
| proteinserving |
varchar(100)
|
utf8_general_ci
|
|
|
| protein100 |
varchar(100)
|
utf8_general_ci
|
|
|
| fiberserving |
varchar(100)
|
utf8_general_ci
|
|
|
| fiber100 |
varchar(100)
|
utf8_general_ci
|
|
|
| saltserving |
varchar(100)
|
utf8_general_ci
|
|
|
| salt100 |
varchar(100)
|
utf8_general_ci
|
|
|
| alanine |
decimal(10,2)
|
|
|
|
| arginine |
decimal(10,2)
|
|
|
|
| aspartic |
decimal(10,2)
|
|
|
|
| cysteine |
decimal(10,2)
|
|
|
|
| glutamine |
decimal(10,2)
|
|
|
|
| glycine |
decimal(10,2)
|
|
|
|
| histidine |
decimal(10,2)
|
|
|
|
| isoleucine |
decimal(10,2)
|
|
|
|
| leucine |
decimal(10,2)
|
|
|
|
| methionine |
decimal(10,2)
|
|
|
|
| phenylalanine |
decimal(10,2)
|
|
|
|
| proline |
decimal(10,2)
|
|
|
|
| serine |
decimal(10,2)
|
|
|
|
| threonine |
decimal(10,2)
|
|
|
|
| tryptophan |
decimal(10,2)
|
|
|
|
| tyrosine |
decimal(10,2)
|
|
|
|
| valine |
decimal(10,2)
|
|
|
|
| lysine |
decimal(10,2)
|
|
|
|
| ingredients |
longtext
|
latin1_swedish_ci
|
|
|
| heavymetals1 |
varchar(255)
|
utf8_general_ci
|
|
|
| heavymetals2 |
varchar(255)
|
latin1_swedish_ci
|
|
|
| platecount |
varchar(255)
|
utf8_general_ci
|
|
|
| platestatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| yeastcount |
varchar(255)
|
utf8_general_ci
|
|
|
| yeaststatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| ecollicount |
varchar(255)
|
latin1_swedish_ci
|
|
|
| ecollistatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| salmonellacount |
varchar(255)
|
latin1_swedish_ci
|
|
|
| salmonellastatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| listeriacount |
varchar(255)
|
latin1_swedish_ci
|
|
|
| listeriastatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| shelflife |
varchar(255)
|
utf8_general_ci
|
|
|
| packaging |
varchar(255)
|
utf8_general_ci
|
|
|
| packagingsize |
varchar(255)
|
utf8_general_ci
|
|
|
| flavours |
mediumtext
|
utf8_general_ci
|
|
|
| description |
longtext
|
utf8_general_ci
|
|
|
| benefits |
longtext
|
utf8_general_ci
|
|
|
| dosage |
longtext
|
utf8_general_ci
|
|
|
| storage |
longtext
|
utf8_general_ci
|
|
|
| allergen |
mediumtext
|
utf8_general_ci
|
|
|
| batch |
varchar(255)
|
utf8_general_ci
|
|
|
| createby |
int(10)
|
|
|
|
| createdate |
date
|
|
|
|
