Table af3b3c41.project_task Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id char 36
calls.parent_id Defined in XML R
emails.parent_id Defined in XML R
meetings.parent_id Defined in XML R
notes.parent_id Defined in XML R
tasks.parent_id Defined in XML R
emails_beans.bean_id Defined in XML R
project_task_audit.parent_id Defined in XML R
date_entered datetime 19  √  null
date_modified datetime 19  √  null
project_id char 36
project.id Defined in XML R
project_task_id int 11  √  null
name varchar 50  √  null
status varchar 255  √  null
description text 65535  √  null
resource_id text 65535  √  null
predecessors text 65535  √  null
date_start date 10  √  null
time_start int 11  √  null
time_finish int 11  √  null
date_finish date 10  √  null
duration int 11  √  null
duration_unit text 65535  √  null
actual_duration int 11  √  null
percent_complete int 11  √  null
date_due date 10  √  null
time_due time 8  √  null
parent_task_id int 11  √  null
assigned_user_id char 36  √  null
users.id Defined in XML R
modified_user_id char 36  √  null
users.id Defined in XML R
priority varchar 255  √  null
created_by char 36  √  null
users.id Defined in XML R
milestone_flag bit 1  √  0
order_number int 11  √  1
task_number int 11  √  null
estimated_effort int 11  √  null
actual_effort int 11  √  null
deleted bit 1  √  0
utilization int 11  √  100
team_id char 36  √  null
teams.id Defined in XML R
team_set_id char 36  √  null
team_sets.id Defined in XML R
team_sets_teams.team_set_id Defined in XML R
acl_team_set_id char 36  √  null

Analyzed at Mon Jul 09 08:29 UTC 2018

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
acl_team_set_id + deleted Performance Asc/Asc idx_project_task_acl_tmst_id
team_set_id + deleted Performance Asc/Asc idx_project_task_tmst_id

Close relationships  within of separation: