crm - Laravel Schema Designer

target_types

id increments
timestamps timestamps
softDeletes softDeletes
slug string
is_active boolean
model_class string

targets

id increments
timestamps timestamps
softDeletes softDeletes
target_type_id ^FK integer
period_type enum
start_date date
end_date date
total_target_value decimal
current_value decimal
is_auto_accept boolean
status enum
auto_distribute boolean
description longText
is_recurring boolean
achieved_at date

target_progress_logs

id increments
timestamps timestamps
softDeletes softDeletes
target_id ^FK integer
added_value decimal
value_before decimal
value_after decimal
is_approved boolean
rejection_reason text
effective_date date
needs_approval boolean
approved_by integer
approved_at timestamp
progressable_type string
progressable_id string

target_assignments

id increments
timestamps timestamps
softDeletes softDeletes
target_id ^FK integer
assignable_id integer
assignable_type string
assigned_value decimal
current_value decimal
override_auto_accept boolean
status enum
completed_at timestamp

target_templates

id increments
timestamps timestamps
name string
target_type_id ^FK integer
period_type enum
default_value decimal
auto_distribute boolean
is_auto_accept boolean
description longText

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