Home
adafina
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
timestamps
timestamps
name
text
email
text
email_verified_at
timestamp
password
string
remember_token
text
id_roles
FK
integer
is_approved_admin
integer
no_hp
string
roles
id
increments
timestamps
timestamps
name
text
description
text
organizations
id
increments
timestamps
timestamps
name
text
id_parent
FK
integer
address
text
is_parent
integer
user_organizations
id
increments
timestamps
timestamps
id_user
FK
integer
id_org
FK
integer
id_role
FK
integer
orgs_roles
id
increments
timestamps
timestamps
id_org
FK
integer
id_role
FK
integer
head_of_accounts
id
increments
timestamps
timestamps
name
string
coas_of_orgs
id
bigIncrements
id_with_org
bigInteger
id_org
FK
integer
code
string
(200)
name
string
(200)
saldo
bigInteger
id_head_account
FK
integer
id_parent_with_org
FK
bigInteger
is_lock
integer
timestamps
timestamps
description
longText
id_coa_category
FK
bigInteger
item_transactions
id
increments
id_trs_with_org
FK
bigInteger
id_coa_with_org
FK
bigInteger
id_org
FK
bigInteger
nominal_debit
bigInteger
nominal_credit
bigInteger
is_debit_credit
integer
timestamps
timestamps
transactions
id
increments
id_with_org
bigInteger
id_org
FK
bigInteger
trs_code
string
(200)
trs_type
integer
trs_date
timestamp
trs_desc
longText
trs_ref
string
(200)
trs_pic
string
(200)
trs_ket
string
(100)
trs_via
integer
timestamps
timestamps
coa_category_defaults
id
bigIncrements
name
string
(200)
id_head_account
FK
integer
timestamps
timestamps
transactions_types
id
bigIncrements
name
string
(200)
timestamps
timestamps
programs_coas
id
bigIncrements
id_program_with_org
FK
bigInteger
id_trs_type
FK
bigInteger
id_coa_with_org
FK
bigInteger
timestamps
timestamps
programs
id
bigIncrements
id_with_org
bigInteger
id_org
FK
bigInteger
name
string
(500)
price_per_qty
bigInteger
code
string
(500)
timestamps
timestamps
contacts_types
id
increments
name
string
(200)
timestamps
timestamps
contacts
id
bigIncrements
id_with_org
bigInteger
id_org
FK
bigInteger
id_contacts_types
FK
bigInteger
code
string
(200)
name
string
(300)
email
string
(300)
address
string
(500)
no_hp
string
(200)
timestamps
timestamps
departments
id
increments
timestamps
timestamps
id_contacts
FK
bigInteger
name
string
(200)
contacts_coas
id
bigIncrements
timestamps
timestamps
id_contacts
FK
bigInteger
id_coa_with_org
FK
bigInteger
programs_transactions
id
increments
id_program_with_org
FK
bigInteger
id_transactions
FK
bigInteger
description
string
(500)
price_per_qty
bigInteger
total_qty
integer
price_total
bigInteger
id_coa_with_org_choose
FK
bigInteger
timestamps
timestamps
contacts_transactions
id
increments
timestamps
timestamps
id_contacts
FK
bigInteger
id_transactions
FK
bigInteger
trs_total
bigInteger
biaya_transactions
id
increments
timestamps
timestamps
id_transactions
FK
bigInteger
id_coa_with_org
FK
bigInteger
id_coa_with_org_bayar_dari
FK
bigInteger
description
string
(500)
total_qty
integer
price_per_qty
bigInteger
price_total
bigInteger
coa_defaults
id
increments
code
string
(200)
name
string
(200)
timestamps
timestamps
id_head_account
FK
integer
id_parent
FK
integer
kas_bank_transactions
id
bigIncrements
id_transactions
FK
bigInteger
id_coa_with_org_top
FK
bigInteger
id_coa_with_org_bottom
FK
bigInteger
timestamps
timestamps
description
string
(500)
custom_report_text_orgs
id
bigIncrements
timestamps
timestamps
id_with_org
bigInteger
id_org
bigInteger
id_pos
bigInteger
type
string
(200)
text
string
(200)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01