JMT - Laravel Schema Designer

loans

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
loan_type_id ^FK integer
next_payment_due date
cache_balance decimal
contract_number string

customers

id increments
timestamps timestamps
mobile_number string (60)
id_card string (60)
softDeletes softDeletes
firstname string
lastname string

messages

id increments
timestamps timestamps
endpoint_id ^FK integer
customer_id ^FK integer
verify_key string
msg_template_id ^FK integer
content text
custom text

endpoints

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
type enum
code string
token string

transactions

id increments
timestamps timestamps
softDeletes softDeletes
type enum
transaction_id string
contact_number string
execute_date datetime
status enum
amount decimal
payment_id ^FK integer

advertises

id increments
timestamps timestamps
softDeletes softDeletes
type enum
text text
media_ids text
description text

payments

id increments
timestamps timestamps
softDeletes softDeletes
pay_date datetime
media_id ^FK integer
status enum
amount decimal

lone_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text

documents

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
status enum

users

id increments
timestamps timestamps
softDeletes softDeletes
username string
password string

activities

id increments
timestamps timestamps
user_id ^FK integer
object_type string
object_id integer

stores

id increments
timestamps timestamps
softDeletes softDeletes
name string
address text
geo_lat float
geo_long float

contents

id increments
timestamps timestamps
softDeletes softDeletes
key string
value text

doc_application

id increments
timestamps timestamps
softDeletes softDeletes
loan_type_id ^FK integer
document_id ^FK integer
firstname string
lastname string
id_card string
birth_date date
Formdata text

msg_templates

id increments
timestamps timestamps
softDeletes softDeletes
name string
content text

medias

id increments
timestamps timestamps
softDeletes softDeletes
path string

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