psa.Cards

Overview
Column Descriptions

id
personalName
companyName
phone
fax
email
address
city
state
zip
country

Table Structure
CREATE TABLE `Cards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `personalName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `companyName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET ascii DEFAULT NULL,
  `fax` varchar(255) CHARACTER SET ascii DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `country` varchar(2) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 

Related documentation

Leave a comment

Your comment