app_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 bigserial 19 √ nextval('app_portfolio_tempdata_id_seq'::regclass)
data text 2147483647 √ null
expirytime int8 19 null
userid int8 19 null
app_user.id Defined in XMLR
instance int8 19 √ 0
app_portfolio_instance.id Defined in XMLR
queued int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_porttemp_id_pk Primary key Asc id
app_porttemp_ins_ix Performance Asc instance
app_porttemp_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation