emadzilwb - Laravel Schema Designer

users

id bigIncrements
name string (50)
email string
email_verified_at timestamp
password string
status boolean
usertype_id integer
created_by string (50)
updated_by string (50)
timestamps timestamps

usertypes

id increments
description string
timestamps timestamps

customers

id increments
cust_name string (255)
phone_number string (20)
location string (255)
cardUID integer
status boolean
created_by string (50)
updated_by string (50)
timestamps timestamps

paymentpoints

id increments
pay_point_name string (255)
phone_number string (20)
location string (255)
created_by string (50)
updated_by string (50)
timestamps timestamps

rechargemachines

id increments
paymentpoint_id integer
store_id integer
brand string (50)
model string (50)
serialnum string (50)
macaddr macAddress
machineId integer
created_by string (50)
updated_by string (50)
timestamps timestamps

rechargemachinetrans

id increments
rechargemachine_id integer
transref string (20)
crDrType char (10)
crDr float (20,2)
balance float (20,2)
created_by string (50)
timestamps timestamps

kiosks

id increments
kiosk_name string (255)
kiosk_number string (20)
location string (255)
gpslat decimal (10,8)
gpslong decimal (11,8)
created_by string (50)
updated_by string (50)
timestamps timestamps

dispensemachines

id increments
kiosk_id integer
brand string (255)
model string (255)
serialnum string (50)
macaddr macAddress
machineId integer
quantityInL bigInteger
created_by string (50)
updated_by string (50)
timestamps timestamps

transactions

id increments
timestamps timestamps
SrNo bigInteger
entryNo bigInteger
cardUID integer
date date
time time
userName string (20)
crDr float (20,2)
crDrType char (10)
balance float (20,2)
seriesNo string (20)
storeId string (20)
machineId integer
quantityInMl bigInteger
buttonNo string (10)

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