hizli_satis - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
company_id bigIncrements
user_id bigIncrements
first_name string
last_name string
email string
password string
status enum
last_login_at timestamp

products

id increments
timestamps timestamps
softDeletes softDeletes
company_id bigIncrements
office_product_id integer
name string
code string
status enum
product_type string
critical_quantity integer
purchase_price float
sale_price float
discount_type string
discount_value float
charge_type string
charge_value float
otv_type string
otv_value float
vat_type string
vat_value float
purchase_currency string
sale_currency string
purchase_price_vat_included boolean
sale_price_vat_included boolean
image string

carts

id increments
timestamps timestamps
softDeletes softDeletes
checkout_id integer
office_associate_id integer
user_id bigInteger
status string
sub_total integer
discount float
total float
note string

cart_items

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
quantitiy integer
sub_total float
discount float
total float
tax float

orders

id increments
timestamps timestamps
softDeletes softDeletes
payment_id bigInteger
checkout_id integer
user_id integer
sub_total float
cart_id integer
discount float
total float
note string

order_items

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
product_id bigInteger
quantitiy integer
price decimal
sub_total decimal
grand_total decimal
vat_rate integer

order_payments

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
type string

checkout_login_history

id increments
timestamps timestamps
softDeletes softDeletes
user_id bigInteger
checkout_id bigInteger
type enum

invoices

id increments
timestamps timestamps
softDeletes softDeletes
office_associate_id integer
order_id integer
user_id integer
currency string
receiver_email string
ettn string
status string
pdf string
send_status string
print_status string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01