Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AgreementName | Unknown | 0 | null |
|
|
Agreement name - Descriptive name or title of the agreement |
||||||||
| AgreementType | varchar | 100 | null |
|
|
Agreement type - Classification of agreement (Standard, Custom, Enterprise, Trial, etc.) |
||||||||
| AutoRenewal | Unknown | 0 | null |
|
|
Auto-renewal flag - Whether the agreement automatically renews |
||||||||
| ComplianceRequirements | Unknown | 0 | null |
|
|
Compliance requirements - Regulatory and compliance obligations |
||||||||
| ContractValue | Unknown | 0 | null |
|
|
Contract value - Total monetary value of the agreement |
||||||||
| fkAgencyID | int | 4 | null |
|
|
Agency reference - Reference to the agency bound by this agreement (foreign key to Agency.AgencyID) |
||||||||
| DateofAgreement | smalldatetime | 16 | null |
|
|
Date/time field - Date and time when ofagreement occurred or was recorded |
||||||||
| DigitalSignature | varchar | 100 | null |
|
|
Text field - DigitalSignature text information for Agreement records |
||||||||
| FirstName | varchar | 50 | null |
|
|
Name field - Descriptive name or identifier for Agreement records |
||||||||
| LastName | varchar | 50 | null |
|
|
Name field - Descriptive name or identifier for Agreement records |
||||||||
| EmailAddress | varchar | 100 | null |
|
|
Email address - Email contact information for Agreement communications |
||||||||
| EndDate | Unknown | 0 | null |
|
|
End date - Date when the agreement expires or terminates |
||||||||
| IPAddress | varchar | 50 | null |
|
|
Address information - Geographic location data for Agreement records |
||||||||
| OS | varchar | 50 | √ | null |
|
|
Text field - OS text information for Agreement records |
|||||||
| Browser | varchar | 50 | √ | null |
|
|
Text field - Browser text information for Agreement records |
|||||||
| PaymentTerms | Unknown | 0 | null |
|
|
Payment terms - Payment schedule and terms (Net 30, Monthly, etc.) |
||||||||
| pkAgreementID | int identity | 4 | √ | null |
|
|
Primary key - Agreement unique identifier for each record |
|||||||
| Phone | varchar | 15 | null |
|
|
Phone number - Contact phone number for Agreement communications |
||||||||
| RenewalTerms | Unknown | 0 | null |
|
|
Renewal terms - Conditions and terms for agreement renewal |
||||||||
| ServiceLevel | Unknown | 0 | null |
|
|
Service level - Level of support and service guaranteed |
||||||||
| StartDate | Unknown | 0 | null |
|
|
Start date - Date when the agreement becomes effective |
||||||||
| Title | varchar | 100 | null |
|
|
Text field - Title text information for Agreement records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Agreement | Primary key | Asc | pkAgreementID |