All Foreign Keys |
||||
| Table Name | Field Name | References Table |
Foreign Key Name |
|
|---|---|---|---|---|
| 1. | ADP_ORGANIZATION | organization_key | CUSTOMER | fk_adp_organization |
| 2. | ADP_SETUP | pay_code_key | PAY_CODE | fk_adp_setup3 |
| 3. | ADP_SETUP | project_key | PROJECT | fk_adp_setup1 |
| 4. | ADP_SETUP | task_key | TASK | fk_adp_setup2 |
| 5. | AIR_DETAIL | expense_data_key | EXPENSE_DATA | fk_air_detail1 |
| 6. | ALTERNATE | person_key | MEMBER | fk_alternate2 |
| 7. | ALTERNATE | role_key | MEMBER | fk_alternate2 |
| 8. | ALTERNATE | alternate_key | PERSON | fk_alternate1 |
| 9. | APPROVAL_CHAIN | chain_key | CHAIN | fk_approval_chain1 |
| 10. | APPROVAL_CHAIN | person_key | PERSON | fk_approval_chain2 |
| 11. | APPROVAL_HISTORY | person_key | PERSON | fk_approval_history2 |
| 12. | APPROVAL_HISTORY | passed_to | PERSON | fk_approval_history4 |
| 13. | APPROVAL_HISTORY | person_time_key | PERSON_TIME | fk_approval_history1 |
| 14. | APPROVAL_HISTORY | project_key | PROJECT | fk_approval_history3 |
| 15. | APPROVAL_HISTORY | role_key | ROLE | fk_approval_history5 |
| 16. | APPROVER | person_key | PERSON | fk_approver1 |
| 17. | APPROVER | approver_key | PERSON | fk_approver2 |
| 18. | BILLING_INFO | vendor_key | VENDOR | fk_billing_info1 |
| 19. | BUSINESS_MEETING_DETAIL | expense_data_key | EXPENSE_DATA | fk_business_meeting_detail1 |
| 20. | CASH_RETURN_DETAIL | expense_data_key | EXPENSE_DATA | fk_cash_return_detail1 |
| 21. | CATEGORY_ASSIGNMENT | project_key | PROJECT | fk_category_assignment2 |
| 22. | CATEGORY_ASSIGNMENT | category_key | PROJECT_CATEGORY | fk_category_assignment1 |
| 23. | CELL_PHONE_DETAIL | expense_data_key | EXPENSE_DATA | fk_cell_phone_detail1 |
| 24. | COMPANY_CAR_DETAIL | expense_data_key | EXPENSE_DATA | fk_company_car_detail1 |
| 25. | CONTACT | person_key | PERSON | fk_contact1 |
| 26. | CONTACT_ADDRESS | address_key | ADDRESS | fk_contact_address2 |
| 27. | CONTACT_ADDRESS | address_type_key | ADDRESS_TYPE | fk_contact_address3 |
| 28. | CONTACT_ADDRESS | contact_key | CONTACT | fk_contact_address1 |
| 29. | CONTACT_EMAIL | contact_key | CONTACT | fk_contact_email1 |
| 30. | CONTACT_EMAIL | email_key | fk_contact_email2 | |
| 31. | CONTACT_EMAIL | email_type_key | EMAIL_TYPE | fk_contact_email3 |
| 32. | CONTACT_PHONE | contact_key | CONTACT | fk_contact_phone1 |
| 33. | CONTACT_PHONE | phone_key | PHONE | fk_contact_phone2 |
| 34. | CONTACT_PHONE | phone_type_key | PHONE_TYPE | fk_contact_phone3 |
| 35. | CREDIT_CARD | person_key | PERSON | fk_credit_card1 |
| 36. | CUSTOMER | parent_dept | CUSTOMER | fk_customer1 |
| 37. | CUSTOMER | customer_type_key | CUSTOMER_TYPE | fk_customer2 |
| 38. | CUSTOMER_ADDRESS | address_key | ADDRESS | fk_customer_address2 |
| 39. | CUSTOMER_ADDRESS | address_type_key | ADDRESS_TYPE | fk_customer_address3 |
| 40. | CUSTOMER_ADDRESS | customer_key | CUSTOMER | fk_customer_address1 |
| 41. | CUSTOMER_APPROVER | person_key | PERSON | fk_customer_approver |
| 42. | CUSTOMER_APPROVER | project_key | PROJECT | fk_customer_approver2 |
| 43. | CUSTOMER_ASSIGNMENT | customer_key | CUSTOMER | fk_customer_assignment1 |
| 44. | CUSTOMER_ASSIGNMENT | project_key | PROJECT | fk_customer_assignment2 |
| 45. | CUSTOMER_CONTACT | contact_key | CONTACT | fk_customer_contact2 |
| 46. | CUSTOMER_CONTACT | contact_type_key | CONTACT_TYPE | fk_customer_contact3 |
| 47. | CUSTOMER_CONTACT | customer_key | CUSTOMER | fk_customer_contact1 |
| 48. | CUSTOMER_EMAIL | customer_key | CUSTOMER | fk_customer_email1 |
| 49. | CUSTOMER_EMAIL | email_key | fk_customer_email2 | |
| 50. | CUSTOMER_EMAIL | email_type_key | EMAIL_TYPE | fk_customer_email3 |
| 51. | CUSTOMER_PHONE | customer_key | CUSTOMER | fk_customer_phone1 |
| 52. | CUSTOMER_PHONE | phone_key | PHONE | fk_customer_phone2 |
| 53. | CUSTOMER_PHONE | phone_type_key | PHONE_TYPE | fk_customer_phone3 |
| 54. | DEFAULT_TIME | person_key | PERSON | fk_default_time1 |
| 55. | DEFAULT_TIME_DATA | bill_customer | CUSTOMER | fk_default_time_data4 |
| 56. | DEFAULT_TIME_DATA | person_key | DEFAULT_TIME | fk_default_time_data1 |
| 57. | DEFAULT_TIME_DATA | pay_code_key | PAY_CODE | fk_default_time_data5 |
| 58. | DEFAULT_TIME_DATA | project_key | PROJECT | fk_default_time_data2 |
| 59. | DEFAULT_TIME_DATA | project_type_key | PROJECT_TYPE | fk_default_time_data6 |
| 60. | DEFAULT_TIME_DATA | task_key | TASK | fk_default_time_data3 |
| 61. | ENTERTAINMENT_DETAIL | expense_data_key | EXPENSE_DATA | fk_entertainment_detail1 |
| 62. | EXP_CUST_APPROVAL_STATUS | expense_report_key | EXPENSE_REPORT | fk_exp_cust_approval_status1 |
| 63. | EXP_CUST_APPROVAL_STATUS | project_key | PROJECT | fk_exp_cust_approval_status2 |
| 64. | EXPENSE_DATA | currency_key | CURRENCY | fk_expense_data2 |
| 65. | EXPENSE_DATA | expense_project_allocation_key | EXPENSE_PROJECT_ALLOCATION | fk_expense_data6 |
| 66. | EXPENSE_DATA | expense_report_key | EXPENSE_REPORT | fk_expense_data1 |
| 67. | EXPENSE_DATA | expense_type_key | EXPENSE_TYPE | fk_expense_data5 |
| 68. | EXPENSE_DATA | payment_method_key | PAYMENT_METHOD | fk_expense_data4 |
| 69. | EXPENSE_DATA | project_type_key | PROJECT_TYPE | fk_expense_data7 |
| 70. | EXPENSE_DATA | vendor_key | VENDOR | fk_expense_data3 |
| 71. | EXPENSE_DATA_ALLOCATION | expense_data_key | EXPENSE_DATA | fk_expense_data_allocation1 |
| 72. | EXPENSE_DATA_ALLOCATION | project_key | PROJECT | fk_expense_data_allocation2 |
| 73. | EXPENSE_DATA_ALLOCATION | task_key | TASK | fk_expense_data_allocation3 |
| 74. | EXPENSE_HISTORY | expense_report_key | EXPENSE_REPORT | fk_expense_history1 |
| 75. | EXPENSE_HISTORY | controller | PERSON | fk_expense_history2 |
| 76. | EXPENSE_HISTORY | performed_by | PERSON | fk_expense_history3 |
| 77. | EXPENSE_HISTORY | project_key | PROJECT | fk_expense_history4 |
| 78. | EXPENSE_HISTORY | role_key | ROLE | fk_expense_history5 |
| 79. | EXPENSE_PM_APPROVAL_STATUS | expense_report_key | EXPENSE_REPORT | fk_expense_pm_approval_status1 |
| 80. | EXPENSE_PM_APPROVAL_STATUS | project_key | PROJECT | fk_expense_pm_approval_status2 |
| 81. | EXPENSE_PROJECT_ALLOCATION | expense_report_key | EXPENSE_REPORT | fk_expense_project_allocation1 |
| 82. | EXPENSE_PROJECT_ALLOCATION | project_key | PROJECT | fk_expense_project_allocation2 |
| 83. | EXPENSE_PROJECT_ALLOCATION | task_key | TASK | fk_expense_project_allocation3 |
| 84. | EXPENSE_REPORT | owner_key | PERSON | fk_expense_report1 |
| 85. | EXPENSE_REPORT | creator_key | PERSON | fk_expense_report2 |
| 86. | EXPENSE_REPORT | controller_key | PERSON | fk_expense_report3 |
| 87. | EXPENSE_TYPE_VENDOR_ASSIGNMENT | expense_type_key | EXPENSE_TYPE | fk_etype_vendor_assignment2 |
| 88. | EXPENSE_TYPE_VENDOR_ASSIGNMENT | vendor_key | VENDOR | fk_etype_vendor_assignment1 |
| 89. | HISTORY_ALLOCATION | history_expense_report_key | HISTORY_EXPENSE_REPORT | fk_history_allocation1 |
| 90. | HISTORY_APPROVAL_HISTORY | history_expense_report_key | HISTORY_EXPENSE_REPORT | fk_history_approval_history1 |
| 91. | HISTORY_EXPENSE_DATA | history_allocation_key | HISTORY_ALLOCATION | fk_history_expense_data2 |
| 92. | HISTORY_EXPENSE_DATA | history_expense_report_key | HISTORY_EXPENSE_REPORT | fk_history_expense_data1 |
| 93. | HOLIDAY | project_key | PROJECT | fk_holiday1 |
| 94. | HOLIDAY | task_key | TASK | fk_holiday2 |
| 95. | HR | person_key | PERSON | fk_hr1 |
| 96. | LODGING_DETAIL | expense_data_key | EXPENSE_DATA | fk_lodging_detail1 |
| 97. | MANAGER_APPROVAL_STATUS | person_time_key | PERSON_TIME | fk_manager_approval_status1 |
| 98. | MANAGER_APPROVAL_STATUS | project_key | PROJECT | fk_manager_approval_status2 |
| 99. | MEMBER | person_key | PERSON | fk_member1 |
| 100. | MEMBER | role_key | ROLE | fk_member2 |
| 101. | MILEAGE_DETAIL | expense_data_key | EXPENSE_DATA | fk_mileage_detail1 |
| 102. | MPX_MAPPING | project_key | PROJECT | fk_mpx_mapping1 |
| 103. | MPX_MAPPING | task_key | TASK | fk_mpx_mapping2 |
| 104. | PAYROLL | person_key | PERSON | fk_payroll1 |
| 105. | PERSON | chain_key | CHAIN | fk_person2 |
| 106. | PERSON | expense_chain_key | CHAIN | fk_person6 |
| 107. | PERSON | customer_key | CUSTOMER | fk_person3 |
| 108. | PERSON | pay_code_key | PAY_CODE | fk_person5 |
| 109. | PERSON | time_period_key | TIME_PERIOD_SETUP | fk_person4 |
| 110. | PERSON_TIME | control_key | PERSON | fk_person_time1 |
| 111. | PERSON_TIME | person_key | PERSON | fk_person_time2 |
| 112. | PERSON_TIME | time_key | PERSON_TIME | fk_person_time3 |
| 113. | PERSON_TIME | time_period_key | TIME_PERIOD | fk_person_time4 |
| 114. | PERSON_TIME | begin_date | TIME_PERIOD | fk_person_time4 |
| 115. | PERSON_TIME_DATA | bill_customer | CUSTOMER | fk_person_time_data6 |
| 116. | PERSON_TIME_DATA | cost_customer | CUSTOMER | fk_person_time_data7 |
| 117. | PERSON_TIME_DATA | pay_code_key | PAY_CODE | fk_person_time_data1 |
| 118. | PERSON_TIME_DATA | person_time_key | PERSON_TIME | fk_person_time_data2 |
| 119. | PERSON_TIME_DATA | project_key | PROJECT | fk_person_time_data3 |
| 120. | PERSON_TIME_DATA | project_type_key | PROJECT_TYPE | fk_person_time_data4 |
| 121. | PERSON_TIME_DATA | task_key | TASK | fk_person_time_data5 |
| 122. | PERSON_TIME_DATA_HISTORY | bill_customer | CUSTOMER | fk_person_time_data_history7 |
| 123. | PERSON_TIME_DATA_HISTORY | cost_customer | CUSTOMER | fk_person_time_data_history8 |
| 124. | PERSON_TIME_DATA_HISTORY | pay_code_key | PAY_CODE | fk_person_time_data_history1 |
| 125. | PERSON_TIME_DATA_HISTORY | person_time_key | PERSON_TIME | fk_person_time_data_history2 |
| 126. | PERSON_TIME_DATA_HISTORY | time_data_key | PERSON_TIME_DATA | fk_person_time_data_history6 |
| 127. | PERSON_TIME_DATA_HISTORY | project_key | PROJECT | fk_person_time_data_history3 |
| 128. | PERSON_TIME_DATA_HISTORY | project_type_key | PROJECT_TYPE | fk_person_time_data_history4 |
| 129. | PERSON_TIME_DATA_HISTORY | task_key | TASK | fk_person_time_data_history5 |
| 130. | PO | bill_customer | CUSTOMER | fk_po1 |
| 131. | PO | cost_customer | CUSTOMER | fk_po2 |
| 132. | PO_ASSIGNMENT | person_key | PERSON | fk_po_assignment2 |
| 133. | PO_ASSIGNMENT | po_key | PO | fk_po_assignment1 |
| 134. | PROJECT | customer_key | CUSTOMER | fk_project1 |
| 135. | PROJECT | manager_key | PERSON | fk_project2 |
| 136. | PROJECT | project_status_key | PROJECT_STATUS | fk_project4 |
| 137. | PROJECT | project_type_key | PROJECT_TYPE | fk_project3 |
| 138. | PROJECT_ASSIGNMENT | bill_customer | CUSTOMER | fk_project_assignment3 |
| 139. | PROJECT_ASSIGNMENT | person_key | PERSON | fk_project_assignment1 |
| 140. | PROJECT_ASSIGNMENT | project_key | PROJECT | fk_project_assignment2 |
| 141. | PROJECT_CONTACT | contact_key | CONTACT | fk_project_contact2 |
| 142. | PROJECT_CONTACT | contact_type_key | CONTACT_TYPE | fk_project_contact3 |
| 143. | PROJECT_CONTACT | project_key | PROJECT | fk_project_contact1 |
| 144. | PROJECT_NOTE | creator_person_key | PERSON | fk_project_note2 |
| 145. | PROJECT_NOTE | modified_person_key | PERSON | fk_project_note3 |
| 146. | PROJECT_NOTE | project_key | PROJECT | fk_project_note1 |
| 147. | PROJECT_NOTE | project_note_type_key | PROJECT_NOTE_TYPE | fk_project_note4 |
| 148. | PTD_AUDIT_TRAIL | pay_code_key | PAY_CODE | fk_ptd_audit_trail1 |
| 149. | PTD_AUDIT_TRAIL | audit_user_key | PERSON | fk_ptd_audit_trail2 |
| 150. | PTD_AUDIT_TRAIL | project_key | PROJECT | fk_ptd_audit_trail3 |
| 151. | PTD_AUDIT_TRAIL | project_type_key | PROJECT_TYPE | fk_ptd_audit_trail4 |
| 152. | PTD_AUDIT_TRAIL | task_key | TASK | fk_ptd_audit_trail5 |
| 153. | REQUEST_ALLOCATION | request_expense_report_key | REQUEST_EXPENSE_REPORT | fk_request_allocation1 |
| 154. | REQUEST_EXPENSE_DATA | request_allocation_key | REQUEST_ALLOCATION | fk_request_expense_data2 |
| 155. | REQUEST_EXPENSE_DATA | request_expense_report_key | REQUEST_EXPENSE_REPORT | fk_request_expense_data1 |
| 156. | STANDARD_MILEAGE_TO | stand_mileage_from_key | STANDARD_MILEAGE_FROM | fk_standard_mileage_to1 |
| 157. | TASK | project_key | PROJECT | fk_task2 |
| 158. | TASK | parent_task | TASK | fk_task1 |
| 159. | TASK_ASSIGNMENT | bill_customer | CUSTOMER | fk_task_assignment1 |
| 160. | TASK_ASSIGNMENT | project_key | PROJECT_ASSIGNMENT | fk_task_assignment2 |
| 161. | TASK_ASSIGNMENT | person_key | PROJECT_ASSIGNMENT | fk_task_assignment2 |
| 162. | TASK_ASSIGNMENT | task_key | TASK | fk_task_assignment3 |
| 163. | TIME_CUST_APPROVAL_STATUS | person_time_key | PERSON_TIME | fk_time_cust_approval_status1 |
| 164. | TIME_CUST_APPROVAL_STATUS | project_key | PROJECT | fk_time_cust_approval_status2 |
| 165. | TIME_PERIOD | time_period_key | TIME_PERIOD_SETUP | fk_time_period1 |
| 166. | TIME_PERIOD_HISTORY | person_key | PERSON | fk_time_period_history1 |
| 167. | TIME_PERIOD_HISTORY | time_period_key | TIME_PERIOD_SETUP | fk_time_period_history2 |
| 168. | TIME_PERIOD_SETUP | code | VALID_TIME_PERIOD | fk_time_period_setup1 |
| 169. | VALID_PAYCODE | pay_code_key | PAY_CODE | fk_valid_paycode2 |
| 170. | VALID_PAYCODE | project_key | PROJECT | fk_valid_paycode1 |