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