tasks

16 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
usrs_id int 4 √ null
usrs.usrs_id FK_tasks_usrs_idR
usr_grps_id int 4 √ null
usr_grps.usr_grps_id FK_tasks_usr_grps_idR
orgs_id int 4 √ null
orgs.orgs_id FK_tasks_orgs_idR
task_uniq_id nvarchar 200 null
task_type_id int 4 null
task_obj_id nvarchar 200 √ null
task_obj_descr nvarchar 1000 √ null
task_created datetime 16,3 null
task_valid_to datetime 16,3 √ null
task_inpr_idle datetime 16,3 √ null
task_status int 4 null
task_status_adnl int 4 ((0))
task_bin varbinary 2147483647 null
task_category_id int 4 √ null

Relationships

Close relationships within degrees of separation