pointage - Laravel Schema Designer

agents

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

qrcodes

id bigIncrements
qrcode string
token string
otp string (15)
date_otp datetime
agent_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

entities

id bigIncrements
name string
acronym string (15)
parent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

checkings

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

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