psa.Cards

Overview
Column Descriptions

id –
personalName –
companyName –
phone –
fax –
email –
address –
city –
state –
zip –
country –

Table Structure
1
2
3
4
5
6
7
8
9
10
11
12
13
14

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

January 16th, 2013 in Uncategorized | tags: