Toilet Management System - Laravel Schema Designer

toilet

id increments
toilet_no bigInteger
location string (255)
latitude double (10,8)
longitude double (11,8)
image string
landmark string (255)
timestamps timestamps

product

id increments
name string (255)
image string
timestamps timestamps

user

id increments
role enum
name string (255)
username string (255)
password string (255)
employee_code string
email string (255)
aadhar_no string (12)
phone string (15)
address string
image string
status enum
master boolean
timestamps timestamps

contact

id increments
contact_type enum
name string
phone string (15)
alternative_phone string
timestamps timestamps

token_book

id increments
toilet_id ^FK integer
book_no string (64)
book_color enum
serial_no_from integer
serial_no_to integer
status enum
timestamps timestamps

toilet_inventory

id increments
toilet_id ^FK integer
product_id ^FK integer
quantity integer
timestamps timestamps

grievance

id increments
toilet_id ^FK integer
user_id ^FK integer
image string
voice_note string
timestamps timestamps

sanitation

id increments
toilet_id ^FK integer
user_id ^FK integer
attendance_id ^FK integer
session_id ^FK integer
time datetime
before_images string
after_images string
timestamps timestamps

income

id increments
toilet_id ^FK integer
user_id ^FK integer
session_id ^FK integer
book_id ^FK integer
date date
token_start integer
token_end integer
cash double
upi double
total double
entry_type enum
timestamps timestamps

attendance

id increments
toilet_id ^FK integer
user_id ^FK integer
image string
session_id ^FK integer
timestamps timestamps

toilet_user

toilet_id ^FK integer
user_id ^FK integer

session

id increments
title string (255)
session_start datetime
session_end datetime
timestamps timestamps

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