Table: billing_info
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
vendor_key |
decimal(15) |
|
vendor |
fk_billing_info1 |
| 2. |
|
contact_first_name |
varchar(50) |
|
|
|
| 3. |
|
contact_last_name |
varchar(50) |
|
|
|
| 4. |
|
street1 |
varchar(100) |
|
|
|
| 5. |
|
street2 |
varchar(100) |
|
|
|
| 6. |
|
city |
varchar(50) |
|
|
|
| 7. |
|
state |
varchar(5) |
|
|
|
| 8. |
|
zip |
varchar(9) |
|
|
|
| 9. |
|
account_number |
varchar(255) |
|
|
|
| 10. |
|
email |
varchar(100) |
|
|
|
| 11. |
|
phone |
varchar(25) |
|
|
|
| 12. |
|
fax |
varchar(25) |
|
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| vendor_key |
vendor |
vendor_key |
fk_billing_info1 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_billing_info |
true |
vendor_key |
Asc |