Affinity_Number

String (10)

Primary Key

Affinity_Name

String (50)

Not NULL

Name of group or organization entering into an affinity relationship with GPFN

Affinity_Contact_ LastName

String (30)

Not NULL

Name of contact person with the group or organization

Affinity_Contact_ FirstName

String (20)

Not NULL

Affinity_StreetAddress1

String (30)

Not NULL

Affinity_StreetAddress2

String (30)

Affinity_City

 String (30)

Not NULL

Affinity_Province

String (30)

Not NULL

Affinity_Country

 String (30)

Not NULL

Affinity_PostalCode

String (30)

Not NULL

Affinity_Phone

String (20)

Not NULL

Affinity_Ind_Mem_Price

Float

Not NULL

0.00

Agreed price of individual memberships under this affinity agreement

Affinity_Ind_Mem_Max_ Count

Int

Not NULL

0

Agreed maximum number of individual memberships to be sold under this affinity agreement

Affinity_PPP_Price

Float

Not NULL

0.00

Agreed price of PPP connections under this affinity agreement

Affinity_PPP_Max_Count

Int

Not NULL

0

Agreed maximum number of PPP connections to be sold under this affinity agreement

Affinity_Quota2_Amt

Int

Not NULL

0

Agreed amount of disk space in Quota space 2

Affinity_Quota2_Amt

Int

Not NULL

0

Agreed amount of disk space in Quota space 2

Affinity_Quota_Max_ Count

Int

Not NULL

0

Agreed maximum number of members who benefit from the increased quota limits under this affinity

Affinity_Annual_ Agreement_Fee

Float

Not NULL

0.00

Annual Fee to be invoiced to the Affinity_Name for the terms of the affinity agreement

Affinity_EnteredBy

String (16)

Not NULL

The name of the GPFN Volunteer adding or editing the affinity to the system