Iraq database - Laravel Schema Designer

classes

id increments
name string
translations json
description text
status boolean
created_by integer
updated_by integer
deleted_by integer
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string
translations json
description text
parent_id ^FK integer
class_id ^FK integer
softDeletes softDeletes
timestamps timestamps

products

id increments
name string
translations json
class_id ^FK integer
sku string
category_id ^FK integer
subcategory_id ^FK integer
details string
height decimal (10,2)
weight decimal (10.2)
length decimal (10,2)
width decimal (10,2)
active boolean
created_by integer
edited_by integer
deleted_by integer
softDeletes softDeletes
brand_id ^FK integer
timestamps timestamps

brands

id increments
timestamps timestamps
softDeletes softDeletes
name string
created_by integer
edited_by integer
deleted_by integer

currencies

code string
id increments
timestamps timestamps
softDeletes softDeletes
country string
currency string
symbol string
thousand_seperator string

stores

id increments
name string
location string
phone_number string
email string
manager_name string
manager_mobile_number string
details text
created_by integer
deleted_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

product_stores

id increments
product_id ^FK integer
store_id ^FK integer
quantity_available double
quantity_expired double
deleted_by string
block_quantity double
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string
email string
address string
phone string
deposit_balance decimal (10,2)
added_balance decimal (10,2)
softDeletes softDeletes
timestamps timestamps
created_by integer
deleted_by integer
updated_by integer
customer_type_id ^FK integer

customer_types

id increments
name string
deleted_by integer
created_by integer
updated_by integer
softDeletes softDeletes
timestamps timestamps

customer_balance_adjustments

id increments
customer_id ^FK integer
store_id ^FK integer
current_balance decimal (10,2)
add_new_balance decimal (10,2)
new_balance decimal (10,2)
notes text
date_and_time datetime
created_by integer
deleted_by integer
updated_by integer
softDeletes softDeletes
timestamps timestamps

employees

id increments
user_id ^FK integer
store_id ^FK integer
updated_by integer
pass_string string
employee_name string
date_of_start_working date
job_type_id ^FK integer
mobile string
date_of_birth date
annual_leave_per_year integer
sick_leave_per_year integer
payment_cycle enum
commission tinyInteger
commission_value decimal (10,2)
commission_type enum
commision_calculation_period enum
created_by integer
timestamps timestamps
deleted_by integer
softDeletes softDeletes
comissioned_products text
comission_customer_types text
comission_stores text
comission_cashier text
working_day_per_weak string
check_in string
check_out string

job_types

id increments
timestamps timestamps
softDeletes softDeletes
title string
date_of_creation date
created_by integer
deleted_by integer
updated_by integer

exchange_rates

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK integer
receved_currency_id ^FK integer
conversion_rate decimal (10,2)
default_currency_id ^FK integer
expiery_date date
created_by integer
updated_by integer
deleted_by integer

product_discounts

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
discount_type string
discount string
discount_start_date string
discount_end_date string
discount_customer_types text
discount_customers text
discount_category text
is_discount_permenant string
created_by integer
updated_by integer
deleted_by integer

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