Portfolio Tempdata Table Schema (portfolio_tempdata)


Description

stores temporary data for portfolio exports. the id of this table is used for the itemid for the temporary files area. cron can clean up stale records (and associated file data) after expirytime.

portfolio_tempdata table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
portfolio_mahara_queue.transferid portmahaqueu_tra2_fk R
data LONGTEXT 2147483647 √ null

dumping ground for portfolio callers to store their data in.
expirytime BIGINT 19 null

time this record will expire (used for cron cleanups) - the start of export + 24 hours
userid BIGINT 19 null
user.id porttemp_use2_fk R

psuedo fk to user. this is stored in the serialised data structure in the data field, but added here for ease of lookups.
instance BIGINT 19 √ 0
portfolio_instance.id porttemp_ins2_fk R

which portfolio plugin instance is being used
queued BIT 1 0

Value 1 means the entry should be processed in cron.

Table contained -1 rows

portfolio_tempdata table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
porttemp_ins_ix Performance Asc instance
porttemp_use_ix Performance Asc userid

portfolio_tempdata table relationships

Close relationships within degrees of separation