PROJECT_NOTE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_note_key | decimal (15,0) | |||
| project_key | decimal (15,0) | PROJECT | fk_project_note1 | |
| creator_person_key | decimal (15,0) | PERSON | fk_project_note2 | |
| modified_person_key | decimal (15,0) | PERSON | fk_project_note3 | |
| project_note_type_key | decimal (15,0) | PROJECT_NOTE_TYPE | fk_project_note4 | |
| create_date | datetime | |||
| modified_date | datetime | |||
| action_date | datetime | YES | ||
| note | text | YES | ||
| attachment_key | decimal (15,0) | YES | ||
Indexes on PROJECT_NOTE |
|
| Index Name | Column(s) |
|---|---|
| pk_project_note | project_note_key |