elbadr_ERP_demo - Laravel Schema Designer

ADMIN

id increments
timestamps timestamps
name string (255)
email string (255)
password string (255)

role

id bigIncrements
timestamps timestamps
name string
guard_name string

permissions

id bigIncrements
timestamps timestamps
name string
guard_name string

role_has_permissions

permission_id ^FK bigInteger
role_id ^FK bigInteger
id increments
timestamps timestamps

model_has_roles

id increments
timestamps timestamps
role_id ^FK bigInteger
model_type string
model_id ^FK bigInteger

model_has_permissions

id increments
timestamps timestamps
permission_id ^FK bigInteger
model_type string
model_id ^FK bigInteger

Business_Information_Settings

id increments
timestamps timestamps
name string
email string
phone string
logo string

products

id increments
timestamps timestamps
name string
description string
price string
stock string
unit string
is_active boolean
category_id ^FK bigInteger

categories

id increments
timestamps timestamps
name string

product_images

id increments
timestamps timestamps
product_id ^FK bigInteger
image_path string
is_main boolean

clients

id increments
timestamps timestamps
name string
phone string
email string
address string

orders

id increments
timestamps timestamps
client_id ^FK bigInteger
total decimal
discount string
payment_method string
status string

order_items

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity string
price decimal
subtotal decimal

returns

id increments
timestamps timestamps
order_id ^FK bigInteger
client_id ^FK bigInteger
total_refund string
reason string

return_items

id increments
timestamps timestamps
return_id ^FK bigInteger
product_id ^FK bigInteger
quantity decimal
price decimal
subtotal decimal

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