portfolio_tempdata

0 rows


Description

stores temporary data for portfolio exports. the id of this

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
portfolio_log.tempdataid portlog_tem2_fkR
portfolio_mahara_queue.transferid portmahaqueu_tra2_fkR
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_fkR

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_fkR

which portfolio plugin instance is being used

queued BIT 1 0

Value 1 means the entry should be processed in cron.

Indexes

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

Relationships