php artisan crud:gen product --fields="name:string, code:string:nullable, description:text:nullable, grade:integer:nullable, discount:integer:nullable, category_id:integer, sub_category_id:integer, seller_id:integer, store_id:integer:nullable, price:double:default(1), product_image:string:nullable, product_alt_image:string:nullable status_code:integer:default(1)"


php artisan crud:gen category --fields="name:string, related_category_id:integer:default(1), code:string:nullable, status_code:integer:default(1)"

php artisan crud:gen sub_category --fields="name:string, category_id:integer:default(1), code:string:nullable, status_code:integer:default(1)"

php artisan crud:gen store --fields="name:string, address:text, city:string, country_id:integer, agent_id:integer, seller_id:integer, status_code:default(1)"

php artisan crud:gen stock --fields="product_id:integer, quantity:integer, current_stock:integer, store_id:integer, status_code:integer:default(1)"

php artisan crud:gen stock_flow --fields="store_id:integer, client_id:integer, product_id:integer, quantity:integer, tx_type_id:integer, current_stock:integer"

php artisan crud:gen stockrequest --fields="store_id:integer, agent_id:integer, product_id:integer, quantity:integer, status_code:integer:default(1)"

php artisan crud:gen product_stock_request --fields="product_id:integer, stock_request_id:integer, quantity:integer, price:double:default(0), balance:double:nullable, status_code:integer:default(1)"

php artisan crud:gen offer --fields="offer_code:string, seller_id:integer, promo_code:string:nullable, start_date:date, end_date:date, title:string, details:text:nullable, img_path:string:nullable, status_code:integer:default(1), payment_status_id:integer:default(1)"

php artisan crud:gen order --fields="order_code:string, offer_id:integer:nullable, agent_id:integer,  client_id:integer, details:text:nullable, todeliver:integer, delivery_location:text:nullable, delivery_details:text:nullable, delivery_phone:string:nullable, status_code:integer:default(1)"

php artisan crud:gen order_payment --fields="order_code:string, order_id:integer, invoice_id:integer, client_id:integer, amount:double:nullable, comment:text:nullable, details:text:nullable"

php artisan crud:gen order_product --fields="order_id:integer, product_id:integer, quantity:integer, price:double"

php artisan crud:gen payment --fields="seller_id:integer, date:date:nullable, offer_id:integer:nullable, details:text:nullable, message:text:nullable, amount:double, status_code:integer:default(1)"

php artisan crud:gen payment_type --fields="name:string"

php artisan crud:gen seller --fields="seller_code:string, name:string, type_id:integer:default(1), country_id:integer, region_id:integer, district_id:integer, postal_code:integer:nullable, ward_id:integer:nullable, owner_name:string, phone:string, owner_document_url:string:nullable, document_type_id:integer:default(0), email:string:nullable, license_no:string:nullable, reg_no:string:nullable, business_type_id:integer, reg_date:date, verification_date:date:nullable, verifier_id:integer:nullable, address:text:nullable, contact_person:string, till_number:string:nullable, till_mno_id:integer:nullable, bank_account:string:nullable, bank_name:string:nullable, bank_branch:string:nullable, logo_path:string:nullable, status_code:integer:default(1)"

php artisan crud:gen document_type --fields="name:string"

php artisan crud:gen status --fields="code:integer, name:string, type:string"

php artisan crud:gen transaction --fields="txn_id:integer, type:integer, agent_id:integer, seller_id:integer,  client_id:integer, offer_id:integer:nullable, amount:integer, details:text:nullable"

php artisan crud:gen agent --fields="name:string, phone_number:string, age_group_id:integer, id_number:string:nullable, residence:string, country_id:integer, seller_id:integer, promo_code:string, agent_code:string, status_code:integer:default(1)"

php artisan crud:gen supplier --fields="name:string, phone_number:string, country_id:integer, owner_name:string, phone:string, email:string:nullable, license_no:string:nullable, reg_no:string:nullable, business_type_id:integer, reg_date:date, approval_date:date:nullable, approver_id:integer:nullable, agent_code:string:nullable, till_number:string:nullable, till_mno_id:integer:nullable, number_branch:integer:default(1), bank_account:string:nullable, bank_name:string:nullable, ref_code:string:nullable, status_code:integer"


php artisan crud:gen payment_transactions --fields="user_id:integer:nullable, member_id:integer:nullable, payment_code:string:nullable, amount:integer:default(0), payment_message_id:integer:nullable, payment_date:date:nullable, payment_type_id:integer, payment_status:integer, details:text:nullable"

php artisan crud:gen payment_messages --fields="payment_code:string:nullable, phone_number:string:nullable, amount:string:nullable, message:text:nullable"

php artisan crud:gen till_mnos --fields="name:string, code:string"

php artisan crud:gen messages --fields="message:text:nullable, sender:string, user_id:integer, message_type_id:integer, status_code:integer"

php artisan crud:gen message_types --fields="name:string"

php artisan crud:gen user_type --fields="name:string, status_code:integer"

php artisan crud:gen business_type --fields="name:string, status_code:integer"

php artisan crud:gen invoice --fields="number:string, date:date, buyer_id:integer, amount:integer, delivery_charges:integer:default(0)"

php artisan crud:gen invoice_product --fields="product_id:integer, price:integer:default(1), quantity:integer,total:integer:default(0), details:text:nullable, comment:text:nullable"


php artisan crud:gen country --fields="name:string, calling_code:integer"

php artisan crud:gen region --fields="name:string, code:integer, country_id:integer"

php artisan crud:gen district --fields="name:string, code:integer, region_id:integer"

php artisan crud:gen ward --fields="name:string, code:integer, district_id:integer"

php artisan crud:gen transaction_type --fields="name:string"


php artisan crud:gen productView --fields="product_id:integer, user_id:integer"

php artisan crud:gen productLike --fields="product_id:integer, user_id:integer"

php artisan crud:gen wishlistItem --fields="product_id:integer, user_id:integer"

php artisan crud:gen shoppingCart --fields="session_id:text:nullable, product_id:integer, quantity:integer:default(1), price:double:default(1), grade:integer:nullable, seller_id:integer, user_id:integer:nullable"

php artisan crud:gen delivery_chart --fields="normal_KgKm:integer, express_KgKm:integer, from_country_id:integer, from_urban_rural_id:integer, to_country_id:integer, to_urban_rural_id:integer"


seller:
	shop
		location

	products
		product views

	orders
		paid notification

	report
		products, orders
	Finance
		sales per product
		total sales
			withdraw

	tickets