StreamNet

MitContact Table

Many to one relationships with the MitParticipant and MitOwnership tables via ContactID.

Field Name Field Description Data Type Field Size*

ContactID Code for participant's contact or project manager smallint 2

LastName Family name of contact person varchar 20

FirstName Given name of contact person varchar 20

Title Job title of contact person varchar 80

Address1 Mailing address line 1 for contact varchar 255

Address2 Mailing address line 2 for contact varchar 255

City The town where mail is received. varchar 20

StateID The identifier code for the state. Cross reference to State table. tinyint 1

Zip The zip code varchar 10

Phone Phone number(s) of contact varchar 50

Fax Fax number(s) of contact. varchar 50

Email E-mail address(es) of contact. varchar 50

Comments Additional information or comments. text 16

AddUpd Indicates whether a record has been added or updated. bit 1

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.

Field Name	Field Description	Data Type	Field Size*
ContactID	Code for participant's contact or project manager	smallint	2
LastName	Family name of contact person	varchar	20
FirstName	Given name of contact person	varchar	20
Title	Job title of contact person	varchar	80
Address1	Mailing address line 1 for contact	varchar	255
Address2	Mailing address line 2 for contact	varchar	255
City	The town where mail is received.	varchar	20
StateID	The identifier code for the state. Cross reference to State table.	tinyint	1
Zip	The zip code	varchar	10
Phone	Phone number(s) of contact	varchar	50
Fax	Fax number(s) of contact.	varchar	50
Email	E-mail address(es) of contact.	varchar	50
Comments	Additional information or comments.	text	16
AddUpd	Indicates whether a record has been added or updated.	bit	1

MitContact Table

Revised Wednesday September 28 2005