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