gistfile1.txt

$task = [
{
id => int, 
title => text, 
date_created => time stamp (TS),
date_modified => TS,
date_ended => TS,
priority_levels => (
         id => int, 
         date_created => TS,
         task_id => int,
         goal_id => int,
         priority => int,
)
status_levels => (
         id => int, 
         date_created => TS,
         task_id => int,
         goal_id => int,
         status => enum ( active, inactive, invalid )
)

$goal => [
{
id => init,
todo => text,
date_created => TS,
date_modified => TS,
date_ended => TS,
task_id => int,
priority_level => (
         id => int, 
         date_created => TS,
         task_id => int,
         goal_id => int,
         priority => int,
  )

status_level =(
         id => int, 
         date_created => TS,
         task_id => int,
         goal_id => int,
        status => enum ( active, inactive, invalid )

}
}
]
]