PROJECT_ASSIGNMENT |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_key | decimal (15,0) | PROJECT | fk_project_assignment2 | |
| person_key | decimal (15,0) | PERSON | fk_project_assignment1 | |
| web_time | varchar (1) | |||
| web_plan | varchar (1) | |||
| bill_rate | decimal (15,4) | YES | ||
| cost_rate | decimal (15,4) | YES | ||
| bill_customer | decimal (15,0) | YES | CUSTOMER | fk_project_assignment3 |
References made to PROJECT_ASSIGNMENT |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| TASK_ASSIGNMENT | project_key | fk_task_assignment2 |
| TASK_ASSIGNMENT | person_key | fk_task_assignment2 |
Dependent Views |
|
| View Name | |
|---|---|
| PROJECT_ASSIGNMENT_VIEW | |
| RATES_VIEW | |
Check Constraints for PROJECT_ASSIGNMENT |
|
| Check Constraint Name | Definition |
|---|---|
| cc_pjta_web_plan | (web_plan = 'N' or (web_plan = 'Y')) |
| cc_pjta_web_time | (web_time = 'N' or (web_time = 'Y')) |
Indexes on PROJECT_ASSIGNMENT |
|
| Index Name | Column(s) |
|---|---|
| pk_project_assignment | project_key, person_key |