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