|
id
|
bigint(20) unsigned
|
|
|
|
|
category_id
|
bigint(20) unsigned
|
|
|
استعرض القيم الغريبة
|
|
manufacturer_id
|
bigint(20) unsigned
|
|
|
استعرض القيم الغريبة
|
|
part_name_ar
|
varchar(255)
|
|
|
|
|
part_name_en
|
varchar(255)
|
|
|
|
|
brand_name
|
varchar(120)
|
|
|
|
|
part_type
|
varchar(120)
|
|
|
|
|
vehicle_id
|
bigint(20) unsigned
|
|
|
|
|
part_number
|
varchar(150)
|
|
|
|
|
alternate_part_number
|
varchar(150)
|
|
|
|
|
sku
|
varchar(150)
|
|
|
|
|
barcode
|
varchar(150)
|
|
|
|
|
description
|
text
|
|
|
|
|
cost_price
|
decimal(15,2)
|
|
|
0.00
|
|
sale_price
|
decimal(15,2)
|
|
|
0.00
|
|
wholesale_price
|
decimal(15,2)
|
|
|
0.00
|
|
min_stock_level
|
decimal(15,2)
|
|
|
0.00
|
|
sold_qty_total
|
decimal(12,2)
|
|
|
0.00
|
|
sales_amount_total
|
decimal(12,2)
|
|
|
0.00
|
|
unit_name
|
varchar(50)
|
|
|
قطعة
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
unit
|
varchar(50)
|
|
|
pcs
|
|
image_path
|
varchar(255)
|
|
|
|
|
status
|
enum
|
-- |
|
active
|
|
reference_status
|
varchar(32)
|
|
|
unverified
|
|
reference_verified_at
|
datetime
|
|
|
|
|
reference_verified_by
|
varchar(120)
|
|
|
|
|
reference_notes
|
text
|
|
|
|
|
notes
|
text
|
|
|
|
|
created_by
|
bigint(20) unsigned
|
|
|
|
|
updated_by
|
bigint(20) unsigned
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
warehouse_id
|
bigint(20) unsigned
|
|
|
|
|
total_sold_qty
|
decimal(12,2)
|
|
|
0.00
|
|
total_sales_amount
|
decimal(14,2)
|
|
|
0.00
|
|
total_sales_cost
|
decimal(14,2)
|
|
|
0.00
|
|
total_profit_amount
|
decimal(14,2)
|
|
|
0.00
|