erm_agreements

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
agreement_id INT 10 √ null
erm_agreement_licenses.agreement_id erm_agreement_licenses_ibfk_1 C
erm_agreement_periods.agreement_id erm_agreement_periods_ibfk_1 C
erm_agreement_relationships.agreement_id erm_agreement_relationships_ibfk_1 C
erm_agreement_relationships.related_agreement_id erm_agreement_relationships_ibfk_2 C
erm_documents.agreement_id erm_documents_ibfk_1 C
erm_eholdings_packages_agreements.agreement_id erm_eholdings_packages_agreements_ibfk_2 C
erm_user_roles.agreement_id erm_user_roles_ibfk_1 C

primary key
vendor_id INT 10 √ null
aqbooksellers.id erm_agreements_ibfk_1 N

foreign key to aqbooksellers
name VARCHAR 255 null
items_search_fields.name Implied Constraint R

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

Indexes

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

Relationships

Close relationships within degrees of separation