erm_licenses

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
license_id INT 10 √ null
erm_agreement_licenses.license_id erm_agreement_licenses_ibfk_2C
erm_documents.license_id erm_documents_ibfk_2C
erm_user_roles.license_id erm_user_roles_ibfk_2C

primary key
vendor_id INT 10 √ null
aqbooksellers.id erm_licenses_ibfk_1N

foreign key to aqbooksellers
name VARCHAR 255 null
items_search_fields.name Implied ConstraintR

name of the license
description LONGTEXT 2147483647 √ null

description of the license
type VARCHAR 80 null

type of the license
status VARCHAR 80 null

current status of the license
started_on DATE 10 √ null

start of the license
ended_on DATE 10 √ null

end of the license

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc license_id
erm_licenses_ibfk_1 Performance Asc vendor_id

Relationships

Close relationships within degrees of separation