VENDOR |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| vendor_key | decimal (15,0) | |||
| name | varchar (255) | |||
| prefered | varchar (1) | YES | ||
References made to VENDOR |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| BILLING_INFO | vendor_key | fk_billing_info1 |
| EXPENSE_DATA | vendor_key | fk_expense_data3 |
| EXPENSE_TYPE_VENDOR_ASSIGNMENT | vendor_key | fk_etype_vendor_assignment1 |
Dependent Views |
|
| View Name | |
|---|---|
| VENDOR_ASSIGNED_VIEW | |
Indexes on VENDOR |
|
| Index Name | Column(s) |
|---|---|
| pk_vendor | vendor_key |