carwasher - Laravel Schema Designer

customer

id increments
timestamps timestamps
softDeletes softDeletes
fullname string (60)
email string (60)
handphone string (12)
username string (20)
password string (50)

address

id increments
timestamps timestamps
softDeletes softDeletes
address string (60)
postcode smallInteger
city string (20)
state string (20)
customers_id ^FK integer

car

id increments
timestamps timestamps
softDeletes softDeletes
carplate string (8)
carcolor string (20)
carmodel string (60)
customers_id ^FK integer

washer

id increments
timestamps timestamps
softDeletes softDeletes
fullname string (60)
photopath text
icno string (15)
hpno string (16)
username string (30)
password string (30)

job

id increments
timestamps timestamps
softDeletes softDeletes
status smallInteger
addresss_id ^FK integer
cars_id ^FK integer
customers_id ^FK integer
washers_id ^FK integer
payments_id ^FK integer
jobstarttime timestamp
jobendtime timestamp
beforephoto json
afterphoto json

payment

id increments
timestamps timestamps
softDeletes softDeletes
amount double
dno bigInteger
ptype string (30)

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