hayvee - Laravel Schema Designer

hospitals

id increments
timestamps timestamps
softDeletes softDeletes
name string
address text
latitude float
longitude float

customers

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
full_name string
phone string
hospital_id ^FK integer
medical_records string
ktp string
golongan_darah string
alergi text

vct_on_demands

id increments
timestamps timestamps
customer_id ^FK integer
hospital_id ^FK integer
hospital_vct_staff_id ^FK integer
date_order datetime
address_detail text
latitude float
longitude float
status_order tinyInteger
checkup_date date
checkup_time time
price decimal
tax decimal
payment_status tinyInteger

hospital_vct_staffs

id increments
timestamps timestamps
softDeletes softDeletes
full_name string
hospital_id ^FK integer

customer_balance

id increments
timestamps timestamps
customer_id ^FK integer
amount decimal
flow_status tinyInteger
balance decimal
description text

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