241
edits
Changes
→Structure
Line 36:
Line 36:
| stock_loc | varchar(10) | YES | | NULL | |
| stock_loc | varchar(10) | YES | | NULL | |
| gencode | varchar(255) | YES | | NULL | |
| gencode | varchar(255) | YES | | NULL | |
−| weight | float | YES | | NULL | |
+| weight | float | YES | | NULL | | weight value, depending on weight units
−| weight_units | tinyint(4) | YES | | NULL | |
+| weight_units | tinyint(4) | YES | | NULL | | weight units (0=kg,-3=g,-6=mg)
| volume | float | YES | | NULL | |
| volume | float | YES | | NULL | |
| volume_units | tinyint(4) | YES | | NULL | |
| volume_units | tinyint(4) | YES | | NULL | |