adafina - Laravel Schema Designer

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