crm - Laravel Schema Designer

target_types

id increments
timestamps timestamps
softDeletes softDeletes
type string
is_active boolean

targets

id increments
timestamps timestamps
softDeletes softDeletes
target_type_id ^FK integer
targetable_type string
targetable_id integer
period_type enum
start_date date
end_date date
target_value decimal
current_value decimal
is_auto_accept boolean
status enum
notes text
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_accepted boolean
reason text

target_assignments

id increments
timestamps timestamps
softDeletes softDeletes
target_id ^FK integer
assignable_id integer
assignable_type string
target_value string
current_value string
is_auto_accept boolean
status enum

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