Show 

Table: contact_email

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK contact_email_key decimal(15)      
2.   customer_contact_key decimal(15)   customer_contact fk_contact_email1
3.   contact_email_type_key decimal(15)   contact_email_type fk_contact_email2
4.   email varchar(255)      
5.   primary_ind char(1) ('N')    
Foreign Keys
Column References Foreign Key Name
Table Column
contact_email_type_key contact_email_type contact_email_type_key fk_contact_email2
customer_contact_key customer_contact customer_contact_key fk_contact_email1
Check Constraints
Name Definition
cc_contact_email_primary ([primary_ind]='N' OR [primary_ind]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_contact_email true contact_email_key Asc
idx_contact_email1 false customer_contact_key Asc