| Previous: approval_history | Unanet Data Model | Next: attachment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | project_key | decimal(15) | project | fk_assignment_display1 | ||
| 2. | task_key | decimal(15) | task | fk_assignment_display2 | ||
| 3. | person_key | decimal(15) | person | fk_assignment_display3 | ||
| 4. | show | char(1) | ('Y') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| person_key | person | person_key | fk_assignment_display3 |
| project_key | project | project_key | fk_assignment_display1 |
| task_key | task | task_key | fk_assignment_display2 |
| Name | Definition |
| cc_ad_show | ([show]='Y' OR [show]='N') |
| Index Name | Unique | Column Name | Asc Or Desc |
| idx_assignment_display1 | true | person_key | Asc |
| project_key | |||
| task_key | |||
| idx_assignment_display2 | false | project_key | Asc |
| idx_assignment_display3 | false | task_key | Asc |