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 |