EXPENSE_PROJECT_ALLOCATION |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| expense_project_allocation_key | decimal (15,0) | |||
| expense_report_key | decimal (15,0) | EXPENSE_REPORT | fk_expense_project_allocation1 | |
| project_key | decimal (15,0) | YES | PROJECT | fk_expense_project_allocation2 |
| task_key | decimal (15,0) | YES | TASK | fk_expense_project_allocation3 |
| allocation | decimal (18,0) | YES | ||
| sequence | int | |||
References made to EXPENSE_PROJECT_ALLOCATION |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| EXPENSE_DATA | expense_project_allocation_key | fk_expense_data6 |
Dependent Views |
|
| View Name | |
|---|---|
| EXPENSE_PROJECT_VIEW | |
Indexes on EXPENSE_PROJECT_ALLOCATION |
|
| Index Name | Column(s) |
|---|---|
| pk_expense_project_allocation | expense_project_allocation_key |