| Previous: project_location | Unanet Data Model | Next: project_note_attachment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_note_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project | fk_project_note1 | ||
| 3. | creator_person_key | decimal(15) | person | fk_project_note2 | ||
| 4. | modified_person_key | decimal(15) | person | fk_project_note3 | ||
| 5. | project_note_status_key | decimal(15) | project_note_status | fk_project_note5 | ||
| 6. | project_note_type_key | decimal(15) | project_note_type | fk_project_note4 | ||
| 7. | create_date | datetime | ||||
| 8. | modified_date | datetime | ||||
| 9. | title | varchar(128) | ||||
| 10. | action_date | datetime | ||||
| 11. | completed_date | datetime | ||||
| 12. | assignee_person_key | decimal(15) | person | fk_project_note6 | ||
| 13. | note | varchar(2000) | ||||
| 14. | enforce_role_restriction | char(1) | ('N') | |||
| 15. | user01 | varchar(128) | ||||
| 16. | user02 | varchar(128) | ||||
| 17. | user03 | varchar(128) | ||||
| 18. | user04 | varchar(128) | ||||
| 19. | user05 | varchar(128) | ||||
| 20. | user06 | varchar(128) | ||||
| 21. | user07 | varchar(128) | ||||
| 22. | user08 | varchar(128) | ||||
| 23. | user09 | varchar(128) | ||||
| 24. | user10 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| creator_person_key | person | person_key | fk_project_note2 |
| modified_person_key | person | person_key | fk_project_note3 |
| assignee_person_key | person | person_key | fk_project_note6 |
| project_key | project | project_key | fk_project_note1 |
| project_note_status_key | project_note_status | project_note_status_key | fk_project_note5 |
| project_note_type_key | project_note_type | project_note_type_key | fk_project_note4 |
| Table | Column | Foreign Key Name |
| project_note_attachment | project_note_key | fk_project_note_attachment1 |
| project_note_audit | project_note_key | fk_project_note_audit1 |
| project_note_comment | project_note_key | fk_project_note_comment1 |
| project_note_role | project_note_key | fk_project_note_role1 |
| Name | Definition |
| cc_pn_action_date | ([action_date]>='1900-01-01' AND [action_date]<='2099-12-31') |
| cc_pn_completed_date | ([completed_date]>='1900-01-01' AND [completed_date]<='2099-12-31') |
| cc_pn_enf_role_restriction | ([enforce_role_restriction]='N' OR [enforce_role_restriction]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_note | true | project_note_key | Asc |
| idx_project_note1 | false | project_key | Asc |