Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| employeeid | int | 4 | √ | null |
|
|
Employee reference - Reference to the internal employee assigned as account manager |
|
| agencyid | int | 4 | √ | null |
|
|
Agency reference - Reference to the client agency being managed (foreign key to Agency.AgencyID) |
|
| billingtype | int | 4 | √ | null |
|
|
Billing type assignment - Specific billing method or type assigned to this agency relationship |