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