bikemart_workshop - Laravel Schema Designer

maintenances

id increments
client_id ^FK integer
mechanic_id ^FK integer
service_id ^FK integer
bicycle_id ^FK integer
date datetime
due_date datetime
status string
observations string
description string
parts string
total double (15,4)
timestamps timestamps
softDeletes softDeletes

clients

id increments
user_id ^FK integer
name string
address string
mobile_phone string
telephone string
email string
notes string
timestamps timestamps
softDeletes softDeletes

bicycles

id increments
client_id ^FK integer
make_id ^FK integer
model string
color string
serial string
timestamps timestamps
softDeletes softDeletes

mechanics

id increments
user_id ^FK integer
name string
email string
timestamps timestamps
softDeletes softDeletes

services

id increments
name string
timestamps timestamps
softDeletes softDeletes

requests

id increments
client_id ^FK integer
maintenance_id ^FK integer
description string
parts string
total double (15,4)
timestamps timestamps
softDeletes softDeletes

comments

id increments
maintenance_id ^FK integer
description string
timestamps timestamps
softDeletes softDeletes

makes

id increments
name string
timestamps timestamps
softDeletes softDeletes

ratings

id increments
maintenance_id ^FK integer
value tinyInteger
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
softDeletes softDeletes

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