Affinity Table (Phase 4)
| Field Name | Data Type | Constraints | Default Value | Description |
|---|---|---|---|---|
|
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_Quota1_Amt | Int | Not NULL | 0 |
Agreed amount of disk space in Quota space 1 |
|
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 |