erm_documents

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
document_id INT 10 √ null

primary key
agreement_id INT 10 √ NULL
erm_agreements.agreement_id erm_documents_ibfk_1 C

link to the agreement
license_id INT 10 √ NULL
erm_licenses.license_id erm_documents_ibfk_2 C

link to the license
file_name VARCHAR 255 √ NULL
items_search_fields.name Implied Constraint R

name of the file
file_type VARCHAR 255 √ NULL

type of the file
file_description VARCHAR 255 √ NULL

description of the file
file_content LONGBLOB 2147483647 √ NULL

the content of the file
uploaded_on DATETIME 19 √ NULL

datetime when the file as attached
physical_location VARCHAR 255 √ NULL

physical location of the document
uri VARCHAR 255 √ NULL

URI of the document
notes MEDIUMTEXT 16777215 √ NULL

notes about this relationship

Indexes

Constraint Name Type Sort Column(s)
erm_documents_s_pk Primary key Asc document_id
erm_documents_ibfk_1 Performance Asc agreement_id
erm_documents_ibfk_2 Performance Asc license_id
PRIMARY Must be unique Asc document_id

Relationships

Close relationships within degrees of separation