Home
vplan - basetables 1
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for vplan - basetables 1
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01