Portfolio Log Table Schema (portfolio_log)


log of portfolio transfers (used to later check for duplicates)

portfolio_log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 null
user.id portlog_use2_fk R

user who exported content

time bigint 10 null

time of transfer (in the case of a queued transfer this is the time the actual transfer ran, not when the user started)

portfolio bigint 10 null
portfolio_instance.id portlog_por2_fk R

fk to portfolio_instance

caller_class varchar 150

the name of the class used to create the transfer

caller_file varchar 255

path to file to include where the class definition lives. (relative to dirroot)

caller_component varchar 255 null

the component name responsible for exporting

caller_sha1 varchar 255

sha1 of exported content as far as the caller is concerned (before the portfolio plugin gets a hold of it)

tempdataid bigint 10 0

old id from portfolio_tempdata. This is so that we can gracefully catch a race condition between an external system requesting a file and causing the tempdata to be deleted, before the user gets the "your transfer is requested" page

returnurl varchar 255

the original "returnurl" of the export - takes us to the moodle page we started from

continueurl varchar 255

the url the external system has set to view the transfer

Table contained -1 rows

portfolio_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
portlog_por_ix Performance Asc portfolio
portlog_use_ix Performance Asc userid

portfolio_log table relationships