Table comparison: sma_products
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
code |
varchar(50) |
NO |
varchar(50) |
NO |
|
name |
varchar(255) |
NO |
varchar(255) |
NO |
|
unit |
int(11) |
YES |
int(11) |
YES |
|
cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
price |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
price2 |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
alert_quantity |
decimal(15,4) |
YES |
decimal(15,4) |
YES |
|
image |
varchar(255) |
YES |
varchar(255) |
YES |
|
category_id |
int(11) |
NO |
int(11) |
NO |
|
subcategory_id |
int(11) |
YES |
int(11) |
YES |
|
cf1 |
varchar(255) |
YES |
varchar(255) |
YES |
|
cf2 |
varchar(255) |
YES |
varchar(255) |
YES |
|
cf3 |
varchar(255) |
YES |
varchar(255) |
YES |
|
cf4 |
varchar(255) |
YES |
varchar(255) |
YES |
|
cf5 |
varchar(255) |
YES |
varchar(255) |
YES |
|
cf6 |
varchar(255) |
YES |
varchar(255) |
YES |
|
quantity |
decimal(15,4) |
YES |
decimal(15,4) |
YES |
|
tax_rate |
int(11) |
YES |
int(11) |
YES |
|
track_quantity |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
details |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
warehouse |
int(11) |
YES |
int(11) |
YES |
|
barcode_symbology |
varchar(55) |
NO |
varchar(55) |
NO |
|
file |
varchar(100) |
YES |
varchar(100) |
YES |
|
product_details |
text |
YES |
text |
YES |
|
tax_method |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
type |
varchar(55) |
NO |
varchar(55) |
NO |
|
supplier1 |
int(11) |
YES |
int(11) |
YES |
|
supplier1price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
supplier2 |
int(11) |
YES |
int(11) |
YES |
|
supplier2price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
supplier3 |
int(11) |
YES |
int(11) |
YES |
|
supplier3price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
supplier4 |
int(11) |
YES |
int(11) |
YES |
|
supplier4price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
supplier5 |
int(11) |
YES |
int(11) |
YES |
|
supplier5price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
promotion |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
promo_price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
start_date |
date |
YES |
date |
YES |
|
end_date |
date |
YES |
date |
YES |
|
supplier1_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
supplier2_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
supplier3_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
supplier4_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
supplier5_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
sale_unit |
int(11) |
YES |
int(11) |
YES |
|
purchase_unit |
int(11) |
YES |
int(11) |
YES |
|
brand |
int(11) |
YES |
int(11) |
YES |
|
slug |
varchar(55) |
YES |
varchar(55) |
YES |
|
featured |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
weight |
decimal(10,4) |
YES |
decimal(10,4) |
YES |
|
hsn_code |
int(11) |
YES |
int(11) |
YES |
|
views |
int(11) |
NO |
int(11) |
NO |
|
hide |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
second_name |
varchar(255) |
YES |
varchar(255) |
YES |
|
hide_pos |
tinyint(1) |
NO |
tinyint(1) |
NO |