erm_agreement_relationships

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
agreement_id INT 10 null
erm_agreements.agreement_id erm_agreement_relationships_ibfk_1 C

link to the agreement

related_agreement_id INT 10 null
erm_agreements.agreement_id erm_agreement_relationships_ibfk_2 C

link to the related agreement

relationship enum('supersedes', 'is-superseded-by', 'provides_post-cancellation_access_for', 'has-post-cancellation-access-in', 'tracks_demand-driven_acquisitions_for', 'has-demand-driven-acquisitions-in', 'has_backfile_in', 'has_frontfile_in', 'related_to') 37 null

relationship between the two agreements

notes MEDIUMTEXT 16777215 null

notes about this relationship

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc agreement_id + related_agreement_id
erm_agreement_relationships_ibfk_2 Performance Asc related_agreement_id

Relationships