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

stakeholders

id increments
timestamps timestamps
softDeletes softDeletes
name 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
kind enum
units json
softDeletes softDeletes
timestamps timestamps

accounts

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

sub_accounts

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

account_transactions

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

stackholder_bonds

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

stackholder_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
street_number string
sub_number string
district string
details text

supply_bond_items

id increments
line_id string
product_id ^FK integer
karat_id ^FK integer
purity double
wage double
total_wage double
wage_tax double
item_tax double
discount double
notes longText
bond_id ^FK integer
gold_weight double
item_value string
item_count integer
item_weight double
weight double
other_rock_weight string
softDeletes softDeletes
timestamps timestamps

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

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 integer
name_en string
name_ar 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
kind string

stone_kinds

id increments
timestamps timestamps
softDeletes softDeletes
kind 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

supply_bond_total

id increments
bond_id integer
total_gold_24 double
total_wege double
total_diamond double
total_tax double
count_diamond integer
total_other_rocks double
total_accories double
softDeletes softDeletes
timestamps timestamps

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
nid string