GariCoV2_BDD - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
email string (100)
firstname string
lastname string
password string
is_verified boolean
verif_code string
address_id ^FK integer

addresses

id increments
timestamps timestamps
softDeletes softDeletes
country string
city string
street string

verifications

id increments
timestamps timestamps
softDeletes softDeletes
document_path string
is_valid boolean
expiration_date datetime
type enum
user_id ^FK integer

journeys

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
depart_address_id ^FK integer
arrival_address_id ^FK integer
status_id ^FK integer
depart_time datetime
arrival_time datetime
is_favorite boolean
seats_count smallInteger
description string
is_driver boolean

passengers

id increments
timestamps timestamps
softDeletes softDeletes
passenger_journey_id ^FK integer
price integer
journey_id ^FK integer
user_id ^FK integer
status_id ^FK integer

opinions

id increments
timestamps timestamps
softDeletes softDeletes
note tinyInteger
comment string
is_valid boolean
journey_id ^FK bigInteger
passenger_id ^FK bigInteger
user_id ^FK bigInteger
writer_id ^FK bigInteger

statuses

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

devices

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
uid string
name string
manufacturer string
os string
version string

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