Table: budget_detail
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
budget_detail_key |
decimal(15) |
|
|
|
| 2. |
|
budget_organization_key |
decimal(15) |
|
budget_organization |
fk_budget_detail1 |
| 3. |
|
account_key |
decimal(15) |
|
account |
fk_budget_detail2 |
| 4. |
|
fiscal_month_key |
decimal(15) |
|
fiscal_month |
fk_budget_detail3 |
| 5. |
|
amount |
decimal(18,2) |
|
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| account_key |
account |
account_key |
fk_budget_detail2 |
| budget_organization_key |
budget_organization |
budget_organization_key |
fk_budget_detail1 |
| fiscal_month_key |
fiscal_month |
fiscal_month_key |
fk_budget_detail3 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_budget_detail |
true |
budget_detail_key |
Asc |
| idx_budget_detail1 |
true |
budget_organization_key |
Asc |
| |
|
account_key |
|
| |
|
fiscal_month_key |
|
| idx_budget_detail2 |
false |
account_key |
Asc |
| idx_budget_detail3 |
false |
fiscal_month_key |
Asc |