Table testdb.public.tsk_task Generated by
SchemaSpy
Legend:
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
c_pk int8 19
tsk_task.c_parent_task fk_tsk_tsk_parent R
tsk_task_group.c_pk Implied Constraint R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_assigned_at timestamp 22  √  null
c_assigned_to varchar 255  √  null
c_description varchar 255  √  null
c_finished_at timestamp 22  √  null
c_started_at timestamp 22  √  null
c_state varchar 255  √  null
c_task_id varchar 255
c_type varchar 255
c_parent_task int8 19  √  null
tsk_task.c_pk fk_tsk_tsk_parent R
c_task_group int8 19  √  null
tsk_task_group.c_pk fk_tsk_grp R

Table contained 0 rows at Sun Apr 21 20:44 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc tsk_task_pkey
c_task_id Must be unique Asc uc_task_id
c_pid Must be unique Asc uk_phu51i1beflvas188snv2wyt9

Close relationships: