projectlist_custom


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
feed_export.list_id FK1BA73D7568603D9C R
manual_task.project_list_id fk_manual_task_project_list_idx R
program.list_id FK_3g55e7kmn4wpntgyvxaevtoyq R
projectlist_custom.parent_id fk_project_list_parent R
projectlist_display.custom_id FKF0375FBABD960DE9 R
projectlist_export.draft_list_id FX_projectlist_export_projectlist R
projectlist_export.project_list_id FK_96rjsluq2dm8bjiy9awnlnt5c N
projectlist_filter.custom_id FKC915C580BD960DE9 R
projectlist_filter_fields.custom_id FK52DE8658BD960DE9 R
projectlist_run_history.project_list_id FK484595D8D9B40676 R
projectlist_run_statistic.project_list_id FK6A50E994D9B40676 R
name VARCHAR 40 null
user_id INT 10 null
sys_users.user_id FKC4A3857928C762A3 R
my_sites INT 10 √ 0
timeline_past_due INT 10 √ 0
schedule_past_due INT 10 √ 0
scheduled_7_days INT 10 √ 0
scheduled_30_days INT 10 √ 0
sort1_field_id INT 10 √ null
project_field.id FKC4A38579FED870A0 R
sort1_desc INT 10 √ 0
sort2_field_id INT 10 √ null
project_field.id FKC4A38579F321E1BF R
sort2_desc INT 10 √ 0
sort3_field_id INT 10 √ null
project_field.id FKC4A38579E76B52DE R
sort3_desc INT 10 √ 0
sort4_field_id INT 10 √ null
project_field.id FKC4A38579DBB4C3FD R
sort4_desc INT 10 √ 0
sort5_field_id INT 10 √ null
project_field.id FKC4A38579CFFE351C R
sort5_desc INT 10 √ 0
group_by INT 10 √ null
project_field.id FKC4A38579C6C48FCB R
column_one_link VARCHAR 255 √ null
version BIGINT 19 √ 1
cloned_from_id INT 10 √ null
locked_columns INT 10 √ null
sites_only BIT 1 √ null
last_run_time DATETIME 23 √ null
my_projects BIT 1 √ null
expand_milestones BIT 1 null
archived BIT 1 b'0'
list_group_id BIGINT 19 √ null
projectlist_group.id FK_nrd12sfsld2rb46houau3qfvi R
link_field_id INT 10 √ null
project_field.id fk_project_list_link_field R
last_updated_time DATETIME 19 √ null
parent_id INT 10 √ null
projectlist_custom.id fk_project_list_parent R
modified BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_nrd12sfsld2rb46houau3qfvi Performance Asc list_group_id
fk_project_list_link_field_idx Performance Asc link_field_id
fk_project_list_parent_idx Performance Asc parent_id
FKC4A3857928C762A3 Performance Asc user_id
FKC4A38579C6C48FCB Performance Asc group_by
FKC4A38579CFFE351C Performance Asc sort5_field_id
FKC4A38579DBB4C3FD Performance Asc sort4_field_id
FKC4A38579E76B52DE Performance Asc sort3_field_id
FKC4A38579F321E1BF Performance Asc sort2_field_id
FKC4A38579FED870A0 Performance Asc sort1_field_id
name Must be unique Asc/Asc name + user_id

Relationships

Close relationships within degrees of separation