It represents the relationship between two contracts
Data model
Fields
| Field | Type | Description |
|---|---|---|
| child_id* | INT | Unique identifier of the child contract, reference table ASMS_CONTRACT. ContractId |
| parent_id* | INT | Unique identifier of the parent contract, reference table ASMS_CONTRACT. ContractId |
Primary Key
| PK_ASMS_CONTRACT_SELF |
|---|
| parent_id, child_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| child_id* | dbo.ASMS_CONTRACT | contractid | FK02_ASMS_CONTRACT_SELF |
| parent_id* | dbo.ASMS_CONTRACT | contractid | FK01_ASMS_CONTRACT_SELF |