Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgreementTypeID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| ParentAgreementType | varchar | 100 | null |
|
|
Type classification - Category or classification type for AgreementTypeLink records |
||
| AgreementType | varchar | 100 | null |
|
|
Type classification - Category or classification type for AgreementTypeLink records |
||
| fkChildAgreementTypeID | Unknown | 0 | null |
|
|
Child agreement type - Reference to the dependent or derived agreement type |
||
| fkParentAgreementTypeID | Unknown | 0 | null |
|
|
Parent agreement type - Reference to the parent or base agreement type |
||
| LinkType | Unknown | 0 | null |
|
|
Link type - Type of relationship (Upgrade, Downgrade, Alternative, etc.) |
||
| pkAgreementTypeLinkID | Unknown | 0 | null |
|
|
Primary key - AgreementTypeLink unique identifier for each agreement type relationship |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AgreementTypeLink | Primary key | Asc | AgreementTypeID |