contact

Type: table

Columns

Column	Type	Attributes	Description
accountrowid	int
addressrowid	int
alternatephonenbr	varchar
attention	varchar
companyname	varchar
companyrowid	int
contactid	varchar
contacttypelistitemrowid	int
description	varchar
emailaddress	varchar
faxnbr	varchar
firstactivitydate	datetime
firstname	varchar
isactive	tinyint
jobrowid	int
languagelistitemrowid	varchar
lastname	varchar
mailtoname	varchar
middlename	varchar
mobilenbr	varchar
noterowid	int
phonenbr	varchar
relationshiprowid	int
rowid	int	auto_increment
salespersonrelationshiprowid	int
suffix	varchar
taskrowid	int
title	varchar
transactionrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
userrowid	int

v.ismain -- Wed, Feb 28, 2018 2:58 PM