whms - Laravel Schema Designer

customers

id increments
name string
tax_number string
timestamps timestamps
softDeletes softDeletes
taxoffice string
brand_name text

products

id increments
timestamps timestamps
softDeletes softDeletes
product_name text
category_id integer
variant string
variant_2 string
user_id integer
customer_id integer

warehouses

id increments
timestamps timestamps
softDeletes softDeletes
warehouse_name string
adress text
district text
city_id integer
district_id integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
category_name string
customer_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name text
last_name text
e_mail text
role_id integer
customer_id integer

stock_transactions

id increments
timestamps timestamps
softDeletes softDeletes
invoice_number string
accept_date datetime
damage_status string
receipt_amount integer
count_amount integer
count_match boolean
move_type_id integer
restock_status boolean
user_id integer
warehouse_id integer
exit_location string
arrival_location string

stocks

id increments
product_id integer
total_quantity decimal
reserved_quantity decimal
timestamps timestamps
softDeletes softDeletes

stock_movements

id increments
timestamps timestamps
softDeletes softDeletes
type string
product_id integer
stok_transaction_id integer
quantity decimal
user_id integer
stock_id integer
damage_status string
warehouse_id integer

move_types

id increments
timestamps timestamps
type text

location_types

id increments
timestamps timestamps
type text

stock_transaction_differences

id increments
timestamps timestamps
stock_transaction_id integer
difference_amount decimal
difference_type string
user_id integer

orders

id increments
timestamps timestamps
status_id integer
vendor_reference_number string
platform_order_id string
stock_transaction_id integer
order_channel string
delivery_company string
delivery_company_barcode string
recipient_name string
recipient_phone string
recipient_mail string
city_id string
district_id string
address string
neighborhood string
order_reference_number_1 string
order_reference_number_2 string
order_reference_number_3 string
order_reference_number_4 string

order_lines

id increments
timestamps timestamps
product_barcode string
quantity integer
giftable string
product_id integer
order_id integer

product_barcodes

id increments
timestamps timestamps
produc_id string
product_barcode string

order_statuses

id increments
timestamps timestamps
name string
type string

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string

districts

id increments
timestamps timestamps
softDeletes softDeletes
name string

imestav . 03 October 2024

Aynı üründen hem sevk edilebilir hem de hasarlı iadeden veya süreç içinde hasar alanlardan dolayı sevk edilemez olanlar olacak.

imestav . 03 October 2024

location types; - Sevk Lokasyonu - Palet Lokasyonu - Araf (Mal kabulu Yapılmış Ama üstteki iki lokasyondan birine atanmamış)

imestav . 03 October 2024

move types; - mal kabul - lokasyonlama - Depo İçi Transfer - Depo Dışı Transfer - Sevk(Kargo Çıkışı)

imestav . 03 October 2024

stock accepts; eşleşmese de kabul edebilmeliyiz. Bu eksik stoğu bir yerde tutmak lazım. Bunu hem yapmamak hem de yapmak lazım.

imestav . 14 October 2024

Kullanılabilir stok: üzerinde bekleyen/çıkılmamış sipariş yok. Fiziksel stok:depoda bulunan fiziki ürün sayısı

imestav . 14 October 2024

ürün barkodunu products'ın içinde tutmayalım. prodct barcode tablosunda tutalım

imestav . 14 October 2024

orders-order details gibi 2 tabloda tutalım.

imestav . 14 October 2024

orders: sipariş genel bilgileri - adres müşteribilgileri kargo firması vs. order details: siparişin altındaki ürün detayları miktar.

imestav . 14 October 2024

Yetki tablosu olacak.