vplan! - 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
rememberToken rememberToken

stages

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

boards

id ^FK integer
environment_id ^FK integer
name string
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
firstname string
lastname string
infix string
fullname string
gender enum
job_description string
avatar binary
softDeletes softDeletes
timestamps timestamps

stage_work_types

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

stage_partitions

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

orders

id increments
parent_id integer
project_id integer
relation_id ^FK integer
number string
type enum
description text
contact string (255)
creation_date date
promised_date date
desired_date date
timestamps timestamps
softDeletes softDeletes

projects

id increments
relation_id ^FK integer
name string (255)
timestamps timestamps
softDeletes softDeletes

order_rows

id increments
order_id ^FK integer
inventory_id ^FK integer
position tinyInteger
type enum
code string
description string (255)
quantitiy float (8,2)
unit enum
timestamps timestamps
softDeletes softDeletes

plan_orders

id increments
order_id ^FK integer
start_date date
end_date date
deleted_date date
status enum
timestamps timestamps
softDeletes softDeletes

plan_order_cards

id increments
plan_order_id ^FK integer
stage_id ^FK integer
date date
duration float (8,2)
done boolean
assignee_user_id ^FK integer
status string
timestamps timestamps
softDeletes softDeletes

plan_order_card_rows

id increments
plan_order_card_id ^FK integer
order_row_id ^FK integer
in_stock integer
done boolean
timestamps timestamps
softDeletes softDeletes

relation

id increments
company string
contact string
address string
zipcode string
city string
country string
phone string
email string
timestamps timestamps
softDeletes softDeletes

board_settings

id increments
board_id ^FK integer
plan_method enum
monday boolean
tuesday boolean
wednesday boolean
thursday boolean
friday boolean
saturday boolean
sunday boolean
softDeletes softDeletes
timestamps timestamps

work_types

id increments
name string
code string
timestamps timestamps
softDeletes softDeletes

employee_schedules

id increments
employee_id ^FK integer
type enum
date date
timestamps timestamps
softDeletes softDeletes

inventory

id increments
item string
code string
type enum
warehouse string
location string
in_stock integer
timestamps timestamps
softDeletes softDeletes

environment

id increments
name string
type string
customer string
url string
server_location string

stage_employee_schedule

stage_id ^FK integer
employee_id ^FK integer
date date
hours tinyInteger
timestamps timestamps
softDeletes softDeletes

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