| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
|||||||||||||||||||||||||||||||
| name | VARCHAR | 50 | √ | null |
|
|
||||||||||||||||||||||||||||||
| date_entered | DATETIME | 26 | √ | null |
|
|
||||||||||||||||||||||||||||||
| date_modified | DATETIME | 26 | √ | null |
|
|
||||||||||||||||||||||||||||||
| modified_user_id | CHAR | 36 | √ | null |
|
|
||||||||||||||||||||||||||||||
| created_by | CHAR | 36 | √ | null |
|
|
||||||||||||||||||||||||||||||
| description | TEXT | 65535 | √ | null |
|
|
||||||||||||||||||||||||||||||
| deleted | BIT | 1 | √ | 0 |
|
|
||||||||||||||||||||||||||||||
| task_start_date_type | VARCHAR | 255 | √ | null |
|
|
||||||||||||||||||||||||||||||
| task_due_date_type | VARCHAR | 255 | √ | null |
|
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_cj_act_tpl_ass_rl_act_id | Performance | Asc | assignee_rule_activity_id |
| idx_cj_act_tpl_due_dt_act_id | Performance | Asc | due_date_activity_id |
| idx_cj_act_tpl_jry_tpl_id | Performance | Asc | dri_workflow_template_id |
| idx_cj_act_tpl_mmt_strt_act_id | Performance | Asc | momentum_start_activity_id |
| idx_cj_act_tpl_nxt_jry_tpl_id | Performance | Asc | start_next_journey_id |
| idx_cj_act_tpl_parent_id | Performance | Asc | parent_id |
| idx_cj_act_tpl_stage_tpl_id | Performance | Asc | dri_subworkflow_template_id |
| idx_cj_act_tpl_start_dt_act_id | Performance | Asc | start_date_activity_id |
| idx_cj_act_tpl_trgt_asgn_te_id | Performance | Asc | target_assignee_team_id |
