|
id
|
int(11)
|
|
|
|
|
item_name
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
category
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
purpose
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
purchased_from
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
purchase_link
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
total_purchased
|
int(11)
|
|
|
|
|
unit_price_aed
|
decimal(10,2)
|
|
|
|
|
price_aed
|
decimal(12,2)
|
|
|
|
|
before_opening
|
int(11)
|
|
|
|
|
quantity_restaurant
|
int(11)
|
|
|
|
|
total_breakage
|
int(11)
|
|
|
|
|
balance_after_breakage
|
int(11)
|
|
|
|
|
storage_place_restaurant
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
breakage_remarks
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
quantity_dubai
|
int(11)
|
|
|
|
|
storage_place_dubai
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
quantity_warehouse
|
int(11)
|
|
|
|
|
storage_place_warehouse
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
branch
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
image_link
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
invoice_link
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
post_date
|
datetime
|
|
|
|
