ad_task

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_task_id numeric 10 null
ad_ctxhelp.ad_task_id Implied Constraint R
ad_menu.ad_task_id adtask_admenu R
ad_task_access.ad_task_id adtask_adtaskaccess C
ad_task_trl.ad_task_id ad_tasktrl C
ad_taskinstance.ad_task_id ad_task_taskinstance C
ad_wf_node.ad_task_id adtask_adwfnode R
ad_workbenchwindow.ad_task_id adtask_adworkbenchwindow R
asp_clientexception.ad_task_id adtask_aspclientexception R
asp_task.ad_task_id adtask_asptask R
pp_order_node.ad_task_id adtask_ppordernode R
ad_client_id numeric 10 null
ad_client.ad_client_id taskclient R
ad_org_id numeric 10 null
ad_org.ad_org_id taskorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
accesslevel bpchar 1 null
os_command varchar 2000 null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adtask R
isserverprocess bpchar 1 √ 'N'::bpchar
ad_task_uu varchar 36 √ NULL::character varying
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adtask R

Indexes

Constraint Name Type Sort Column(s)
ad_task_pkey Primary key Asc ad_task_id
ad_task_name Must be unique Asc/Asc ad_client_id + name
ad_task_uu_idx Must be unique Asc ad_task_uu

Check Constraints

Constraint Name Constraint
ad_task_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation