missions2 - Laravel Schema Designer

missions

id increments
timestamps timestamps

tasks

id increments
timestamps timestamps
parent_id bigInteger
is_required boolean
details json
fields json
task_template_id bigInteger

task_types

id increments
timestamps timestamps
details_schema json

mission_types

id increments
timestamps timestamps

task_templates

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

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
softDeletes softDeletes
task_id bigInteger
task_field_template_id bigInteger
value string
is_ready boolean

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