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_2 C
erm_documents.license_id erm_documents_ibfk_2 C
erm_user_roles.license_id erm_user_roles_ibfk_2 C

primary key
vendor_id INT 10 √ NULL
aqbooksellers.id erm_licenses_ibfk_1 N

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

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