recbill_cc

recbill_cc

recbill_cc

Column name Type Null Default Description
userid int unsigned   0  
instime int unsigned   0  
modtime int unsigned   0  
expmail int unsigned YES  
pri_flag enum('0','1')   0  
type enum('Visa','MasterCard','AmEx','DinersClub','Discover','CarteBlanche','JCB') YES  
exp_y smallint unsigned   0  
exp_m tinyint unsigned   0  
lastfour varchar(4)    
name_first varchar(20)    
name_last varchar(20)    
phone_num varchar(32)    
addr varchar(120)    
city varchar(50)    
state varchar(65)    
postal_code varchar(15)    
country char(3)    
email varchar(50) YES  
Key name Type Column(s)
exp_y INDEX
userid UNIQUE