Portfolio Instance Table Schema (portfolio_instance)


Description

base table (not including config data) for instances of portfolio plugins.

portfolio_instance table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
portfolio_instance_config.instance portinstconf_ins2_fk R
portfolio_instance_user.instance portinstuser_ins2_fk R
portfolio_log.portfolio portlog_por2_fk R
portfolio_tempdata.instance porttemp_ins2_fk R
plugin VARCHAR 50

fk to plugin
name VARCHAR 255

name of plugin instance
visible BIT 1 1

whether this instance is visible or not

Table contained -1 rows

portfolio_instance table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

portfolio_instance table relationships

Close relationships within degrees of separation