multibank - Laravel Schema Designer

users

id increments
email string (64)
password string (128)
profile_type enum

ledger

id increments
timestamps timestamps
account_number ^FK bigInteger
softDeletes softDeletes
debit double (12,4)
credit double (12,2)
balance double (12,2)
remarks text
hash text
type string (20)

accounts

account_number increments
timestamps timestamps
user_id ^FK integer
first_name string (64)
middle_name string (64)
last_name string (64)
occupation string
mother_name string (128)
father_name string (128)
spouse_name string (128)
sex enum
zipcode string (10)
status enum
is_primary boolean
parent_account ^FK integer
branch_id ^FK integer
balance double (12,2)

addresses

id increments
timestamps timestamps
account_number ^FK integer
street text
barangay string
city string
province string
region string

bio_signatures

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
signature longText

requirements

id increments
timestamps timestamps
softDeletes softDeletes
account_number ^FK integer
attachment longText
name string (128)

transactions

id increments
timestamps timestamps
softDeletes softDeletes
amount decimal (8,2)
status enum
remarks text
account_number ^FK integer
type enum

bio_photos

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
photo longText

tellers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
first_name string (64)
middle_name string
last_name string (64)
branch_id ^FK integer

branches

id increments
timestamps timestamps
softDeletes softDeletes
name string (64)

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01