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 |