Home
elterb
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (5)
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
categories
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
purity
id
increments
timestamps
timestamps
softDeletes
softDeletes
banks
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
country_id
FK
bigInteger
city_id
FK
integer
branch
string
main_account_number
string
iban_number
string
swift_number
string
account_short_name
string
cities
id
increments
timestamps
timestamps
softDeletes
softDeletes
countries
id
increments
timestamps
timestamps
softDeletes
softDeletes
nationalities
id
increments
timestamps
timestamps
softDeletes
softDeletes
discount_bonds
id
increments
timestamps
timestamps
softDeletes
softDeletes
bond_date
date
supplier_id
integer
bond_id
integer
bond_number
string
bond_docs
string
notes
text
value
double
unit
json
returned_bonds
id
increments
bond_id
integer
bond_type
enum
bond_date
date
bond_number
string
supplier_id
integer
gold_price
double
entity_gold_price
double
notes
text
softDeletes
softDeletes
timestamps
timestamps
total_gold_24
double
count_item
integer
total_tax
double
bond_total_value
double
returned_bond_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
line_id
integer
karat
integer
item_weight
double
purity
integer
wage
double
count_item
integer
item_value
double
rock_weight
double
diamond_weight
double
reservation_bonds
id
increments
timestamps
timestamps
softDeletes
softDeletes
date
date
user
morphs
tax_value
double
type
enum
total_gold_value
double
total_weight
double
total_tax
double
reservation_bond_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
gold_price
double
entity_gold_price
double
weight
double
kerat
integer
total_value
double
weight_24
double
notes
text
tax
double
assets
id
increments
timestamps
timestamps
softDeletes
softDeletes
name_ar
string
name_en
string
value_ar
string
value_en
string
parent_id
integer
partners
id
increments
timestamps
timestamps
softDeletes
softDeletes
username
string
name
string
email
string
phone
string
national_id
FK
bigInteger
country_id
FK
bigInteger
city_id
FK
bigInteger
national_expir_date
date
national_image
string
partnership_start_date
date
partnership_rate
integer
documents
id
increments
timestamps
timestamps
softDeletes
softDeletes
file
string
name
string
company_name
string
document_number
string
start_date
date
end_date
string
reminder_days
integer
details
text
cards
id
increments
timestamps
timestamps
softDeletes
softDeletes
card_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
logo
string
×
Comments for elterb
ahmed.hesham . 16 January 2023
ستم التعامل مع جدول bont_item عن طريق ٣ موديل فى الكود
ahmed.hesham . 16 January 2023
التوتال بيتم ادخالها و اعتمادها فى التعاملات و ليس القيمة المحسوبة و الفرق يتم وضعه فى صناديق العجز فى التعاملات الحساية فى الشجرة
ahmed.hesham . 16 January 2023
يتم التعامل مع الجداول المساعدة عن طريق جدول واحد يحمل النوع
ahmed.hesham . 16 January 2023
سند بداية المدة يجب توضيح الحساب المرتبط مع العملية
ahmed.hesham . 16 January 2023
يتم التعمال مع المرتجع على ٣ موديل من خلال الكود
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01