missions3 - Laravel Schema Designer

missions

id increments
timestamps timestamps

tasks

id increments
timestamps timestamps
step_id bigInteger
is_required boolean
task_template_id bigInteger
status string
mission_id bigInteger

task_types

id increments
timestamps timestamps

mission_types

id increments
timestamps timestamps

task_templates

id increments
timestamps timestamps
mission_type_id bigInteger
task_type_id bigInteger
order integer
is_required boolean
price float
description text
count_handler string
deleted_at datetime
step_template_id bigInteger

task_field_types

id increments
timestamps timestamps
name string
slug string
is_multi_value boolean

task_field_templates

id increments
timestamps timestamps
softDeletes softDeletes
task_field_type string
task_type_id bigInteger
order integer
parent_id bigInteger
name string
is_required boolean
properties json

task_details_schema_handlers

name string
slug string

task_details_schema_types

name string
slug string

task_fields

id increments
timestamps timestamps
deleted_at softDeletes
task_id bigInteger
task_field_template_id bigInteger
value string
is_ready boolean
fields_schema_id bigInteger

step_templates

id increments
timestamps timestamps
softDeletes softDeletes
mission_type_id bigInteger

steps

id increments
timestamps timestamps
step_template_id bigInteger
order integer
status string
mission_id string

details_schema

id increments
timestamps timestamps
detailable_type string
detailable_id bigInteger
name string
type string
order integer
value string
parent_id bigInteger

fields_schema

id increments
timestamps timestamps
name string
order integer
parent_id integer
is_required boolean
task_field_type string
properties json
task_id integer

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