elterb - Laravel Schema Designer

company

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
logo string
phone string
email string
fax string

units

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

trees

id increments
name_ar string
name_en string (255)
numeric_system integer
type enum
units json
softDeletes softDeletes
timestamps timestamps

accounts

id increments
name_ar string (255)
name_en string (255)
numeric_system integer
unit string (255)
type enum
tree_id ^FK integer
softDeletes softDeletes
timestamps timestamps

sub_accounts

id increments
name_ar string (255)
name_en string (255)
unit json
type enum
account_id ^FK integer
numeric_system integer
parent_id integer
has_child boolean
softDeletes softDeletes
timestamps timestamps

account_transactions

id increments
account morphs
value decimal
unit json
type enum
text_ar text
text_en text
softDeletes softDeletes
timestamps timestamps

partiner_bonds

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer
date date

partiner_bond_items

id increments
timestamps timestamps
softDeletes softDeletes
account_tree morphs
unit_id ^FK integer
value double
text text

profiles

id increments
timestamps timestamps
softDeletes softDeletes
address string

suppliers

id increments
timestamps timestamps
name string
nid string
type enum
dealing_type enum
country_id ^FK bigInteger
city_id ^FK bigInteger
company_name string
establishment_date date
logo string
latitude string
longitude string
phone string
email string
communication_officer string
communication_phone string
communication_email string
password string
address string
building_number string
sub_number string
street_number string
district string
details text
tax enum

supply_bond_items

id increments
bond_id ^FK integer
line_id string
kind_id ^FK integer
karat_id ^FK bigInteger
weight double
sahm integer
wage integer
total_wage string
wage_tax double
gold_wage double
number integer
value integer
value_tax double
stone_weight double
other_stone_weight string
discount double
notes longText
softDeletes softDeletes
timestamps timestamps
parent_id ^FK bigInteger
remaining_weight double
status enum

employees

id increments
softDeletes softDeletes
timestamps timestamps
username string
name string
password string
dob date
nationality ^FK bigInteger
email string
role_id bigInteger
birth_date date
phone string
national_id bigInteger
branch_id ^FK bigInteger
city_id ^FK bigInteger
job_degree string

supply_bond

id increments
bond_date timestamp
buyer morphs
seller morphs
bond_num text
gold_price double
entity_gold_price double
out_goods_value double
notes longText
bond_docs string
out_docs string
bond_type enum
softDeletes softDeletes
timestamps timestamps
total_value double
diamond_weight string
total_other_rocks double
total_accories double
total_gold_18 string
total_gold_21 string
total_gold_22 string
total_gold_24 double
total_gold_by24 string
total_weight string
total_discount string
total_tax double
total_count double
status enum

diamond_bond_items

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
weight double
gold_weight double
carat_id ^FK bigInteger
diamond_value double
diamond_count string
diamond_stone_weight double
diamond_tax double
discount double
other_stones_weight double
notes longText
bond_id ^FK integer

accessory_bond_items

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
weight double
gold_weight double
carat_id ^FK integer
accessory_value double
accessory_count integer
accessory_stone_weight double
accessory_tax double
discount double
other_stones_weight double
notes longText
bond_id ^FK integer

karats

id increments
timestamps timestamps
softDeletes softDeletes
name string
equivalent double

supply_bond_payment

id increments
timestamps timestamps
softDeletes softDeletes
date date
supplier_id ^FK integer
bond_number string
bond_docs string
notes string
total_tax double
type string
total_money double
total_24_for_shears double
total_18 decimal
total_21 double
total_22 double
total_24 double
discount double

branches

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK bigInteger
market_id ^FK bigInteger
name_en string
name_ar string
market_number string
latitude string
longitude string
phone string
footer_format_ar string
footer_format_en string
address string
building_number string
sub_number string
district string
city_id string

products

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
numeric_system string

colors

id increments
timestamps timestamps
softDeletes softDeletes
name string

shapes

id increments
timestamps timestamps
softDeletes softDeletes
name string

stone_types

id increments
timestamps timestamps
softDeletes softDeletes
NAME string

syncs

id increments
sync morphs
status integer
softDeletes softDeletes
timestamps timestamps

supply_bond_payment_detail

id increments
timestamps timestamps
softDeletes softDeletes
weight double
karat integer
shares integer
paid double
discount double

account_trigger

id increments
account morphs
value double
unit json
softDeletes softDeletes
timestamps timestamps

markets

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string
national_id string
email string
country_id ^FK bigInteger
phone string