Table: customer_address

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK customer_address_key decimal(15)      
2.   customer_key decimal(15)   customer fk_customer_address1
3.   address_key decimal(15)   address fk_customer_address2
4.   default_bill_to char(1) ('N')    
5.   default_ship_to char(1) ('N')    
6.   default_remit_to char(1) ('N')    
Foreign Keys
Column References Foreign Key Name
Table Column
address_key address address_key fk_customer_address2
customer_key customer customer_key fk_customer_address1
Referenced from
Table Column Foreign Key Name
project_invoice bill_to_address_key fk_project_invoice6
project_invoice remit_to_address_key fk_project_invoice8
project_invoice ship_to_address_key fk_project_invoice10
Check Constraints
Name Definition
cc_cust_addr_bill ([default_bill_to]='N' OR [default_bill_to]='Y')
cc_cust_addr_remit ([default_remit_to]='N' OR [default_remit_to]='Y')
cc_cust_addr_ship ([default_ship_to]='N' OR [default_ship_to]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_customer_address true customer_address_key Asc
idx_customer_address2 true customer_key Asc
    address_key  
idx_customer_address1 false customer_key Asc
idx_customer_address3 false address_key Asc