Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgencyID | int | 4 | null |
|
|
Agency identifier - Reference to the agency |
||
| CompanyName | varchar | 50 | √ | null |
|
|
Agency name - Official business name for display |
|
| ProviderID | varchar | 15 | null |
|
|
Provider identifier - External provider ID for billing |
||
| Category | varchar | 20 | √ | null |
|
|
Agency category - Business classification |
|
| URL | varchar | 126 | √ | null |
|
|
Signup URL - Dynamic URL for agency signup based on agreement type |
|
| AgreementType | varchar | 100 | √ | null |
|
|
Agreement type - Current service agreement classification |
|
| SignupCode | uniqueidentifier | 16 | √ | null |
|
|
Signup code - Unique identifier for registration process |