Table: project_note

Columns
  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)      
Foreign Keys
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
Referenced from
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
Check Constraints
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')
Indices
Index Name Unique Column Name Asc Or Desc
pk_project_note true project_note_key Asc
idx_project_note1 false project_key Asc