| con_id | int(11) | NO | | PRI | auto_increment | |
| con_name | varchar(80) | NO | | | | This DB column has been deprecated |
| con_fname | varchar(45) | NO | | | | Column can also be used as company name |
| con_lname | varchar(45) | NO | | | | |
| con_email | varchar(80) | NO | | | | |
| con_company | varchar(40) | NO | | | | |
| con_title | varchar(40) | NO | | | | |
| con_address1 | varchar(40) | NO | | | | |
| con_address2 | varchar(40) | NO | | | | |
| con_city | varchar(30) | NO | | | | |
| con_state | varchar(2) | NO | | | | |
| con_zip | varchar(5) | NO | | | | |
| con_zip_plus4 | varchar(4) | NO | | | | |
| con_phone_office | varchar(40) | NO | | | | |
| con_phone_cell | varchar(40) | NO | | | | |
| con_phone_other | varchar(40) | NO | | | | |
| con_fax | varchar(40) | NO | | | | |
| con_website | varchar(40) | NO | | | | |
| con_notes | text | NO | | | | |
| con_party | char(1) | NO | | | | |
| con_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| con_created | timestamp | YES | CURRENT_TIMESTAMP | | | |