0 rows


Column Type Size Nulls Auto Default Children Parents Comments
agreement_id INT 10 null
erm_agreement_licenses.agreement_id erm_agreement_licenses_ibfk_1C
erm_agreement_periods.agreement_id erm_agreement_periods_ibfk_1C
erm_agreement_relationships.agreement_id erm_agreement_relationships_ibfk_1C
erm_agreement_relationships.related_agreement_id erm_agreement_relationships_ibfk_2C
erm_documents.agreement_id erm_documents_ibfk_1C
erm_eholdings_packages_agreements.agreement_id erm_eholdings_packages_agreements_ibfk_2C
erm_user_roles.agreement_id erm_user_roles_ibfk_1C

primary key

vendor_id INT 10 null erm_agreements_ibfk_1N

foreign key to aqbooksellers

name VARCHAR 255 null Implied ConstraintR

name of the agreement

description LONGTEXT 2147483647 null

description of the agreement

status VARCHAR 80 null

current status of the agreement

closure_reason VARCHAR 80 null

reason of the closure

is_perpetual BIT 0 0

is the agreement perpetual

renewal_priority VARCHAR 80 null

priority of the renewal

license_info VARCHAR 80 null

info about the license


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc agreement_id
erm_agreements_ibfk_1 Performance Asc vendor_id