pointage - Laravel Schema Designer

agents

id bigIncrements
firstName string
lastName string
matricule string
image string
entity_id ^FK integer
qrcode_id ^FK integer
softDeletes softDeletes
email string

qrcodes

id bigIncrements
timestamps timestamps
qrcode string
token string
otp string
softDeletes softDeletes
date_otp datetime
agent_id integer

entity

id bigIncrements
name string
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer

checkings

id bigIncrements
timestamps timestamps
softDeletes softDeletes
checking_date datetime
checkout_date datetime
qrcode_id ^FK integer
location enum
entity_id ^FK integer
comments text

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