sikasir - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
username string
image string
phone string
email string
email_verified_at timestamps
password string

roles

id increments
timestamps timestamps
name string
description string
is_active boolean

services

id increments
timestamps timestamps
name string
description string
price integer
duration_days integer
is_active boolean

employees

id increments
timestamps timestamps
user_id ^FK integer
store_id ^FK integer
outlet_id ^FK integer
role_id ^FK integer
is_active boolean

stores

id increments
timestamps timestamps
name string
description string
business_categorie_id ^FK integer
owner_id ^FK integer
service_id ^FK integer
email string
phone string
address string
city string
province string
postal_code string
logo string
is_ppn boolean

business_types

id increments
timestamps timestamps
name string
description string
is_active boolean

monthly_bills

id increments
timestamps timestamps
store_id ^FK integer
service_id ^FK integer
billing_month date
amount decimal
due_date date
payment_status enum
paid_at timestamp

business_categories

id increments
timestamps timestamps
business_type_id ^FK integer
name string
description string
is_active boolean

outlets

id increments
timestamps timestamps
store_id ^FK integer
name string
address string
phone string
is_active boolean

product_categories

id increments
timestamps timestamps
store_id ^FK integer
name string
description string
is_active boolean

products

id increments
timestamps timestamps
category_id ^FK integer
store_id ^FK integer
outlet_id ^FK integer
code string
name string
description string
image string
hpp decimal
markup decimal
selling_price decimal
stock integer
is_ppn boolean
is_discount boolean
is_active boolean
is_favorite boolean

variant_types

id increments
timestamps timestamps
store_id ^FK integer
name string

product_variants

id increments
timestamps timestamps
store_id ^FK integer
outlet_id ^FK integer
product_id ^FK integer
variant_type_id ^FK integer
name string
extra_price decimal
stock integer
is_active boolean

stock_transactions

id increments
timestamps timestamps
store_id ^FK integer
outlet_id ^FK integer
product_id ^FK integer
variant_id ^FK integer
type enum
quantity integer
note string

orders

id increments
timestamps timestamps
order_code string
transaction_time datetime
kasir_id ^FK integer
total_item integer
total_price integer
discount decimal
ppn decimal
final_amount decimal
payment_method string
status enum

order_items

id increments
timestamps timestamps
order_id ^FK integer
product_id ^FK integer
variant_id ^FK integer
quantity integer
price decimal
total_price decimal
discount decimal
ppn decimal
final_amount decimal

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