Home
whms
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (9)
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
×
Comments for whms
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.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01