vplan - basetables 1 - Laravel Schema Designer

Users

username string
password string
firstname string
lastname string
infix string
fullname string
gender enum
email string
mobile integer
avatar binary
state enum
role enum
timestamps timestamps
softDeletes softDeletes

stages

id increments
board_id ^FK integer
name string
priority tinyInteger
stock_notification boolean
delay_day tinyInteger
previous_done boolean
efficiency tinyInteger
timestamps timestamps
softDeletes softDeletes
percentage smallInteger

boards

id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

order

id increments
reference string
customer_id ^FK integer
description string
due_date date
timestamps timestamps
softDeletes softDeletes

plan_card

id increments
order_id ^FK integer
stage_id ^FK integer
user_id ^FK integer
date date
duration tinyInteger
state enum
timestamps timestamps
softDeletes softDeletes

order_row

id increments
plan_object_id ^FK integer
type enum
unit enum
quantitiy tinyInteger
timestamps timestamps
softDeletes softDeletes

plan_card_row

id increments
plan_card_id ^FK integer
plan_object_row_id ^FK integer
timestamps timestamps
softDeletes softDeletes

employee_notification

id increments
domain_id ^FK integer
label string
color string (6)
timestamps timestamps
softDeletes softDeletes

stage_employees

stage_id ^FK integer
employee_id ^FK integer
percentage float (5,2)
timestamps timestamps
softDeletes softDeletes

employees

id increments
domain_id ^FK integer
firstname string
lastname string
infix string
fullname string
reference string
timestamps timestamps

employee_schedule

employee_id ^FK integer
type enum
date date
duration tinyInteger

stage_employee_schedules

stage_id ^FK integer
employee_id ^FK integer
date date
percentage float (5,2)
duration tinyInteger
timestamps timestamps
softDeletes softDeletes

work_type

id increments
name string
reference string
timestamps timestamps
domain_id ^FK integer

stage_work_types

stage_id ^FK integer
work_type_id ^FK integer
priority integer
timestamps timestamps
softDeletes softDeletes

stage_partitions

stage_id ^FK integer
percentage float (5,2)
timestamps timestamps
softDeletes softDeletes

customer

id increments
street1 string
street2 string
postcode string
city string
country string
reference string
timestamps timestamps

stock_notification

id increments
label string
color string (6)
timestamps timestamps
softDeletes softDeletes

employee_notification_stage

id increments
employee_notification_id ^FK integer
stage_id ^FK integer
percentage float (5,2)
timestamps timestamps
softDeletes softDeletes

order_event_status

id increments
timestamps timestamps
softDeletes softDeletes

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