# portfolio_tempdata

0 rows

### 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.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
portfolio_log.tempdataid | portlog_tem2_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